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