SQL Server MCP Server

by cvelasquezio.github.cvelasquez/mcp-sqlserverv3.1.0

Manage many SQL Server instances from one config, grouped by client or environment, with execution plans, index audits and stored-procedure analysis.

2Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active21d ago

Install SQL Server MCP server

claude mcp add sqlserver -e MSSQL_MCP_CONNECTIONS_JSON='<mssql-mcp-connections-json>' -- npx -y @cevelas/mcp-sqlserver

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/mcp-sqlserver"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS_JSON": "<mssql-mcp-connections-json>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/mcp-sqlserver"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS_JSON": "<mssql-mcp-connections-json>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "sqlserver": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/mcp-sqlserver"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS_JSON": "<mssql-mcp-connections-json>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/mcp-sqlserver"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS_JSON": "<mssql-mcp-connections-json>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
MSSQL_MCP_CONNECTIONS	—	—	Path to connections.json. Defaults to ~/.mcp-sqlserver/connections.json; create one with --init.
MSSQL_MCP_CONNECTIONS_JSON	—	yes	The connections JSON inline, for setups that keep credentials out of the filesystem.

Freshness

Active — last maintenance signal 21d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-09-18 · 21d ago · GitHub
Latest release
2026-09-18 · 21d ago · GitHub · v3.1.0
Package published
no data · npm/PyPI
Registry entry updated
2026-09-18 · 21d ago · official registry · v3.1.0

FAQ

›How do I install the SQL Server MCP server in Claude Code?

Run: claude mcp add sqlserver -e MSSQL_MCP_CONNECTIONS_JSON='<mssql-mcp-connections-json>' -- npx -y @cevelas/mcp-sqlserver. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does SQL Server require an API key?

Yes. It expects MSSQL_MCP_CONNECTIONS_JSON, of which 1 is a secret.

›Can I use SQL Server as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is SQL Server in the official MCP registry?

Yes, as io.github.cvelasquez/mcp-sqlserver.