mcp-node-mssql

@cwilby

About mcp-node-mssql

MCP Server for SQL Server using node-mssql

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "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>"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Frequently asked questions

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

Comments

Basic information

More Databases MCP servers

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K