io.github.coregentdevspace/sql-server-analyst-mcp

Official

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

Read-only SQL Server analysis for schemas, stored procedures, and performance insights.

Install

Configuration

Environment variables

MSSQL_SERVERrequired

SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).

MSSQL_PORT

TCP port (default 1433; set 0 for named instance with dynamic port).

MSSQL_DATABASE

Default database to connect to. Most tools also accept an override argument.

MSSQL_USERrequired

SQL authentication login name.

MSSQL_PASSWORDrequiredsecret

SQL authentication password. Quote values containing '#' in .env files.

MSSQL_ENCRYPT

Encrypt the connection (true|false). Required true for Azure SQL.

MSSQL_TRUST_SERVER_CERT

Trust self-signed certificates (true|false). Use true only for local dev.

ALLOWED_DATABASES

Comma-separated allowlist of databases the server may access. Empty = unrestricted.

ALLOWED_SCHEMAS

Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.

MAX_ROWS

Default row limit per safe query (default 100).

MAX_ROWS_LIMIT

Hard cap on query rows (default 1000).

QUERY_TIMEOUT_MS

Query execution timeout in milliseconds (default 30000).

LOG_LEVEL

error | warn | info | debug (default info).

claude_desktop_config.json

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp@0.1.1"
      ],
      "env": {
        "MSSQL_SERVER": "<YOUR_MSSQL_SERVER>",
        "MSSQL_PORT": "<YOUR_MSSQL_PORT>",
        "MSSQL_DATABASE": "<YOUR_MSSQL_DATABASE>",
        "MSSQL_USER": "<YOUR_MSSQL_USER>",
        "MSSQL_PASSWORD": "<YOUR_MSSQL_PASSWORD>",
        "MSSQL_ENCRYPT": "<YOUR_MSSQL_ENCRYPT>",
        "MSSQL_TRUST_SERVER_CERT": "<YOUR_MSSQL_TRUST_SERVER_CERT>",
        "ALLOWED_DATABASES": "<YOUR_ALLOWED_DATABASES>",
        "ALLOWED_SCHEMAS": "<YOUR_ALLOWED_SCHEMAS>",
        "MAX_ROWS": "<YOUR_MAX_ROWS>",
        "MAX_ROWS_LIMIT": "<YOUR_MAX_ROWS_LIMIT>",
        "QUERY_TIMEOUT_MS": "<YOUR_QUERY_TIMEOUT_MS>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>"
      }
    }
  }
}