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.

#avalonia#cli#cross-platform#database-performance#dba-tools#dotnet#execution-plan#mcp-server#model-context-protocol#query-optimization#query-performance#query-plan#query-store#query-tuning#sql-plan-analyzer#sql-server#sql-server-management#sqlplan#ssms-extension

Install

git clone https://github.com/erikdarlingdata/PerformanceStudio.git

Claude Desktop config

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "performancestudio": {
      "command": "npx",
      "args": [
        "-y",
        "github:erikdarlingdata/PerformanceStudio"
      ]
    }
  }
}

From the README

A cross-platform SQL Server execution plan analyzer with built-in MCP server for AI-assisted analysis. Parses XML, identifies performance problems, suggests missing indexes, and provides actionable warnings — from the command line or a desktop GUI. Built for developers and DBAs who want fast, automated plan analysis without clicking through SSMS. Write queries with syntax highlighting and SQL keyword completion, connect to any SQL Server, and capture plans with one click. Graphical plan tree with SSMS-style operator icons, cost percentages, row counts, and warning badges.…

Read full README on GitHub →