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

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

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

Trust verdict · v1 advisory · method

NOT YET SCREENEDno verdict on file

Verdict not yet evaluated for this tool. The semantic screen takes adversarial cases first; coverage rolls out as the corpus expands (15/150 labels to graduation). The deterministic conformance probe is built but has not yet run on the public corpus, so a recorded verdict here is REVIEW or UNVERIFIED, never a clearing ALLOW. Until a verdict is recorded, an agent should treat this tool as not-yet-cleared and fall back to its own checks. Method: the eval, four-state verdict, honest limits.

Own this server? Screen its description →

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

MCP quality score · maturity, not trust · methodology

freshness

completeness

installability

documentation

stability

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.

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

Verdict API

curl -s mcpindex.ai/api/v1/trust/server/io-github-coregentdevspace-sql-server-analyst-mcp

Free-tier verdict as JSON: decision + dimensions + severity. Call it from your agent before it invokes a tool it just discovered.

Details

version: v0.1.1
category: Other
quality: 78 / 100
operator: coregentdevspace

Provenance

Verdict history is anchored to Bitcoin via OpenTimestamps. The free tier returns the current verdict only; the anchored record is served on the authenticated tier.

Links

Repository →