SQL Server Analyst MCP Server

by coregentdevspaceio.github.coregentdevspace/sql-server-analyst-mcpv0.1.1

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

Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Slowing6mo ago

Install SQL Server Analyst MCP server

claude mcp add sql-server-analyst -e MSSQL_SERVER='<mssql-server>' -e MSSQL_USER='<mssql-user>' -e MSSQL_PASSWORD='<mssql-password>' -- npx -y sql-server-analyst-mcp

{
  "mcpServers": {
    "sql-server-analyst": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<mssql-server>",
        "MSSQL_USER": "<mssql-user>",
        "MSSQL_PASSWORD": "<mssql-password>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "sql-server-analyst": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<mssql-server>",
        "MSSQL_USER": "<mssql-user>",
        "MSSQL_PASSWORD": "<mssql-password>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "sql-server-analyst": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<mssql-server>",
        "MSSQL_USER": "<mssql-user>",
        "MSSQL_PASSWORD": "<mssql-password>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "sql-server-analyst": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<mssql-server>",
        "MSSQL_USER": "<mssql-user>",
        "MSSQL_PASSWORD": "<mssql-password>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
MSSQL_SERVER	yes	—	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	yes	—	SQL authentication login name.
MSSQL_PASSWORD	yes	yes	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).

Freshness

Slowing — last maintenance signal 6mo ago. The newest of the signals below sets the band.

Last commit (default branch)
no data · GitHub
Latest release
no data · GitHub
Package published
no data · npm/PyPI
Registry entry updated
2026-04-22 · 6mo ago · official registry · v0.1.1

FAQ

›How do I install the SQL Server Analyst MCP server in Claude Code?

Run: claude mcp add sql-server-analyst -e MSSQL_SERVER='<mssql-server>' -e MSSQL_USER='<mssql-user>' -e MSSQL_PASSWORD='<mssql-password>' -- npx -y sql-server-analyst-mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does SQL Server Analyst require an API key?

Yes. It expects MSSQL_SERVER, MSSQL_USER, MSSQL_PASSWORD, of which 1 is a secret.

›Can I use SQL Server Analyst as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is SQL Server Analyst in the official MCP registry?

Yes, as io.github.coregentdevspace/sql-server-analyst-mcp.