Microsoft SQL Server

Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.

build.protocol_tooling.mcp

Install Microsoft SQL Server in your MCP client

Microsoft SQL Server is a Model Context Protocol server. Add it to your MCP client config once, restart, and the server's tools become available to your AI assistant. The same JSON snippet below works across all four major clients — only the config file path differs.

  1. Locate your client's MCP config file.
    • Cursor: ~/.cursor/mcp.json
    • Claude Desktop (macOS): ~/Library/Application Support/Claude/claude_desktop_config.json
    • Claude Desktop (Windows): %APPDATA%\Claude\claude_desktop_config.json
    • VS Code: Settings → Extensions → MCP
    • Windsurf: Settings → MCP Servers
  2. Add Microsoft SQL Server to the mcpServers map — paste the snippet below into your config file. If you already have other MCP servers, merge the entry into the existing mcpServers object.
  3. Restart your client so it picks up the new server.
  4. Verify — ask the assistant to list available tools; Microsoft SQL Server's tools should appear.
{
  "mcpServers": {
    "microsoft-sql-server": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft-sql-server/mcp-server"
      ],
      "note": "Replace with the actual package name from the server's documentation."
    }
  }
}

Install Microsoft SQL Server in Cursor

Open ~/.cursor/mcp.json in your editor, paste the snippet above into mcpServers, save, and restart Cursor. Microsoft SQL Server will show up in the assistant's tool list on next launch.

Install Microsoft SQL Server in Claude Desktop (macOS)

Open ~/Library/Application Support/Claude/claude_desktop_config.json in your editor, paste the snippet above into mcpServers, save, and restart Claude Desktop (macOS). Microsoft SQL Server will show up in the assistant's tool list on next launch.

Install Microsoft SQL Server in Claude Desktop (Windows)

Open %APPDATA%\Claude\claude_desktop_config.json in your editor, paste the snippet above into mcpServers, save, and restart Claude Desktop (Windows). Microsoft SQL Server will show up in the assistant's tool list on next launch.

Install Microsoft SQL Server in VS Code

Open Settings → Extensions → MCP in your editor, paste the snippet above into mcpServers, save, and restart VS Code. Microsoft SQL Server will show up in the assistant's tool list on next launch.

Transport

Microsoft SQL Server supports the following MCP transports. Most AI clients use stdio by default for locally-installed servers.

stdio

Other Model Context Protocol servers in the same space as Microsoft SQL Server. Each one adds different capabilities to your AI assistant — pick based on the data sources or workflows you need.

Browse the full MCP server directory or use Stork's one-line install to let your agent pick the right server automatically.