Skip to content

v0.8.0 — MCP Server for AI-Assisted Plan Analysis

Choose a tag to compare

@erikdarlingdata erikdarlingdata released this 05 Mar 02:27
· 436 commits to main since this release
f347180

What's New

MCP Server

Performance Studio now includes a built-in Model Context Protocol (MCP) server, enabling AI assistants like Claude to analyze execution plans loaded in the app.

13 read-only tools for plan analysis:

  • list_plans, analyze_plan, get_plan_summary, get_plan_warnings
  • get_missing_indexes, get_plan_parameters, get_expensive_operators
  • get_plan_xml, compare_plans, get_repro_script
  • get_connections, check_query_store, get_query_store_top

Query Store tools use only the built-in fetch query — no arbitrary SQL execution.

Setup:

  1. Enable in ~/.planview/settings.json: { "mcp_enabled": true, "mcp_port": 5152 }
  2. Add to your MCP client config:
    {
      "mcpServers": {
        "performance-studio": {
          "type": "streamable-http",
          "url": "http://localhost:5152/"
        }
      }
    }

Other Changes

  • Renamed from "SQL Performance Studio" to "Performance Studio"
  • MCP enable/port toggle added to Help > About screen
  • Release automation: zips now auto-attach to GitHub releases