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.
Parses `.sqlplan` XML files and live query captures into a detailed operator tree, then runs 30+ static analysis rules to flag performance anti-patterns (spills, parameter sniffing, implicit conversions, scalar UDFs) with severity levels and actionable remediation. Exposes analysis via a Model Context Protocol (MCP) server for Claude Code integration, enabling AI-assisted plan review alongside manual inspection. Built on .NET 8 with cross-platform GUI (WPF/Avalonia) and CLI, connecting to SQL Server via standard ADO.NET with optional Query Store integration for top-query trending.
109 stars.
Stars
109
Forks
18
Language
C#
License
MIT
Category
Last pushed
Mar 18, 2026
Commits (30d)
0
Get this data via API
curl "https://pt-edge.onrender.com/api/v1/quality/mcp/erikdarlingdata/PerformanceStudio"
Open to everyone — 100 requests/day, no key needed. Get a free key for 1,000/day.
Higher-rated alternatives
bytebase/dbhub
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
HenkDz/postgresql-mcp-server
A Powerful PostgreSQL MCP server with 14 consolidated database management tools for AI assistants.
IzumiSy/mcp-duckdb-memory-server
MCP Memory Server with DuckDB backend
alexander-zuev/supabase-mcp-server
Query MCP enables end-to-end management of Supabase via chat interface: read & write query...
wenb1n-dev/mysql_mcp_server_pro
Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and...