Node MSSQL

Node MSSQL is an MCP server that enables AI clients to connect to and interact with Microsoft SQL Server databases. Built on top of the node-mssql library, it allows language models running in environments like Cursor, Windsurf, and Claude Code to execute database queries, inspect schemas, and retrieve tabular data directly. Database administrators, backend engineers, and data analysts use this server to troubleshoot SQL Server instances, inspect table definitions, and validate stored procedures without switching to external database management tools. The server operates over standard input/output using Node.js execution through npx or local builds. By exposing database configuration parameters such as host, port, credentials, timeouts, encryption toggles, and certificate trust settings, Node MSSQL offers granular control over database sessions while maintaining context inside the developer's primary coding interface.

Category: Databases & Data Stores

Tags: database-management, mssql, node-mssql, sql server

Visit Node MSSQL

How to install and configure Node MSSQL

1. Ensure Node.js and npm are installed on your system. 2. Open your client configuration file, such as ~/.cursor/mcp.json for Cursor or ~/.claude.json for Claude Code. 3. Add the mssql server configuration under mcpServers using the npx command: json { "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>", "CONNECTION_TIMEOUT": "600000", "REQUEST_TIMEOUT": "300000", "DB_ENCRYPT": "false", "DB_ENABLE_ARITH_ABORT": "false", "DB_TRUST_SERVER_CERTIFICATE": "false", "TRUSTED_CONNECTION": "false" } } } } 4. Replace the database credentials and connection options with your Microsoft SQL Server settings. 5. Restart your AI client to load the server.

What you can do with Node MSSQL

• Querying Microsoft SQL Server tables to verify application data states directly inside an AI coding assistant session. * Inspecting table schemas, data types, and foreign key relationships to generate accurate application data models. * Executing diagnostic SQL scripts to monitor database performance, connection health, and query timeouts during development. * Assisting backend developers in drafting and testing complex T-SQL queries against a local or staging database. * Automating routine database verification checks within automated agent workflows in Claude Code or Windsurf.

Key facts

• Open Source
• https://github.com/cwilby/mcp-node-mssql
• Databases & Data Stores
• database-management, mssql, node-mssql, sql server

Part of MCP Servers

How do I install Node MSSQL?

Node MSSQL can be run directly using npx without manual installation by specifying npx -y mcp-node-mssql in your MCP client configuration file. Alternatively, you can clone the repository from GitHub, run npm install, build the project with npm run build, and reference the compiled dist/index.js file directly with Node in your configuration.

Which MCP clients work with Node MSSQL?

Node MSSQL works with any client supporting the Model Context Protocol over stdio. The project documentation includes specific setup instructions for Cursor, Windsurf, and Claude Code.

What configuration settings are required for Node MSSQL?

Node MSSQL is configured through environment variables. You must specify DB_HOST, DB_PORT, DB_USERNAME, DB_PASSWORD, and DB_DATABASE. You can also configure parameters such as CONNECTION_TIMEOUT, REQUEST_TIMEOUT, DB_ENCRYPT, DB_ENABLE_ARITH_ABORT, DB_TRUST_SERVER_CERTIFICATE, and TRUSTED_CONNECTION.

Is Node MSSQL open source?

Yes, Node MSSQL is an open-source project hosted on GitHub under the repository cwilby/mcp-node-mssql, allowing developers to inspect the source code, report issues, and contribute improvements.