$ timeahead.in
mcp/microsoft-sql-server-mcp/install/claude-desktop

install Microsoft SQL Server MCP on Claude Desktop

Requires the runtime declared in the upstream repo — check the README before running. Claude Desktop only speaks stdio locally; HTTP servers are wrapped via npx mcp-remote automatically. Paste the config below, then follow the reload step to register Microsoft SQL Server MCP.

paste into
macos: ~/Library/Application Support/Claude/claude_desktop_config.json
windows: %APPDATA%\Claude\claude_desktop_config.json
linux: ~/.config/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "mssql": {
      "command": "node",
      "args": [
        "/absolute/path/to/mssql-mcp/dist/index.js"
      ],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_USER": "your_user",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}
then: Quit Claude Desktop completely (Cmd/Ctrl+Q) and reopen it.
other clients
CursorWindsurfVS Code (Copilot)Claude Code
← back to Microsoft SQL Server MCP