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

io.github.coregentdevspace/sql-server-analyst-mcp·v0.1.1·Other

Quality Score

/100

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

Repository →

§01 Install

Claude Desktop (claude_desktop_config.json)

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

Cursor (.cursor/mcp.json)

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

Cline (cline_mcp_settings.json)

npx -y sql-server-analyst-mcp

§02 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

requiredsecret

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

§03 MCP Quality Score · methodology

freshness

completeness

installability

documentation

stability

§04 Alternatives in Other

agency.lona/trading

AI-powered trading strategy development: backtesting, market data, and portfolio analysis

ABMeter

ai.abmeter/abmeter

Feature flagging and A/B testing platform with AI-first experimentation workflows.

AdAdvisor MCP Server

ai.adadvisor/mcp-server

Query Meta Ads performance data — accounts, campaigns, ad sets, ads, metrics & settings.