MCP.so
登录

MS SQL Server MCP Server

@bymcs

代码仓库

关于 MS SQL Server MCP Server

暂无概览

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

bymcs

配置

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

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": [
        "-y",
        "mssql-mcp@latest"
      ],
      "env": {
        "DB_SERVER": "your-server.com",
        "DB_DATABASE": "your-database",
        "DB_USER": "your-username",
        "DB_PASSWORD": "your-password",
        "DB_PORT": "1433",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MS SQL Server MCP Server?

A Model Context Protocol (MCP) server for Microsoft SQL Server, compatible with Claude Desktop, Cursor, Windsurf, and VS Code. It provides a set of tools for AI assistants to connect to and interact with SQL Server databases, execute queries, explore schemas, and manage connections.

How to use MS SQL Server MCP Server?

Install globally via npm install -g mssql-mcp. Configure an MCP server entry in your IDE’s config file (e.g., claude_desktop_config.json or .vscode/mcp.json) with environment variables for the database connection. The server runs in stdio mode by default for local IDEs, or can be switched to http mode for remote deployments.

Key features of MS SQL Server MCP Server

  • Connection management: connect, disconnect, and check status.
  • Execute arbitrary SQL queries (mutation‑capable).
  • List schema objects (tables, views, procedures, functions) with pagination.
  • Describe table columns with full definitions.
  • Read table rows with pagination, projection, and safe WHERE clauses.
  • Execute stored procedures.
  • List all databases on the instance.
  • Response format selectable between JSON and markdown.

Use cases of MS SQL Server MCP Server

  • Allow Claude or other MCP clients to explore and query a SQL Server database.
  • Enable AI assistants to retrieve table schemas and row data for context.
  • Execute stored procedures from within an AI‑powered IDE.
  • Perform database debugging and ad‑hoc SQL queries via natural language.
  • Integrate SQL Server data into automated workflows in VS Code, Cursor, or Windsurf.

FAQ from MS SQL Server MCP Server

What are the runtime dependencies?

Node.js (via npm) and a network‑accessible SQL Server instance. The server uses the @modelcontextprotocol/sdk pinned to 1.28.0.

How are credentials configured and secured?

All connection settings (server, database, user, password) are read only from environment variables — never from tool parameters. The server enforces that credentials cannot be overridden at runtime.

What transport modes are available?

Two modes: stdio (default) for local IDE integration (Claude Desktop, Cursor, VS Code) and http for remote or hosted deployments. The HTTP binding can be customized with environment variables.

Is the server completely read‑only?

No. Tools like mssql_run_sql_query and mssql_execute_stored_procedure are explicitly labeled as non‑read‑only and can mutate data. Read‑only tools are marked with a ✅ badge in the tool catalog.

What security measures are built in?

Identifier validation, parameterized queries, HTTP origin validation (localhost by default), and a recommendation to use a least‑privilege SQL login. The server never embeds user‑supplied values directly into SQL strings.

评论

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

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204