{"id":"erikdarlingdata-performancestudio","name":"PerformanceStudio","af_score":57.2,"security_score":59.5,"reliability_score":28.8,"what_it_does":"PerformanceStudio analyzes SQL Server execution plans (.sqlplan XML), flags performance issues (memory grants, estimation mismatches, spills, parallel skew, late filters, lookups, scalar UDFs, implicit conversions, anti-patterns, etc.), suggests missing indexes, and can capture actual/estimated plans from a live SQL Server. It provides both CLI/JSON outputs for automation and a desktop GUI. It also includes an opt-in built-in MCP server to let LLM clients analyze loaded plans and Query Store data.","best_when":"You need repeatable, automation-friendly execution-plan review for SQL Server workloads and want actionable missing-index and warning outputs, optionally augmented by an LLM via MCP.","avoid_when":"You can’t or don’t want to provide database connectivity (for actual plan capture) or you require a server-side, centrally managed API with standard enterprise auth/telemetry controls.","last_evaluated":"2026-03-30T13:43:33.302091+00:00","has_mcp":true,"has_api":false,"auth_methods":["CLI: server connection via --login/--password (or --trust-cert)","Credential store/OS keychain: planview credential add/list/remove; then connect without passing password","MCP: local registration with Claude Code (transport http, user scope in MCP URL)"],"has_free_tier":false,"known_gotchas":["MCP server is opt-in via a local settings file; agents must ensure the server is enabled and the correct port is used.","If the agent triggers “Get Actual Plan”/live capture workflows, queries may be executed—coordinate with safe/estimated modes to avoid unintended workload.","No explicit rate-limit headers or retry/backoff guidance is described in the provided content for MCP/API usage."],"error_quality":0.0}