Skip to content
VS Code

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

sql server analyst mcp in other clients