Releases: erikdarlingdata/PerformanceStudio
Releases · erikdarlingdata/PerformanceStudio
v1.2.0
v1.2.0
Query Store Enhancements
- Search/filter by identifier: Server-side fetch by Query ID, Plan ID, Query Hash, Plan Hash, Module Name with wildcard support (#93)
- History drill-down: Right-click "View History" opens multi-plan time-series chart with ScottPlot, 13 selectable metrics, hover tooltips (#98)
- Database picker on Query Store tab — switch databases without reopening (#93)
- Context menu copy commands: Copy Query ID, Plan ID, Query Hash, Plan Hash, Module Name, Query Text, Row (#94)
- Select All/None toggle button, Enter-to-fetch in search box
Bug Fixes
- Database picker now correctly changes query editor execution context (#95)
- Fix crash when loading Query Store plans — ObjectDisposedException in SetStatus (#105)
Code Quality (22 fixes)
- MCP session leak on plan tab close
- CancellationTokenSource disposal across all controls
- TextMate.Installation disposal
- Consolidated duplicate connection dialog code
- CLI: credential check, --output flag, input validation, .env support for query-store command
- Core: async disposal, KeychainCredentialService deadlock fix, ShowPlanParser error handling
- Removed dead QueryStoreDialog code
Contributors
Thanks to the community contributors in this release:
- @rferraton — reported and helped diagnose the SetStatus crash (#105, #106)
- @ClaudioESSilva — fix #81
Nightly Build (1.2.0-nightly.20260318)
Automated nightly build from dev branch.
Version: 1.2.0-nightly.20260318
Commit: f4f66ec
Built: 2026-03-18 06:32 UTC
These builds include the latest changes and may be unstable.
For production use, download the latest stable release.
v1.1.0
What's Changed
- Plan analyzer improvements by @erikdarlingdata in #65
- Plan viewer: edge tooltips, context menu, ManyToMany, DOP-aware rules by @erikdarlingdata in #66
- Advice for Humans UX polish: operator grouping, bars, colors, margins by @erikdarlingdata in #70
- Add nightly build workflow by @erikdarlingdata in #71
- Pass AnalysisResult through to AdviceContentBuilder by @erikdarlingdata in #72
- Fix false positive parallel skew warning at DOP 2 by @erikdarlingdata in #74
- Add recent plans menu and session restore by @erikdarlingdata in #75
- Format memory grants as KB/MB/GB by @erikdarlingdata in #76
- Bump version to 1.1.0 by @erikdarlingdata in #77
- Release v1.1.0 by @erikdarlingdata in #78
Full Changelog: v1.0.0...v1.1.0
v1.0.0
What's Changed
- Add syntax highlighting to Advice for Humans window by @erikdarlingdata in #47
- Fix macOS release packaging to use proper .app bundle by @erikdarlingdata in #51
- Fix Linux crash and plan execution timeout by @erikdarlingdata in #52
- Execute selection, from cursor, and current batch (#53) by @erikdarlingdata in #54
- Fix nullable databaseName in ActualPlanExecutor by @erikdarlingdata in #55
- Issue #48: Advice window styling, operator timing, rules, UI consistency by @erikdarlingdata in #56
- Add Check for Updates to About window by @erikdarlingdata in #57
- Root tooltip cleanup, seek predicate formatting, row goal filter by @erikdarlingdata in #58
- Plan viewer: own-time rendering, efficiency colors, wait stats polish by @erikdarlingdata in #59
- Expand test suite with 10 new tests and fixture plans by @erikdarlingdata in #60
- Fix exchange operator timing and add stream labels by @erikdarlingdata in #61
- UX polish: advice, warnings, efficiency, node rendering by @erikdarlingdata in #62
- v1.0.0: Bug fixes and version bump by @erikdarlingdata in #63
- Release v1.0.0 by @erikdarlingdata in #64
Full Changelog: v0.9.0...v1.0.0
v0.9.0
What's Changed
- Fix obsolete clipboard warnings by @erikdarlingdata in #39
- Show all plan warnings in root operator tooltip by @erikdarlingdata in #40
- Add Server Context pane to Plan Insights by @erikdarlingdata in #41
- Fix/query store grid usability by @ClaudioESSilva in #18
- Fix warnings gap in properties panel (#29) by @erikdarlingdata in #42
- Add MCP copy button to About screen (#26) by @erikdarlingdata in #43
- Show loading placeholder tab for Run Repro Script (#24) by @erikdarlingdata in #44
- Bump version to 0.9.0 by @erikdarlingdata in #45
- Release v0.9.0 by @erikdarlingdata in #46
New Contributors
- @ClaudioESSilva made their first contribution in #18
Full Changelog: v0.8.2...v0.9.0
v0.8.2
What's Changed
- Add auto-release workflow on dev-to-main merge by @erikdarlingdata in #12
- Add PR branch check and version bump check by @erikdarlingdata in #13
- Add THIRD_PARTY_NOTICES.md, update README by @erikdarlingdata in #19
- Add screenshots to README by @erikdarlingdata in #21
- Update README screenshot descriptions by @erikdarlingdata in #25
- Fix MCP transport type: streamable-http → http by @erikdarlingdata in #27
- Add MCP integration screenshot to README by @erikdarlingdata in #28
- Add operator tooltip and properties screenshots by @erikdarlingdata in #30
- Add multi-statement navigation screenshot by @erikdarlingdata in #31
- Bump version to 0.8.1 by @erikdarlingdata in #32
- Release v0.8.1 — Screenshots, docs, workflow improvements by @erikdarlingdata in #33
- Fix release workflow: build and upload in single workflow by @erikdarlingdata in #34
- Release v0.8.1 — Fix release workflow, screenshots, docs by @erikdarlingdata in #35
- Fix release workflow: add shell: bash for non-PowerShell steps by @erikdarlingdata in #36
- Bump version to 0.8.2 by @erikdarlingdata in #37
- Release v0.8.2 — Screenshots, docs, release automation fix by @erikdarlingdata in #38
Full Changelog: v0.8.0...v0.8.2
v0.8.0 — MCP Server for AI-Assisted Plan Analysis
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_warningsget_missing_indexes,get_plan_parameters,get_expensive_operatorsget_plan_xml,compare_plans,get_repro_scriptget_connections,check_query_store,get_query_store_top
Query Store tools use only the built-in fetch query — no arbitrary SQL execution.
Setup:
- Enable in
~/.planview/settings.json:{ "mcp_enabled": true, "mcp_port": 5152 } - 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
v0.7.0
SQL Performance Studio v0.7.0
New Features
- Parameters & Variables pane in Plan Insights — shows parameter names, data types, compiled values, and runtime values with parameter sniffing detection
- Spool labels — Eager/Lazy qualifier now shown on spool operators in the graphical plan
- Editor context menu — Cut, Copy, Paste, Select All in the query editor
Downloads
| Platform | File |
|---|---|
| Windows (x64) | PerformanceStudio-win-x64.zip |
| macOS (Apple Silicon) | PerformanceStudio-osx-arm64.zip |
| macOS (Intel) | PerformanceStudio-osx-x64.zip |
| Linux (x64) | PerformanceStudio-linux-x64.zip |
| SSMS Extension | PlanViewer.Ssms.vsix + InstallSsmsExtension.exe |
Self-contained — no .NET SDK required. Extract and run.