$ timeahead.in
mcp/microsoft-sql-server-mcp/install/vscode

install Microsoft SQL Server MCP on VS Code

Requires the runtime declared in the upstream repo — check the README before running. VS Code (Copilot) uses a `servers` root key with an explicit `type` field — different from the `mcpServers` shape used by Claude Desktop and Cursor. Paste the config below, then follow the reload step to register Microsoft SQL Server MCP.

paste into
workspace: .vscode/mcp.json (project root — committed with the repo)
user: ~/.vscode/mcp.json
{
  "servers": {
    "mssql": {
      "type": "stdio",
      "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: VS Code picks up the change. Run 'MCP: List Servers' from the command palette to verify.
other clients
Claude DesktopCursorWindsurfClaude Code
← back to Microsoft SQL Server MCP