Sql Server Analyst

stdio

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

Getting Started

npx @getmcp/cli add io.github.coregentdevspace/sql-server-analyst-mcp

Requires Node.js 18+. Community-contributed server. Review source before installing.

Claude Desktopguide →Vscodeguide →Cursorguide →Windsurfguide →

Required Environment Variables

MSSQL_SERVER
SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).
MSSQL_USER
SQL authentication login name.
MSSQL_PASSWORD
SQL authentication password. Quote values containing '#' in .env files.

Configuration

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json

JSON

{
  "mcpServers": {
    "io.github.coregentdevspace/sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "",
        "MSSQL_PORT": "",
        "MSSQL_DATABASE": "",
        "MSSQL_USER": "",
        "MSSQL_PASSWORD": "",
        "MSSQL_ENCRYPT": "",
        "MSSQL_TRUST_SERVER_CERT": "",
        "ALLOWED_DATABASES": "",
        "ALLOWED_SCHEMAS": "",
        "MAX_ROWS": "",
        "MAX_ROWS_LIMIT": "",
        "QUERY_TIMEOUT_MS": "",
        "LOG_LEVEL": ""
      }
    }
  }
}

Claude Desktop MCP documentation