SERVER

SQL Server Analyst MCP

Rank #61,704

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

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

1 version

by coregentdevspace (1 servers)View repository ↗Claim this server

Listed & last published

Apr 22, 2026

OVERVIEW

SQL Server Analyst MCP is a Model Context Protocol (MCP) server published by coregentdevspace. It ranks #61,704 of 137,138 servers tracked on MCP Toplist. SQL Server Analyst MCP is listed on Official MCP, with 1 tracked version. It was first listed on Apr 22, 2026 and most recently updated on Apr 22, 2026.

STANDING

#61,704of 137,138 tracked serversTop 50%

Ranks ahead of 75,434 of 137,138 servers on MCP Toplist.

CONNECT

Use SQL Server Analyst MCP

API keyNeeds credentials

Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.

npm package

claude mcp add sql-server-analyst-mcp -e "MSSQL_SERVER=<your MSSQL_SERVER>" -e "MSSQL_PORT=<your MSSQL_PORT>" -e "MSSQL_DATABASE=<your MSSQL_DATABASE>" -e "MSSQL_USER=<your MSSQL_USER>" -e "MSSQL_PASSWORD=<your MSSQL_PASSWORD>" -e "MSSQL_ENCRYPT=<your MSSQL_ENCRYPT>" -e "MSSQL_TRUST_SERVER_CERT=<your MSSQL_TRUST_SERVER_CERT>" -e "ALLOWED_DATABASES=<your ALLOWED_DATABASES>" -e "ALLOWED_SCHEMAS=<your ALLOWED_SCHEMAS>" -e "MAX_ROWS=<your MAX_ROWS>" -e "MAX_ROWS_LIMIT=<your MAX_ROWS_LIMIT>" -e "QUERY_TIMEOUT_MS=<your QUERY_TIMEOUT_MS>" -e "LOG_LEVEL=<your LOG_LEVEL>" -- npx -y sql-server-analyst-mcp

Replace each placeholder with your own value before saving.

npm package

[mcp_servers.sql-server-analyst-mcp]
command = "npx"
args = ["-y", "sql-server-analyst-mcp"]

[mcp_servers.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>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.coregentdevspace%2Fsql-server-analyst-mcp.svg)](https://mcptoplist.com/server/io.github.coregentdevspace%2Fsql-server-analyst-mcp)

HTML

<a href="https://mcptoplist.com/server/io.github.coregentdevspace%2Fsql-server-analyst-mcp"><img src="https://mcptoplist.com/badge/io.github.coregentdevspace%2Fsql-server-analyst-mcp.svg" alt="MCP Toplist: Top 50% of 137,138" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

REGISTRIES

Listed on 1 registry

Official MCP

ORGANIZATION

coregentdevspace

Organization

coregentdevspace

Servers in org

Versions across org

VERSIONS

Available versions (1)

Version	Published
0.1.1	Apr 22, 2026

FAQ

Frequently asked questions

Who maintains SQL Server Analyst MCP?: SQL Server Analyst MCP is maintained by coregentdevspace, which publishes 1 MCP server (1 total version) tracked on MCP Toplist.
Is SQL Server Analyst MCP listed on the Official MCP Registry?: Yes — SQL Server Analyst MCP is listed on the Official MCP Registry.
How many versions does SQL Server Analyst MCP have?: MCP Toplist tracks 1 version of SQL Server Analyst MCP, most recently published on Apr 22, 2026.
Where can I find the source code for SQL Server Analyst MCP?: The source code for SQL Server Analyst MCP is hosted at github.com/coregentdevspace/sql-server-analyst-mcp.

Used in projects

Do you run this server?

Add to a project

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers