sqlplan-batch

Community

Batch-analyze SQL plans for workload insights.

Authorvanterx
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sqlplan-batch
Download link: https://github.com/vanterx/mssql-performance-skills/archive/main.zip#sqlplan-batch

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.