English Français العربية

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

Registre officiel Données et bases de données

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

Code source

Installation

Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).

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
Configuration JSON (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>"
            }
        }
    }
}

Variables d'environnement

  • MSSQL_SERVER obligatoire 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 obligatoire SQL authentication login name.
  • MSSQL_PASSWORD obligatoire 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).

Questions fréquentes

Qu'est-ce que io.github.coregentdevspace/sql-server-analyst-mcp ?

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

Comment installer io.github.coregentdevspace/sql-server-analyst-mcp ?

Il s'exécute sur votre machine. Dans 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. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.

Faut-il une clé API pour io.github.coregentdevspace/sql-server-analyst-mcp ?

Oui. Il attend MSSQL_SERVER, MSSQL_USER, MSSQL_PASSWORD, à renseigner dans sa configuration.

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

Son code est public sur GitHub, mais le dépôt ne déclare pas de licence standard.

Qui maintient io.github.coregentdevspace/sql-server-analyst-mcp ?

Il est publié par coregentdevspace. AI.tn le référence sans le maintenir ni le recommander.

Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.