English Français العربية

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

Official registry Data and databases

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

Source code

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

NPM package sql-server-analyst-mcp
Claude Code 
claude mcp add sql-server-analyst-mcp -e 'MSSQL_SERVER=<MSSQL_SERVER>' -e 'MSSQL_PORT=<MSSQL_PORT>' -e 'MSSQL_DATABASE=<MSSQL_DATABASE>' -e 'MSSQL_USER=<MSSQL_USER>' -e 'MSSQL_PASSWORD=<your mssql_password>' -e 'MSSQL_ENCRYPT=<MSSQL_ENCRYPT>' -e 'MSSQL_TRUST_SERVER_CERT=<MSSQL_TRUST_SERVER_CERT>' -e 'ALLOWED_DATABASES=<ALLOWED_DATABASES>' -e 'ALLOWED_SCHEMAS=<ALLOWED_SCHEMAS>' -e 'MAX_ROWS=<MAX_ROWS>' -e 'MAX_ROWS_LIMIT=<MAX_ROWS_LIMIT>' -e 'QUERY_TIMEOUT_MS=<QUERY_TIMEOUT_MS>' -e 'LOG_LEVEL=<LOG_LEVEL>' -- npx -y sql-server-analyst-mcp@0.1.1
JSON configuration (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "sql-server-analyst-mcp": {
            "command": "npx",
            "args": [
                "-y",
                "sql-server-analyst-mcp@0.1.1"
            ],
            "env": {
                "MSSQL_SERVER": "<MSSQL_SERVER>",
                "MSSQL_PORT": "<MSSQL_PORT>",
                "MSSQL_DATABASE": "<MSSQL_DATABASE>",
                "MSSQL_USER": "<MSSQL_USER>",
                "MSSQL_PASSWORD": "<your mssql_password>",
                "MSSQL_ENCRYPT": "<MSSQL_ENCRYPT>",
                "MSSQL_TRUST_SERVER_CERT": "<MSSQL_TRUST_SERVER_CERT>",
                "ALLOWED_DATABASES": "<ALLOWED_DATABASES>",
                "ALLOWED_SCHEMAS": "<ALLOWED_SCHEMAS>",
                "MAX_ROWS": "<MAX_ROWS>",
                "MAX_ROWS_LIMIT": "<MAX_ROWS_LIMIT>",
                "QUERY_TIMEOUT_MS": "<QUERY_TIMEOUT_MS>",
                "LOG_LEVEL": "<LOG_LEVEL>"
            }
        }
    }
}

Environment variables

  • 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).

Frequently asked questions

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

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

How do I install io.github.coregentdevspace/sql-server-analyst-mcp?

It runs on your machine. In Claude Code: claude mcp add sql-server-analyst-mcp -e 'MSSQL_SERVER=<MSSQL_SERVER>' -e 'MSSQL_PORT=<MSSQL_PORT>' -e 'MSSQL_DATABASE=<MSSQL_DATABASE>' -e 'MSSQL_USER=<MSSQL_USER>' -e 'MSSQL_PASSWORD=<your mssql_password>' -e 'MSSQL_ENCRYPT=<MSSQL_ENCRYPT>' -e 'MSSQL_TRUST_SERVER_CERT=<MSSQL_TRUST_SERVER_CERT>' -e 'ALLOWED_DATABASES=<ALLOWED_DATABASES>' -e 'ALLOWED_SCHEMAS=<ALLOWED_SCHEMAS>' -e 'MAX_ROWS=<MAX_ROWS>' -e 'MAX_ROWS_LIMIT=<MAX_ROWS_LIMIT>' -e 'QUERY_TIMEOUT_MS=<QUERY_TIMEOUT_MS>' -e 'LOG_LEVEL=<LOG_LEVEL>' -- npx -y sql-server-analyst-mcp@0.1.1. For other clients, paste the JSON configuration from this page into their MCP settings.

Does io.github.coregentdevspace/sql-server-analyst-mcp need an API key?

Yes. It expects MSSQL_SERVER, MSSQL_USER, MSSQL_PASSWORD, which you set in its configuration.

Is io.github.coregentdevspace/sql-server-analyst-mcp open source?

Its code is public on GitHub, but the repository does not declare a standard license.

Who maintains io.github.coregentdevspace/sql-server-analyst-mcp?

It is published by coregentdevspace. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.