通过 Performance Studio 中与 MCP 兼容的分析工作流审查 SQL Server 执行计划
Use Performance Studio when an MCP-compatible agent needs to parse SQL Server .sqlplan files, surface performance warnings, inspect missing-index suggestions, and turn execution-plan evidence into a reviewable tuning workflow.
Prerequisites
Performance Studio via its built-in MCP server or CLI, plus SQL Server execution plan files or a reachable SQL Server environment.
Installation
Use the upstream install or setup path that matches your environment:
- git clone https://github.com/1991513ccie-png/skills
- docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=YourPassword123" \
Requirements and caveats from upstream:
- Each warning includes severity (Info, Warning, or Critical), the operator node ID, and enough context to act on immediately.
- Docker (optional — macOS/Linux users can run SQL Server locally via Docker)
- [Critical] Parallelism (Node 0): Estimated 1 rows, actual 2,889 (2889x underestimated).
Basic usage or getting-started notes:
- Missing indexes — extracts SQL Server's index suggestions with ready-to-run CREATE statements
- .NET 8 SDK (required to build and run)
- SQL Server instance (optional — only needed for live plan capture; file analysis works without one)
- Source: https://github.com/1991513ccie-png/skills
- Extracted from upstream docs: https://raw.githubusercontent.com/erikdarlingdata/PerformanceStudio/HEAD/README.md
Documentation
- https://github.com/1991513ccie-png/skills
