MCP Server

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

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

Repository Registry

What is the io.github.coregentdevspace/sql-server-analyst-mcp MCP server?

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

How to install io.github.coregentdevspace/sql-server-analyst-mcp

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

MSSQL_SERVER
required
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_USER
required
SQL authentication login name.
MSSQL_PASSWORD
required
secret
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).

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "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>"
      }
    }
  }
}