MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis
Connect Runs on your machine
claude mcp add sqlservermcp -e ConnectionStrings__MyDb=<ConnectionStrings__MyDb> -e Query__DefaultTop=<Query__DefaultTop> -e Query__MaxTop=<Query__MaxTop> -- dnx SqlServerMcp --yes
{
"mcpServers": {
"sqlservermcp": {
"command": "dnx",
"args": [
"SqlServerMcp",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "<ConnectionStrings__MyDb>",
"Query__DefaultTop": "<Query__DefaultTop>",
"Query__MaxTop": "<Query__MaxTop>"
}
}
}
}
{
"mcpServers": {
"sqlservermcp": {
"command": "dnx",
"args": [
"SqlServerMcp",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "<ConnectionStrings__MyDb>",
"Query__DefaultTop": "<Query__DefaultTop>",
"Query__MaxTop": "<Query__MaxTop>"
}
}
}
}
{
"servers": {
"sqlservermcp": {
"type": "stdio",
"command": "dnx",
"args": [
"SqlServerMcp",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "<ConnectionStrings__MyDb>",
"Query__DefaultTop": "<Query__DefaultTop>",
"Query__MaxTop": "<Query__MaxTop>"
}
}
}
}
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
| Name | Description |
|---|---|
ConnectionStrings__MyDbOptional | |
Query__DefaultTopOptional | |
Query__MaxTopOptional |
Details
| Package | [email protected] (NUGET, stdio) |
| First published | 25 Jun 2026 |
| Last updated | 25 Jun 2026 |
| Registry name | io.github.Nithish1206/SqlServerMcp |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.
