NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

SQL Server MCP

io.github.cvelasquez/mcp-sqlserver · v3.3.0

MCP server for DBAs running dozens of SQL Server instances: grouped connections, plans, indexes

Website Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add mcp-sqlserver -e MSSQL_MCP_CONNECTIONS=<MSSQL_MCP_CONNECTIONS> -e MSSQL_MCP_CONNECTIONS_JSON=<MSSQL_MCP_CONNECTIONS_JSON> -- npx -y @cevelas/[email protected]
claude_desktop_config.json
{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/[email protected]"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS": "<MSSQL_MCP_CONNECTIONS>",
        "MSSQL_MCP_CONNECTIONS_JSON": "<MSSQL_MCP_CONNECTIONS_JSON>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/[email protected]"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS": "<MSSQL_MCP_CONNECTIONS>",
        "MSSQL_MCP_CONNECTIONS_JSON": "<MSSQL_MCP_CONNECTIONS_JSON>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mcp-sqlserver": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/[email protected]"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS": "<MSSQL_MCP_CONNECTIONS>",
        "MSSQL_MCP_CONNECTIONS_JSON": "<MSSQL_MCP_CONNECTIONS_JSON>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
MSSQL_MCP_CONNECTIONS
Optional		Path to connections.json. Defaults to ~/.mcp-sqlserver/connections.json; create one with --init.
MSSQL_MCP_CONNECTIONS_JSON
Optional, secret		The connections JSON inline, for setups that keep credentials out of the filesystem.

Details

Package@cevelas/[email protected] (NPM, stdio)
First published12 Oct 2026
Last updated12 Oct 2026
Registry nameio.github.cvelasquez/mcp-sqlserver

More databases servers See all

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

  • Tidy Byte Tools API

    Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.