{"id":"bcf23266-5f68-4533-a35b-56d3a2a739ab","shortId":"QAWMSf","kind":"skill","title":"Review SQL Server execution plans through an MCP-compatible analysis workflow with Performance Studio","tagline":"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.","description":"# Review SQL Server execution plans through an MCP-compatible analysis workflow with Performance Studio\n\nUse 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.\n\n## Prerequisites\n\nPerformance Studio via its built-in MCP server or CLI, plus SQL Server execution plan files or a reachable SQL Server environment.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- git clone https://github.com/erikdarlingdata/PerformanceStudio.git\n- docker run -e \"ACCEPT_EULA=Y\" -e \"MSSQL_SA_PASSWORD=YourPassword123\" \\\n\nRequirements and caveats from upstream:\n- Each warning includes severity (Info, Warning, or Critical), the operator node ID, and enough context to act on immediately.\n- Docker (optional — macOS/Linux users can run SQL Server locally via Docker)\n- [Critical] Parallelism (Node 0): Estimated 1 rows, actual 2,889 (2889x underestimated).\n\nBasic usage or getting-started notes:\n- **Missing indexes** — extracts SQL Server's index suggestions with ready-to-run CREATE statements\n- [.NET 8 SDK](https://dotnet.microsoft.com/download/dotnet/8.0) (required to build and run)\n- SQL Server instance (optional — only needed for live plan capture; file analysis works without one)\n\n- Source: https://github.com/erikdarlingdata/PerformanceStudio\n- Extracted from upstream docs: https://raw.githubusercontent.com/erikdarlingdata/PerformanceStudio/HEAD/README.md\n\n## Documentation\n\n- https://github.com/erikdarlingdata/PerformanceStudio\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio/)","tags":["review","sql","server","execution","plans","through","mcp","compatible","analysis","workflow","with","performance"],"capabilities":["skill","source-agentskillexchange","skill-review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,813 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:12:07.834Z","embedding":null,"createdAt":"2026-05-18T13:18:53.900Z","updatedAt":"2026-05-18T19:12:07.834Z","lastSeenAt":"2026-05-18T19:12:07.834Z","tsv":"'/download/dotnet/8.0)':227 '/erikdarlingdata/performancestudio':251,262 '/erikdarlingdata/performancestudio.git':141 '/erikdarlingdata/performancestudio/head/readme.md':258 '/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio/)':269 '0':191 '1':193 '2':196 '2889x':198 '8':223 '889':197 'accept':145 'act':174 'actual':195 'agent':24,74,264 'agentskillexchange.com':268 'agentskillexchange.com/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio/)':267 'analysi':11,61,244 'basic':200 'build':230 'built':107 'built-in':106 'captur':242 'caveat':155 'cli':112 'clone':138 'compat':10,23,60,73 'context':172 'creat':220 'critic':165,188 'doc':255 'docker':142,177,187 'document':259 'dotnet.microsoft.com':226 'dotnet.microsoft.com/download/dotnet/8.0)':225 'e':144,148 'enough':171 'environ':124,136 'estim':192 'eula':146 'evid':45,95 'exchang':266 'execut':4,43,54,93,116 'execution-plan':42,92 'extract':209,252 'file':31,81,118,243 'get':204 'getting-start':203 'git':137 'github.com':140,250,261 'github.com/erikdarlingdata/performancestudio':249,260 'github.com/erikdarlingdata/performancestudio.git':139 'id':169 'immedi':176 'includ':160 'index':38,88,208,213 'info':162 'inspect':35,85 'instal':125,129 'instanc':235 'live':240 'local':185 'macos/linux':179 'match':134 'mcp':9,22,59,72,109 'mcp-compat':8,21,58,71 'miss':37,87,207 'missing-index':36,86 'mssql':149 'need':25,75,238 'net':222 'node':168,190 'note':206 'one':247 'oper':167 'option':178,236 'parallel':189 'pars':27,77 'password':151 'path':132 'perform':14,17,33,64,67,83,102 'plan':5,44,55,94,117,241 'plus':113 'prerequisit':101 'raw.githubusercontent.com':257 'raw.githubusercontent.com/erikdarlingdata/performancestudio/head/readme.md':256 'reachabl':121 'readi':217 'ready-to-run':216 'requir':153,228 'review':1,48,51,98 'row':194 'run':143,182,219,232 'sa':150 'sdk':224 'server':3,29,53,79,110,115,123,184,211,234 'setup':131 'sever':161 'skill':265 'skill-review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio' 'sourc':248,263 'source-agentskillexchange' 'sql':2,28,52,78,114,122,183,210,233 'sqlplan':30,80 'start':205 'statement':221 'studio':15,18,65,68,103 'suggest':39,89,214 'surfac':32,82 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'tune':49,99 'turn':41,91 'underestim':199 'upstream':128,157,254 'usag':201 'use':16,66,126 'user':180 'via':104,186 'warn':34,84,159,163 'without':246 'work':245 'workflow':12,50,62,100 'y':147 'yourpassword123':152","prices":[{"id":"5ebb9cc8-69f7-40ce-a429-a30b9c9817ff","listingId":"bcf23266-5f68-4533-a35b-56d3a2a739ab","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:18:53.900Z"}],"sources":[{"listingId":"bcf23266-5f68-4533-a35b-56d3a2a739ab","source":"github","sourceId":"agentskillexchange/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:53.900Z","lastSeenAt":"2026-05-18T19:12:07.834Z"}],"details":{"listingId":"bcf23266-5f68-4533-a35b-56d3a2a739ab","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"c8effa4bf9b183d1c3360c4ee82c20d896bac502","skill_md_path":"skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Review SQL Server execution plans through an MCP-compatible analysis workflow with Performance Studio","description":"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."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/review-sql-server-execution-plans-through-an-mcp-compatible-analysis-workflow-with-performance-studio"},"updatedAt":"2026-05-18T19:12:07.834Z"}}