erikdarlingdata / PerformanceStudio
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.
Why this job: says: mcp server; topics: mcp-server, model-context-protocol
What it does
- 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
Get started
No single install command. Read the steps in the README (opens in new tab)
- Maintenance
- Active
- Last commit 21 days ago
- Stars
- 250
- +2 this week
- Licence
- MIT
- Allows business use
- Downloads for
- 3 systems
- Mac, Windows, Linux
- Latest version
- v1.31.0
- Released 21 days ago
- Built with
- C#
- 95% of the code
Is it looked after?
- Contributors
- 2
- Last 90 days
- Issues
- 98% closed
- 3 still open
- Pull requests
- 526 merged
- 0 waiting
- Releases
- 56
- 30+ in the last year
- Contributing guide (opens in new tab)
- Security policy (opens in new tab)
- No code of conduct
More: download files, languages, topics and project record
Download files, v1.31.0
- Mac2 files, 47 downloads
- Windows2 files, 72 downloads
- Linux1 file, 26 downloads
Languages
- C# 95%
- HTML 4%
- CSS 1%
- Batchfile <1%
Topics
- avalonia
- cross-platform
- database-performance
- dba-tools
- dotnet
- execution-plan
- query-performance
- query-store
- query-tuning
- sql-server
- sql-server-management
- sqlplan
Project record
- JobMCP servers
- StatusListed
- Commits1,075
- Forks39
- Watching6
- Stars in 28 days+5
- CreatedMar 4, 2026
- First seen by usNov 7, 2026
- CheckedNov 10, 2026