MCP.so
登录

mcp-node-mssql

@cwilby

代码仓库

关于 mcp-node-mssql

MCP Server for SQL Server using 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>"
      }
    }
  }
}

工具

未检测到工具

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

概览

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

—

FAQ from mcp-node-mssql

—

What versions of SQL Server are supported?

—

How do I report an issue or get help?

Open an issue on the GitHub repository.

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.

常见问题

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`.

评论

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

cwilby

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

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 Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K