Skills for reviewing SQL Server performance, covering T-SQL, execution plans, wait stats, blocking, Query Store, and Always On availability groups. Helps database administrators and developers diagnose problems with Claude Code.
Claude Code
> /plugin marketplace add vanterx/mssql-performance-skills> /plugin install mssql-performance-skills@mssql-performance-skills
Codex
$ npx skills add vanterx/mssql-performance-skills -a codex
Cursor
$ npx skills add vanterx/mssql-performance-skills -a cursor
Gemini CLI
$ npx skills add vanterx/mssql-performance-skills -a gemini-cli
GitHub Copilot
$ copilot plugin marketplace add vanterx/mssql-performance-skills$ copilot plugin install mssql-performance-skills@mssql-performance-skills
OpenCode
$ npx skills add vanterx/mssql-performance-skills -a opencode
Windsurf
$ npx skills add vanterx/mssql-performance-skills -a windsurf
Go to claude.ai → Settings → Connectors → Add custom connector, enter the URL and click Add:
https://mssql-mcp.tsx113.workers.dev
A collection of Claude Code skills covering the full SQL Server performance tuning workflow — from static T-SQL source review to execution plan analysis, I/O statistics, workload traces, wait statistics, Query Store analysis, procedure runtime stats, index recommendations, live blocking chain analysis, deadlock diagnosis, batch workload assessment, WSFC cluster log analysis, Always On AG health, AG configuration correctness, ERRORLOG operational review, SPN/Kerberos delegation diagnosis, full encryption infrastructure review (TDE, Always Encrypted, CLE, backup encryption, TLS, certificates, key hierarchy including sp_control_dbmasterkey_password/SSISDB, dynamic data masking, PCI-DSS/HIPAA/GDPR/FedRAMP compliance), instance/database configuration drift, SQL Server Setup Bootstrap log analysis, SQL Server Reporting Services (SSRS) report server trace log analysis, SQL Server migration readiness (version/edition/platform compatibility, security-object portability, operational-object portability), and two-period workload comparison (what regressed between a baseline and a current capture, and which configuration, version or wait change explains it) — plus an agentic orchestrator that routes mixed artifacts to the right specialised skill. 950 checks across 29 skills.
AI-Generated Skills — These skills were planned and generated by Claude with open source community resource guidance. The check catalog, thresholds, and output formats are intended to be improved and validated by human DBAs against real workloads. PRs welcome for new checks, threshold adjustments, or output format refinements.
| Skill | Purpose |
|---|---|
| mssql-performance-review | Agentic offline orchestrator — routes mixed artifacts (or a symptom description) to the right specialised skills, runs an adversarial root-cause check, and emits a single consolidated report with evidence chain, risk-rated fixes, and rollback. Use when you have several artifact types together or are not sure which skill to run. Also invocable as /sql-triage (equal-primary alias). |
| tsql-review | Analyze raw T-SQL source code — 85 checks (T1–T85) — structural, security, correctness, performance, SQL 2017–2022 modern syntax |
| sqlstats-review | Parse and analyze SET STATISTICS IO, TIME ON output — 27 checks (I1–I18 IO, W1–W9 time) |
| sqltrace-review | Analyze Profiler trace / Extended Events output — 27 checks (X1–X12 event-level, X13–X27 workload aggregate) |
| sqlwait-review | Analyze sys.dm_os_wait_stats — 45 checks (V1–V45) across I/O, lock, parallelism, memory, CPU, latch contention, log space, poison/throttle waits, backup I/O, insert hotspots, trend analysis, modern feature waits (In-Memory OLTP, Columnstore, Query Store, Transaction/DTC, Service Broker, Full Text, Parallel Redo), forced memory grants, grant timeouts, stolen memory, file I/O latency, IQP/PSP/ADR feature waits, TempDB metadata contention, and spinlock contention |
| sqlplan-review | Analyze a single .sqlplan file — 112 checks, prioritized report |
| sqlplan-compare | Diff two plans to find what caused a regression |
| sqlindex-advisor | Derive indexes from operator patterns + consolidate optimizer suggestions into a ranked CREATE INDEX script |
| sqldeadlock-review | Analyze a deadlock XML graph — identify pattern and fix |
| sqlblocking-review | Analyze a live or already-finished blocking incident — 55 checks (BL1–BL55): head blocker identification and state, chain topology, lock escalation and Sch-M evidence, transaction/isolation faults, per-index and Query Store lock wait history, statistics/lock-partitioning/foreign-key causes, ORM and platform patterns, capture and alerting readiness |
| sqlplan-batch | Batch-analyze a folder of plans — dashboard + index script |
| sqlquerystore-review | Analyze Query Store DMV output — 32 checks for regressed queries, plan instability, resource hotspots, configuration health, SQL 2019/2022 IQP/PSP/DOP/CE feedback, QS hints, and auto-tuning |
| sqlprocstats-review | Analyze collected sys.dm_exec_procedure_stats snapshots — 25 checks (R1–R25) for top consumers, per-execution efficiency, N+1 patterns, trends, and advanced runtime patterns |
| sqlclusterlog-review | Analyze WSFC CLUSTER.LOG for Always On AG root-cause diagnosis — 30 checks (L1–L30): lease timeouts, health check failures, quorum loss, node eviction, network partition, RHS crashes, Cloud Witness, Azure Arc, Contained AG |
| sqlhadr-review | Analyze Always On AG health from sys.dm_hadr_* DMVs — 27 checks (H1–H28, H21 retired): replica connectivity, data loss risk, recovery time, throughput, configuration, modern AG features, seeding/initialization integrity |
| sqlag-review | Audit Always On AG configuration correctness across all layers — 38 checks (F1–F38): prerequisites, replica design, listener architecture, backup strategy, endpoint security, distributed AG topology, Basic/Contained AG constraints, AG scale ceiling, automatic seeding/manual-restore mismatch |
| sqlerrorlog-review | Analyze SQL Server ERRORLOG for operational issues — 34 checks (E1–E34): AG failover events, lease expiry, memory pressure, I/O slow, corruption warnings, login failure bursts, startup/shutdown, SQL 2019/2022 feature events |
| sqlspn-review | Analyze SQL Server SPN configuration and Kerberos delegation settings — 54 checks (K1–K54): SPN presence, service account binding, AG listener and alias, permissions, delegation, AD account sensitivity, Entra ID hybrid, gMSA rollover, CNAME alias, double-hop platform constraints (linked server, SSISDB), clock skew and token size, SQL Server on Linux keytabs, client driver limits |
| sqlmemory-review | Analyze SQL Server memory pressure from memory clerks, PLE, plan cache, and memory grants — 20 checks (O1–O20): PLE, plan cache bloat, grant queue depth, grant timeout, ColumnStore/XTP footprint, OS pressure, LPIM, Max Server Memory |
| sqlperfmon-review | Analyze Windows Perfmon counter data for the SQL Server host — 15 checks (PM1–PM15): CPU attribution between SQL Server and other processes, privileged/kernel time, page life expectancy shape, virtual address space growth, OS available memory, per-volume disk latency, hot volume masked by _Total, compile/recompile rates against batch throughput, plan cache growth by cache type, batch request baseline shift, client cancellation rate, capture integrity |
| sqlworkload-compare | Compare two captures of the same workload — baseline and current, fast day and slow day, before and after a change — 14 checks (WC1–WC14): comparability, per-query regressions matched by query_hash and ranked by added time, regression class (CPU-, reads-, wait-driven), new and disappeared heavy queries, volume shifts, configuration/version/database-option differences, wait-profile shift |
| sqldiskio-review | Analyze SQL Server file-level I/O latency and auto-growth events from sys.dm_io_virtual_file_stats — 15 checks (Z1–Z15): data/log latency, hot file, stall ratio, storage placement, TempDB co-location, auto-growth sizing and timing |
| sqlencryption-review | Analyze the full SQL Server encryption posture from DMV output — 112 checks (A1–A112) across 20 categories: TDE, Always Encrypted, CLE, Backup, Transport/TLS, Certificates, Keys, Key Hierarchy, EKM/AKV, Compliance, TLS Hardening, AE Advanced, Key Lifecycle, Ledger, Azure, DMK Password Auto-Open (sp_control_dbmasterkey_password/SSISDB), DDM Patterns, Compliance Explicit (PCI-DSS v4/HIPAA/GDPR/FedRAMP), Operational Validation, Advanced Crypto Patterns |
| sqlbootstraplog-review | Analyze SQL Server Setup Bootstrap logs (Summary.txt, Detail.txt, MSI logs, ConfigurationFile.ini) to diagnose failed installs, failed CU/SP patches, and risky setup-time configuration — 25 checks (U1–U25): exit-code extraction, failed setup rules, pending reboot, MSI Return value 3 forensics, service accounts, IFI, TempDB layout, security surface, directory placement |
| sqldbconfig-review | Analyze SQL Server instance and database configuration drift from sp_configure and sys.databases output — 38 checks (B1–B38): MAXDOP alignment to NUMA, Cost Threshold for Parallelism, Max Server Memory, auto-shrink, auto-close, compatibility level, RCSI, page verification, auto-statistics, VLF count, percent auto-growth, Instant File Initialization, TempDB file count, surface area exposure, service-SID sysadmin membership, Common Criteria compliance, scheduler count vs OS CPU count, access check cache, power plan, non-Microsoft loaded modules |
| ssrstracelog-review | Analyze SQL Server Reporting Services (SSRS) report server trace logs, RSReportServer.config/ReportingServicesService.exe.config excerpts, ExecutionLog3 output, and Event Log entries — 24 checks (G1–G24): trace configuration health, report server database connectivity, memory pressure and AppDomain recycling, report processing/rendering performance, subscription delivery failures, scale-out and encryption key management |
| sqlmigration-review | Audit SQL Server migration version/edition/platform compatibility — 15 checks (Y1–Y15): edition-gated features, version/compatibility-level ceiling, collation, discontinued features, In-Memory OLTP, Azure SQL limits, backup/log-chain readiness, AG seeding edition limits, source lifecycle urgency. Dispatcher with own checks |
| sqlmigration-security-review | Audit security-object portability for a SQL Server migration — 15 checks (J1–J15): login portability, permission fidelity, credentials/proxies, certificates/keys, CMS registrations |
| sqlmigration-objects-review | Audit operational-object portability for a SQL Server migration — 16 checks (M1–M16): SQL Agent jobs/operators/alerts/proxies, linked servers, Database Mail, backup devices, custom errors, server triggers, XE sessions, endpoints |
5 minutes to your first analysis:
/sqlplan-review skills/sqlplan-review/examples/horrible.sqlplan
Don't have a plan yet? Use the symptom-based routing in PERFORMANCE_TUNING_GUIDE.md to pick the right skill for what you have.
The skills are plain Markdown files. Copy them into your agent's skills directory — no build, no runtime, no dependencies.
Option 1: Plugin Marketplace (recommended)
# Add the marketplace (once per machine or project)
/plugin marketplace add vanterx/mssql-performance-skills
# Install all 29 skills
/plugin install mssql-performance-skills@mssql-performance-skills
Stars on GitHub
A development methodology for coding agents that makes the agent brainstorm before building, follow plans, run parallel work and finish branches in a disciplined way. You get fewer skipped steps and more consistent results from your coding assistant.
@obraHelps you take a change from a rough idea or bug report through to a tested, reviewed result, with each step handled by a focused skill. Its skills cover pinning down domain terms, designing module interfaces, diagnosing hard bugs, and reviewing changes against your repo's coding standards.
@mattpocockGives your coding agent a planning, testing and review routine to follow on every task. It plans before building, checks changes with tests, has a fresh reviewer look for regressions, and saves repeated wins as reusable skills.
@affaan-mDeveloper tools for working on the React codebase itself. Provides skills for extracting error messages, managing and debugging feature flags across release channels, running Flow type checks, and fixing lint and formatting issues before committing.
@facebookInstall it with the command on its page. It includes mssql-performance-review, sqlag-review, sqlblocking-review. Its skills do not fire on their own yet. Free and open source.
Is this plugin yours?
Claim it with GitHubSubmit a pluginPromote it