PluginBench
MCP Server

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

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

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

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

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "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>"
      }
    }
  }
}

Related MCP servers

Semantic search knowledge base with serverless LanceDB. Zero setup, 100% local, 25+ file types

MCP server for CostKits: live healthcare procedure cost estimates and provider pricing.

0
JavaScript
MIT
View repository →

Connect AI agents to Couchbase clusters for natural language data exploration, querying, and management.

32
Python
Apache-2.0
View repository →
TEtext2sql logo

text2sql

Active

Ask any SQL database in natural language. Agent explores schema, writes SQL, self-corrects.

1
Python
MIT
View repository →

MCP server for Open Archives: Dutch genealogical records and historical page transcriptions.

2
TypeScript
View repository →

Real User Monitoring for Core Web Vitals. Query LCP, INP, CLS field data from real visitors.

0
MIT
View repository →