SQL Server Analyst MCP Server: Install & Setup

Install SQL Server Analyst in Claude Code

Claude Code

claude mcp add sql-server-analyst -e MSSQL_SERVER=... -e MSSQL_USER=... -e MSSQL_PASSWORD=... -- npx -y sql-server-analyst-mcp

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "sql-server-analyst": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "...",
        "MSSQL_USER": "...",
        "MSSQL_PASSWORD": "..."
      }
    }
  }
}

Replace each ... with your own value.

Frequently asked questions

What does the SQL Server Analyst MCP server do?

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

Is the SQL Server Analyst MCP server free?

The server is free, but you will likely need an account. The server itself is free, but it connects to a service that needs an account or API key, which may have paid tiers. Check the provider for current pricing.

Does SQL Server Analyst run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add SQL Server Analyst to Claude Code?

Run: claude mcp add sql-server-analyst -e MSSQL_SERVER=... -e MSSQL_USER=... -e MSSQL_PASSWORD=... -- npx -y sql-server-analyst-mcp

More databases MCP servers

View all

Websupport

189

tydung26/websupport-mcp

Manage a Websupport account: DNS, FTP, hosting, databases, mailboxes, VPS and invoices.

LocalAccount needed

rowstile

41.3k

rowstile/rowstile

Check, test, prove and review a rowstile policy: access rules for Postgres row-level security

LocalFree

Zordon

piotrkowalczuk/zordon

Supervise a local dev stack — databases, brokers and services declared in an Alphasfile — over MCP.

LocalFree

Quarry

yiminspace/quarry

Safety-railed database access: Postgres, MySQL, SQLite, Redis. Read-only by default.

LocalFree

WoWSQL

WoWSQL/MCP-Server

Managed Postgres MCP: projects, SQL, docs search, and storage buckets via OAuth.

RemoteAccount needed

Postgres (read-only)

contextflo/postgres-mcp

Read-only Postgres: drop-in for the archived server-postgres, with schema context.

LocalFree