MCP Server

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

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

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

Claude Desktop

~/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>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.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>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_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>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "sql-server-analyst-mcp": {
      "type": "stdio",
      "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>"
      }
    }
  }
}

Claude Code

claude mcp add sql-server-analyst-mcp --env MSSQL_SERVER=<YOUR_MSSQL_SERVER> --env MSSQL_PORT=<YOUR_MSSQL_PORT> --env MSSQL_DATABASE=<YOUR_MSSQL_DATABASE> --env MSSQL_USER=<YOUR_MSSQL_USER> --env MSSQL_PASSWORD=<YOUR_MSSQL_PASSWORD> --env MSSQL_ENCRYPT=<YOUR_MSSQL_ENCRYPT> --env MSSQL_TRUST_SERVER_CERT=<YOUR_MSSQL_TRUST_SERVER_CERT> --env ALLOWED_DATABASES=<YOUR_ALLOWED_DATABASES> --env ALLOWED_SCHEMAS=<YOUR_ALLOWED_SCHEMAS> --env MAX_ROWS=<YOUR_MAX_ROWS> --env MAX_ROWS_LIMIT=<YOUR_MAX_ROWS_LIMIT> --env QUERY_TIMEOUT_MS=<YOUR_QUERY_TIMEOUT_MS> --env LOG_LEVEL=<YOUR_LOG_LEVEL> -- npx -y sql-server-analyst-mcp