How do I install sql-server-analyst-mcp?

Pick a client above and copy the generated config. Cursor and VS Code also have a deep link when the server can run locally or remotely.

Is sql-server-analyst-mcp official?

No. Registry-listed is not the same as vendor-official. Read the methodology for the difference.

How is the trust score calculated?

This listing scores 45 (Fair). The formula is published on the methodology page.

MCPpedia

sql-server-analyst-mcp MCP Server | MCPpedia

sql-server-analyst-mcp MCP Server

Name: sql-server-analyst-mcp MCP Server
Author: coregentdevspace

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

Tools Versions Alternatives

Registrycoregentdevspace

45Fair

Install

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "coregentdevspace-sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp@0.1.1"
      ],
      "env": {
        "MSSQL_SERVER": "",
        "MSSQL_PORT": "",
        "MSSQL_DATABASE": "",
        "MSSQL_USER": "",
        "MSSQL_PASSWORD": "YOUR_MSSQL_PASSWORD",
        "MSSQL_ENCRYPT": "",
        "MSSQL_TRUST_SERVER_CERT": "",
        "ALLOWED_DATABASES": "",
        "ALLOWED_SCHEMAS": "",
        "MAX_ROWS": "",
        "MAX_ROWS_LIMIT": "",
        "QUERY_TIMEOUT_MS": "",
        "LOG_LEVEL": ""
      }
    }
  }
}

Install guide

Related servers

Supabase

63Good

MCP server for interacting with the Supabase platform

OfficialRegistryRemotesupabase

mcp-ssh-manager

Environment

Name	Required	Notes
MSSQL_SERVER	Yes	SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).
MSSQL_PORT	No	TCP port (default 1433; set 0 for named instance with dynamic port).
MSSQL_DATABASE	No	Default database to connect to. Most tools also accept an override argument.
MSSQL_USER	Yes	SQL authentication login name.
MSSQL_PASSWORD	Yes	SQL authentication password. Quote values containing '#' in .env files. Secret.
MSSQL_ENCRYPT	No	Encrypt the connection (true\|false). Required true for Azure SQL.
MSSQL_TRUST_SERVER_CERT	No	Trust self-signed certificates (true\|false). Use true only for local dev.
ALLOWED_DATABASES	No	Comma-separated allowlist of databases the server may access. Empty = unrestricted.
ALLOWED_SCHEMAS	No	Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.
MAX_ROWS	No	Default row limit per safe query (default 100).
MAX_ROWS_LIMIT	No	Hard cap on query rows (default 1000).
QUERY_TIMEOUT_MS	No	Query execution timeout in milliseconds (default 30000).
LOG_LEVEL	No	error \| warn \| info \| debug (default info).

sql-server-analyst-mcp MCP Server

Install

Related servers

Supabase

mcp-ssh-manager

Environment

Tools

About

FAQ

Reviews

MCP Toolbox for Databases

tmdb-mcp-server

ZenBrain Memory

Redis MCP Server