Sql Server Analyst Mcp

A local, read-only MCP server that lets an assistant inspect SQL Server schemas, stored procedures and query performance.

What you can do

• Explore database schemas and objects such as tables and stored procedures
• Inspect stored procedure definitions and structure
• Run read-only analysis queries with configurable row limits and timeouts
• Review performance-related information about the connected SQL Server instance
• Scope access to specific databases and schemas through allowlists

When to use it

Useful when you want an assistant to help understand or document an existing SQL Server database, review stored procedures, or investigate query performance without granting write access. It suits analysts and developers working against a single SQL Server or Azure SQL instance from their own machine.

Requirements

Runs locally over stdio as an npm package, so Node.js is needed. Requires a reachable SQL Server instance and SQL authentication credentials: MSSQL_SERVER, MSSQL_USER and the secret MSSQL_PASSWORD, plus optional settings for port, default database, encryption, certificate trust, row limits, timeout and log level. Set MSSQL_ENCRYPT to true for Azure SQL.