Summary
A read-only MCP server for SQL Server that lets you safely analyze database internals without risking writes. You get schema inspection, stored procedure analysis, and performance monitoring capabilities through a stdio transport. Reach for this when you're troubleshooting query performance, documenting database structure, or need Claude to understand your SQL Server setup without granting modification privileges. The read-only constraint makes it safer to connect to production databases for diagnostic work. Good fit for DBAs and backend developers who want AI assistance with SQL Server analysis tasks while maintaining strict safety boundaries.
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →
Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →
Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →Featured
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →Configuration
MSSQL_SERVER*SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).
MSSQL_PORTTCP port (default 1433; set 0 for named instance with dynamic port).
MSSQL_DATABASEDefault database to connect to. Most tools also accept an override argument.
MSSQL_USER*SQL authentication login name.
MSSQL_PASSWORD*secretSQL authentication password. Quote values containing '#' in .env files.
MSSQL_ENCRYPTEncrypt the connection (true|false). Required true for Azure SQL.
MSSQL_TRUST_SERVER_CERTTrust self-signed certificates (true|false). Use true only for local dev.
ALLOWED_DATABASESComma-separated allowlist of databases the server may access. Empty = unrestricted.
ALLOWED_SCHEMASComma-separated allowlist of schemas for schema tools. Empty = unrestricted.
MAX_ROWSDefault row limit per safe query (default 100).
MAX_ROWS_LIMITHard cap on query rows (default 1000).
QUERY_TIMEOUT_MSQuery execution timeout in milliseconds (default 30000).
LOG_LEVELerror | warn | info | debug (default info).
Categories
Registryactive
Packagesql-server-analyst-mcp
TransportSTDIO
AuthRequired
UpdatedApr 22, 2026
