PluginBench
MCP Server
Active
MIT

SQL Server MCP MCP Server

io.github.cvelasquez/mcp-sqlserver

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the SQL Server MCP MCP server?

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

How to install SQL Server MCP

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • MSSQL_MCP_CONNECTIONS

    Path to connections.json. Defaults to ~/.mcp-sqlserver/connections.json; create one with --init.

  • MSSQL_MCP_CONNECTIONS_JSON
    secret

    The connections JSON inline, for setups that keep credentials out of the filesystem.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@cevelas/mcp-sqlserver"
      ],
      "env": {
        "MSSQL_MCP_CONNECTIONS": "<YOUR_MSSQL_MCP_CONNECTIONS>",
        "MSSQL_MCP_CONNECTIONS_JSON": "<YOUR_MSSQL_MCP_CONNECTIONS_JSON>"
      }
    }
  }
}

Related MCP servers

Fetch US Bureau of Labor Statistics data — CPI, unemployment, wages, JOLTS, and more via MCP.

1
TypeScript
View repository →

Collaborative BrAPI v2.1 MCP workspace — studies, germplasm, genotypes across Breedbase, T3, more.

3
TypeScript
Apache-2.0
View repository →

Query U.S. Census Bureau data, variables, and geography via MCP.

1
TypeScript
Apache-2.0
View repository →

Link compounds to protein targets, rank bioactivity, and look up drug mechanisms and indications.

1
TypeScript
Apache-2.0
View repository →

Lightweight ClickUp MCP server - 37 tools, token-optimized (95% smaller responses)

3
TypeScript
MIT
View repository →

Lightweight WordPress MCP server - 42 tools, token-optimized (95% smaller responses)

2
TypeScript
MIT
View repository →