sql server analyst mcp for VS Code
io.github.coregentdevspace/sql-server-analyst-mcp
Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
client:VS Code
transport:stdio
runtime:npm
Install sql server analyst mcp in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "mssql-server",
"description": "MSSQL_SERVER",
"password": true
},
{
"type": "promptString",
"id": "mssql-port",
"description": "MSSQL_PORT",
"password": true
},
{
"type": "promptString",
"id": "mssql-database",
"description": "MSSQL_DATABASE",
"password": true
},
{
"type": "promptString",
"id": "mssql-user",
"description": "MSSQL_USER",
"password": true
},
{
"type": "promptString",
"id": "mssql-password",
"description": "MSSQL_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "mssql-encrypt",
"description": "MSSQL_ENCRYPT",
"password": true
},
{
"type": "promptString",
"id": "mssql-trust-server-cert",
"description": "MSSQL_TRUST_SERVER_CERT",
"password": true
},
{
"type": "promptString",
"id": "allowed-databases",
"description": "ALLOWED_DATABASES",
"password": true
},
{
"type": "promptString",
"id": "allowed-schemas",
"description": "ALLOWED_SCHEMAS",
"password": true
},
{
"type": "promptString",
"id": "max-rows",
"description": "MAX_ROWS",
"password": true
},
{
"type": "promptString",
"id": "max-rows-limit",
"description": "MAX_ROWS_LIMIT",
"password": true
},
{
"type": "promptString",
"id": "query-timeout-ms",
"description": "QUERY_TIMEOUT_MS",
"password": true
},
{
"type": "promptString",
"id": "log-level",
"description": "LOG_LEVEL",
"password": true
}
],
"servers": {
"sql-server-analyst-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"sql-server-analyst-mcp"
],
"env": {
"MSSQL_SERVER": "${input:mssql-server}",
"MSSQL_PORT": "${input:mssql-port}",
"MSSQL_DATABASE": "${input:mssql-database}",
"MSSQL_USER": "${input:mssql-user}",
"MSSQL_PASSWORD": "${input:mssql-password}",
"MSSQL_ENCRYPT": "${input:mssql-encrypt}",
"MSSQL_TRUST_SERVER_CERT": "${input:mssql-trust-server-cert}",
"ALLOWED_DATABASES": "${input:allowed-databases}",
"ALLOWED_SCHEMAS": "${input:allowed-schemas}",
"MAX_ROWS": "${input:max-rows}",
"MAX_ROWS_LIMIT": "${input:max-rows-limit}",
"QUERY_TIMEOUT_MS": "${input:query-timeout-ms}",
"LOG_LEVEL": "${input:log-level}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs