PerformanceStudio MCP server

Free, open-source SQL Server execution plan analyzer — cross-platform GUI + CLI with 30 analysis rules, missing index detection, SSMS extension. Built-in MCP server for AI-assisted plan review.

What PerformanceStudio does

Summarised from the project README; check the repository for the latest details.

Features

• Large memory grants — flags queries hoarding memory they don't use
• Row estimate mismatches — finds operators where estimates are 10x+ off from actuals
• Missing indexes — extracts SQL Server's index suggestions with ready-to-run CREATE statements
• Hash, sort, and exchange spills — identifies operators spilling to TempDB with severity based on volume
• Parallel skew — detects threads doing all the work while others sit idle
• Scan predicates — warns when scans filter rows with residual predicates

Tools exposed (2)

• Category – Tools
• Discovery – `listplans`, `getconnections`

Requirements

• .NET 10 SDK (only needed to build from source — the pre-built binaries below are self-contained and require no SDK)
• SQL Server instance (optional — only needed for live plan capture; file analysis works without one)
• Docker (optional — macOS/Linux users can run SQL Server locally via Docker)

How to install PerformanceStudio

Featured in: Best MCP servers for SQL Server

Listed on Socketlist – add this badge to your README:

Badge markdown[](https://socketlist.pages.dev/s/erikdarlingdata-performancestudio/)

Maintain this project? Get it featured for free during launch →

Compare with codebase-memory-mcp →

Related Databases MCP servers