广告合作
MCP.so
登录

Sql Server MCP Server

@hendrickcastro

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

hendrickcastro

提交者

H. C.

关于 Sql Server MCP Server

A comprehensive Model Context Protocol (MCP) server for SQL Server database operations. This server provides 10 powerful tools for database analysis, object discovery, and data manipulation through the MCP protocol.

#mcp#modelcontextprotocol#sqlserver#azuresql#database#databaseanalysis#databasetools#mssql#tsql

Sql Server MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcpql": {
      "command": "npx",
      "args": [
        "-y",
        "hendrickcastro/mcpql"
      ],
      "env": {
        "DB_AUTHENTICATION_TYPE": "sql",
        "DB_SERVER": "your_server",
        "DB_NAME": "your_database",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password",
        "DB_PORT": "1433",
        "DB_ENCRYPT": "false",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Sql Server MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is Sql Server Mcp?

Sql Server Mcp is a comprehensive Model Context Protocol (MCP) server for SQL Server database operations. It provides 10 tools for database analysis, object discovery, and data manipulation through the MCP protocol. The server is designed for developers and DBAs using MCP-compatible clients like Claude Desktop or Cursor IDE.

How to use Sql Server Mcp?

Installation is recommended via npx with no local setup required. Configure your MCP client (e.g., Claude Desktop or Cursor IDE) with the command npx -y hendrickcastro/mcpql and set the required environment variables for database connection. Alternatively, clone the repository, run npm install and npm run build, then point your MCP client to the built server file.

Key features of Sql Server Mcp

  • 10 dedicated MCP tools for SQL Server operations
  • Supports SQL Server, SQL Server Express, and Azure SQL
  • SQL, Windows, and Azure AD authentication
  • Connection pooling and comprehensive timeout settings
  • Docker-ready and security audited
  • Configurable via environment variables or connection string

Use cases of Sql Server Mcp

  • Analyze table structures, indexes, and constraints via MCP tools
  • Execute custom SQL queries and stored procedures with parameters
  • Search database objects by name and definition across the entire database
  • Preview data and get column statistics for quick analysis
  • Discover object dependencies for tables, views, and procedures

常见问题

1

What databases does Sql Server Mcp support?

It supports SQL Server 2016+, SQL Server Express (named instances), and Azure SQL Database.

2

What authentication types are available?

Sql Server Mcp supports SQL Server Authentication, Windows Authentication, and Azure Active Directory Authentication (including service principals).

3

Do I need to install anything locally to use Sql Server Mcp?

No. You can use `npx -y hendrickcastro/mcpql` directly – no local installation required.

4

What are the required environment variables?

At minimum, you must set `DB_AUTHENTICATION_TYPE`, `DB_SERVER`, and `DB_NAME`. For SQL auth, also set `DB_USER` and `DB_PASSWORD`. See the README for the full variable table.

5

How is data privacy handled?

The server connects directly to your SQL Server instance; data stays on your database. All configuration is done through environment variables or a connection string.

评论

数据库 分类下的更多 MCP 服务器

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K
广告合作