Sql Server Analyst Mcp

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

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

Source code Set it up

Connect Runs on your machine

Terminal

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

claude_desktop_config.json

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_PORT": "<MSSQL_PORT>",
        "MSSQL_DATABASE": "<MSSQL_DATABASE>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<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/mcp.json

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_PORT": "<MSSQL_PORT>",
        "MSSQL_DATABASE": "<MSSQL_DATABASE>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<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>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "sql-server-analyst-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_PORT": "<MSSQL_PORT>",
        "MSSQL_DATABASE": "<MSSQL_DATABASE>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<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>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

Name	Description
`MSSQL_SERVER` Required	SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).
`MSSQL_PORT` Optional	TCP port (default 1433; set 0 for named instance with dynamic port).
`MSSQL_DATABASE` Optional	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` Optional	Encrypt the connection (true\|false). Required true for Azure SQL.
`MSSQL_TRUST_SERVER_CERT` Optional	Trust self-signed certificates (true\|false). Use true only for local dev.
`ALLOWED_DATABASES` Optional	Comma-separated allowlist of databases the server may access. Empty = unrestricted.
`ALLOWED_SCHEMAS` Optional	Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.
`MAX_ROWS` Optional	Default row limit per safe query (default 100).
`MAX_ROWS_LIMIT` Optional	Hard cap on query rows (default 1000).
`QUERY_TIMEOUT_MS` Optional	Query execution timeout in milliseconds (default 30000).
`LOG_LEVEL` Optional	error \| warn \| info \| debug (default info).

Details

Package	`[email protected]` (NPM, stdio)
First published	22 Apr 2026
Last updated	22 Apr 2026
Registry name	`io.github.coregentdevspace/sql-server-analyst-mcp`

More databases servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use Sql Server Analyst Mcp often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-coregentdevspace-sql-server-analyst-mcp/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-coregentdevspace-sql-server-analyst-mcp)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.