skills.rest
vanterx
vanterxCOMMUNITY
Explore all skills by this author →
GitHub

sqlplan-batch

Aggregate .sqlplan files to surface workload-wide performance issues and consolidated index recommendations.

5|Updated May 2, 2026
Search Tags:#performance#indexes#sql-server#workload#batch-analysis#sqlplan
One-click install
npx skills add https://github.com/vanterx/mssql-performance-skills --skill sqlplan-batch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlplan-batch
Source: https://github.com/vanterx/mssql-performance-skills/tree/main/skills/sqlplan-batch
Command: npx skills add https://github.com/vanterx/mssql-performance-skills --skill sqlplan-batch

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Batch-analyze a folder of SQL Server .sqlplan files and produce a summary dashboard of the top issues, most common violations, and deduplicated missing indexes across all plans. Use this skill whenever you have a workload capture that produced multiple .sqlplan files and you want a workload-level view that prioritizes where to look first.

Core Features & Use Cases

  • Analyze multiple .sqlplan files in bulk applying the full 87-check rules (S1–S27, N1–N60) to each plan.
  • Generate an aggregated batch report that surfaces the top expensive plans, most frequent violations, and a consolidated missing index script.
  • Use after workload captures to identify systemic patterns, prioritize investigations, and coordinate follow-up checks with /sqlplan-review and /sqlplan-index-advisor.

Quick Start

Run /sqlplan-batch on a folder of .sqlplan files to generate batch-analysis.md.

Frequently Asked Questions about sqlplan-batch

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze multiple SQL Server execution plans for workload-wide performance issues?▼

Batch-analyze SQL Server execution plans by aggregating a directory of .sqlplan files to surface workload-wide performance issues, identifying expensive plans and systemic violations across the entire capture.

What is the best way to consolidate missing index recommendations from multiple .sqlplan files?▼

Consolidate missing index recommendations by running a batch analysis across multiple .sqlplan files, which merges and deduplicates index suggestions into a single consolidated script for workload optimization.

How do I generate a summary report of the most frequent SQL plan violations across a workload capture?▼

Generate a summary report by processing a folder of .sqlplan files through an 87-check ruleset, producing an aggregated dashboard with an executive summary and per-plan findings for the captured workload.

Does batch SQL plan analysis apply the same performance checks as individual plan reviews?▼

Batch SQL plan analysis applies the exact same 87-check ruleset (S1–S27, N1–N60) to each individual plan as a standard single-plan review, ensuring comprehensive systemic violation detection across the workload.

Can I prioritize which SQL Server queries to investigate first from a large workload capture?▼

Prioritize SQL Server query investigations by using a batch report that surfaces the top expensive plans and most common violations, directing you to the most critical performance issues first.

What format is output when analyzing a directory of .sqlplan files?▼

Analyzing a directory of .sqlplan files outputs a comprehensive batch-analysis markdown report containing an executive summary, per-plan findings, and a consolidated missing index script.

Related Skills

Explore More Data & Analytics Skills→
pczhao1210pczhao1210

sql-optimization

Analyze SQL execution plans and recommend indexes across relational databases.

Community
Advanced
ntaksh42ntaksh42
1

sql-query-helper

Generate, optimize, and explain SQL queries for PostgreSQL, MySQL, SQLite, and SQL Server.

Community
Intermediate
lucasfcostalucasfcosta
62

plan-review

Evaluate implementation plans for soundness and compatibility with existing infrastructure.

Community
Intermediate
AppsVortexAppsVortex
31

arn-code-execute-task

Execute a single task by spawning an isolated executor agent.

Official
Advanced