MCP Node Mssql

@cwilby

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

cwilby

关于 MCP Node Mssql

MCP Server for SQL Server using node-mssql

MCP Node Mssql 配置

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

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-node-mssql"
      ],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "1433",
        "DB_USERNAME": "<username>",
        "DB_PASSWORD": "<password>",
        "DB_DATABASE": "<database>"
      }
    }
  }
}

MCP Node Mssql 工具

工具列表暂未提供

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

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

概览

What is mcp-node-mssql?

mcp-node-mssql is an MCP (Model Context Protocol) server that allows AI assistants like Cursor, Windsurf, and Claude Code to connect to a Microsoft SQL Server database. It is intended for developers who want to give their AI coding tools direct database access.

How to use mcp-node-mssql?

Configure the server in the client’s MCP JSON file (e.g., ~/.cursor/mcp.json, <project>/.cursor/mcp.json, or ~/.claude.json) by setting the command to npx with the package name mcp-node-mssql and providing the required environment variables (DB_HOST, DB_PORT, DB_USERNAME, DB_PASSWORD, DB_DATABASE, etc.). After saving, restart the AI assistant to load the server.

Key features of mcp-node-mssql

Connects to Microsoft SQL Server databases.
Configurable connection and request timeouts.
Runs via npx with no manual installation.
Supports local development builds for testing.
Integrates with Cursor, Windsurf, and Claude Code.

Use cases of mcp-node-mssql

—

常见问题

How do I report an issue or get help?

Open an issue on the [GitHub repository](https://github.com/cwilby/mcp-node-mssql/issues).

What environment variables are required?

`DB_HOST`, `DB_PORT`, `DB_USERNAME`, `DB_PASSWORD`, and `DB_DATABASE` must be set. Optional variables include `CONNECTION_TIMEOUT`, `REQUEST_TIMEOUT`, `DB_ENCRYPT`, `DB_ENABLE_ARITH_ABORT`, `DB_TRUST_SERVER_CERTIFICATE`, and `TRUSTED_CONNECTION`.