PerformanceStudio

Overview

Performance Studio is a comprehensive SQL Server execution plan analyzer that combines a cross-platform GUI and CLI tool with a built-in MCP server for AI-assisted plan review. It parses .sqlplan XML files, identifies performance issues like missing indexes, estimate mismatches, and expensive operators, providing actionable warnings. The application supports direct connections to SQL Server instances, batch processing of queries, and detailed plan comparisons. The MCP integration allows AI models to analyze loaded plans, identify warnings, suggest indexes, and compare plans seamlessly.

Try asking AI

After installing, here are 3 things you can ask your AI assistant:

• analyze_sqlplan

  Analyze SQL Server execution plans from .sqlplan files

  Try:Analyze this SQL execution plan for performance issuesTry:What warnings does this query plan have?Try:Find missing indexes in this plan file
• analyze_live_plan

  Capture and analyze execution plans from a live SQL Server

  Try:Run this query on SQL Server and analyze its execution planTry:Capture the estimated execution plan for a query without running itTry:Analyze the plan for this query against my SQL Server instance
• compare_plans

  Compare two SQL Server execution plans side by side

  Try:Compare these two execution plans and show the differencesTry:What changed between these two query plans?Try:Show me the performance differences between these plans
• get_query_store

  Fetch and analyze query store data from SQL Server

  Try:Get the top CPU-consuming queries from query storeTry:Analyze the most executed queries in my databaseTry:Fetch queries with high duration from query store
• get_warnings

  Extract warnings from a SQL execution plan

  Try:What warnings are in this execution plan?Try:Find all critical issues in this query planTry:Show me the performance warnings for this plan
• get_missing_indexes

  Extract missing index suggestions from SQL execution plans

  Try:What indexes are missing from this query plan?Try:Show me the recommended indexes for this planTry:Generate CREATE INDEX statements for missing indexes
• analyze_operator

  Analyze a specific operator in a SQL execution plan

  Try:Analyze this specific operator in the planTry:What does this sort operator in the plan do?Try:Explain the parallelism operator in this query plan

Comparable tools

Installation

git clone https://github.com/erikdarlingdata/PerformanceStudio.git
cd PerformanceStudio
dotnet build

{
  "mcpServers": {
    "performance-studio": {
      "command": "dotnet",
      "args": ["run", "--project", "src/PlanViewer.Cli", "--", "mcp"]
    }
  }
}

Compare PerformanceStudio with