Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
To add sql-server-analyst-mcp to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 13 environment variables, listed below.
Install
npx -y sql-server-analyst-mcp@0.1.1Environment variables
MSSQL_SERVERSet in your MCP configMSSQL_PORTSet in your MCP configMSSQL_DATABASESet in your MCP configMSSQL_USERSet in your MCP configMSSQL_PASSWORDSet in your MCP configMSSQL_ENCRYPTSet in your MCP configMSSQL_TRUST_SERVER_CERTSet in your MCP configALLOWED_DATABASESSet in your MCP configALLOWED_SCHEMASSet in your MCP configMAX_ROWSSet in your MCP configMAX_ROWS_LIMITSet in your MCP configQUERY_TIMEOUT_MSSet in your MCP configLOG_LEVELSet in your MCP configInstall with your client
claude mcp add sql-server-analyst --env MSSQL_SERVER=<YOUR_MSSQL_SERVER> --env MSSQL_PORT=<YOUR_MSSQL_PORT> --env MSSQL_DATABASE=<YOUR_MSSQL_DATABASE> --env MSSQL_USER=<YOUR_MSSQL_USER> --env MSSQL_PASSWORD=<YOUR_MSSQL_PASSWORD> --env MSSQL_ENCRYPT=<YOUR_MSSQL_ENCRYPT> --env MSSQL_TRUST_SERVER_CERT=<YOUR_MSSQL_TRUST_SERVER_CERT> --env ALLOWED_DATABASES=<YOUR_ALLOWED_DATABASES> --env ALLOWED_SCHEMAS=<YOUR_ALLOWED_SCHEMAS> --env MAX_ROWS=<YOUR_MAX_ROWS> --env MAX_ROWS_LIMIT=<YOUR_MAX_ROWS_LIMIT> --env QUERY_TIMEOUT_MS=<YOUR_QUERY_TIMEOUT_MS> --env LOG_LEVEL=<YOUR_LOG_LEVEL> -- npx -y sql-server-analyst-mcp@0.1.1
Run this in a terminal to add the server to Claude Code.
What this does
sql-server-analyst-mcp exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.
Requirements
This server needs the following environment variables to be set before it can run:
MSSQL_SERVER MSSQL_PORT MSSQL_DATABASE MSSQL_USER MSSQL_PASSWORD MSSQL_ENCRYPT MSSQL_TRUST_SERVER_CERT ALLOWED_DATABASES ALLOWED_SCHEMAS MAX_ROWS MAX_ROWS_LIMIT QUERY_TIMEOUT_MS LOG_LEVEL
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Frequently asked questions
How do I install sql-server-analyst-mcp?
Run the Claude Code command in the install section to add sql-server-analyst-mcp to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.
Which clients work with sql-server-analyst-mcp?
This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to sql-server-analyst-mcp as well.
Does sql-server-analyst-mcp need an API key?
Yes. Before it can run, set these environment variables: MSSQL_SERVER, MSSQL_PORT, MSSQL_DATABASE, MSSQL_USER, MSSQL_PASSWORD, MSSQL_ENCRYPT, MSSQL_TRUST_SERVER_CERT, ALLOWED_DATABASES, ALLOWED_SCHEMAS, MAX_ROWS, MAX_ROWS_LIMIT, QUERY_TIMEOUT_MS, LOG_LEVEL. They go in the env block of your MCP config.
Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.
Is this your MCP server?
Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.
Add this badge to your README
Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.
[](https://clauderules.net/mcp/io-github-coregentdevspace-sql-server-analyst-mcp)<a href="https://clauderules.net/mcp/io-github-coregentdevspace-sql-server-analyst-mcp" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-coregentdevspace-sql-server-analyst-mcp" alt="Listed on clauderules.net" /></a>More Database MCP servers
GitHub
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
Serena MCP: the IDE for your agent
A powerful toolkit for coding, providing semantic retrieval and editing capabilities.
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
Figma-Context-MCP
Give your coding agent access to your Figma data. Implement designs in any framework in one-shot.