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

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

{
    "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>"
            }
        }
    }
}

متغيرات البيئة

• MSSQL_SERVER إلزامي 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 إلزامي SQL authentication login name.
• MSSQL_PASSWORD إلزامي سري 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).