Advertise
MCP.so
Sign In

MCP Node Mssql

@cwilby

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

cwilby

About MCP Node Mssql

MCP Server for SQL Server using node-mssql

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

MCP Node Mssql tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

—

Frequently asked questions

1

How do I report an issue or get help?

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

2

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

More Databases MCP servers

Elasticsearch MCP Server

elastic

685

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

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397
Advertise