mcp-node-mssql
If you are the rightful owner of mcp-node-mssql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
mcp-node-mssql is a Model Context Protocol (MCP) server designed to facilitate communication between AI models and Microsoft SQL Server databases.
mcp-node-mssql
Usage
Cursor
See the official Cursor docs for more information.
- Open (or create) the
mcp.jsonfile (it should be in~/.cursor/mcp.jsonor<project-root>/.cursor/mcp.json, but see Cursor docs for more details). - Add the following details and save the file:
{
"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>"
}
}
}
}
Windsurf
See the official Windsurf docs for more information.
- Open the
Windsurf MCP Configuration Panel - Click
Add custom server. - Add the following details and save the file:
{
"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>"
}
}
}
}
Claude Code
See the official Claude Code docs for more information.
You can add a new MCP server from the Claude Code CLI. But modifying the json file directly is simpler!
- Open the Claude Code configuration file (it should be in
~/.claude.json). - Find the
projects>mcpServerssection and add the following details and save the file:
{
"projects": {
"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>"
}
}
}
}
}
Issues and Troubleshooting
Before doing anything else, please make sure you are running the latest version!
If you run into problems using this MCP server, please open an issue on GitHub!
Development
Installation
npm install
Build
npm run build
Running the Development Server Locally
To test your local development version of the MCP server rather than using the published package, follow these steps:
- Build the project:
npm run build
- Create or modify your
mcp.jsonfile to reference your local build:
{
"mcpServers": {
"mssql": {
"command": "node",
"args": [
"/path/to/your/local/mcp-node-mssql/dist/index.js"
],
"env": {
"DB_HOST": "localhost",
"DB_PORT": "1433",
"DB_USERNAME": "<username>",
"DB_PASSWORD": "<password>",
"DB_DATABASE": "<database>"
}
}
}
}
-
Place this
mcp.jsonfile in one of the following locations:- For Cursor: In your home directory (
~/.cursor/mcp.json) or in your project directory (.cursor/mcp.json) - For Windsurf: Use the MCP Configuration Panel to add the custom server
- For Cursor: In your home directory (
-
Restart your AI assistant (Cursor or Windsurf) to load the new configuration.
This allows you to instantly test changes to the MCP server without having to publish a new version.
