SqlServerMcp for VS Code
io.github.nithish1206/sqlservermcp
MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis
client:VS Code
transport:stdio
runtime:nuget
Install SqlServerMcp in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "connectionstrings--mydb",
"description": "ConnectionStrings__MyDb",
"password": true
},
{
"type": "promptString",
"id": "query--defaulttop",
"description": "Query__DefaultTop",
"password": true
},
{
"type": "promptString",
"id": "query--maxtop",
"description": "Query__MaxTop",
"password": true
}
],
"servers": {
"sqlservermcp": {
"type": "stdio",
"command": "dnx",
"args": [
"SqlServerMcp",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "${input:connectionstrings--mydb}",
"Query__DefaultTop": "${input:query--defaulttop}",
"Query__MaxTop": "${input:query--maxtop}"
}
}
}
}VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs