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.
@vanterxAgentic offline orchestrator for end-to-end SQL Server performance reviews. Forms hypotheses from artifacts or symptoms,…
@vanterxAudits SQL Server Always On Availability Group configuration correctness across all layers — prerequisites, replica design,…
@vanterxAnalyze SQL Server lock blocking from sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_os_waiting_tasks, sys.dm_tran_locks,…
@vanterxAnalyze SQL Server Setup Bootstrap log files to diagnose failed installations, failed Cumulative Update or Service Pack patching,…
@vanterxAnalyzes Windows Server Failover Cluster (WSFC) CLUSTER.LOG files for Always On Availability Group root-cause diagnosis. Use this…
@vanterxAnalyze SQL Server instance and database configuration drift against proven DBA best practices. Applies 38 checks (B1–B38) across…
@vanterxAnalyze SQL Server deadlock XML (from system_health XE session, SSMS deadlock graph, or trace) to identify root cause and produce…
@vanterxAnalyze SQL Server file-level I/O latency and auto-growth events using sys.dm_io_virtual_file_stats, sys.master_files, and…
@vanterxAnalyze SQL Server encryption posture across all layers — TDE, Always Encrypted, cell-level encryption, backup encryption,…
@vanterxAnalyzes SQL Server ERRORLOG files for operational issues, availability group failures, memory pressure, I/O subsystem warnings,…
@vanterxAnalyzes sys.dm_hadr_* DMV output to assess Always On Availability Group replica health, synchronization state, secondary lag,…
@vanterxAnalyze SQL Server execution plans to produce a ranked CREATE INDEX script. Applies 13 checks (D1–D13). Derives index…
@vanterxAdds, edits or retires a check in an existing skill of this repository and propagates the change to every file that states a…
@vanterxAudits this repository's credit-and-cite rule — finds checks, thresholds, formulas, quotes, parameter names and adapted work that…
@vanterxFinds semantic drift across this repository's 29 skills and root docs that verify-docs.sh cannot detect — the same metric given…
@vanterxBuilds or refreshes a skill's worked example in this repository — a realistic, fictional input artifact that triggers a…
@vanterxKeeps this repository's remote MCP server (mcp-server/, deployed to Cloudflare Workers) in step with the skills — regenerates…
@vanterxValidates SQL Server, Azure SQL, Windows Server and PowerShell claims in this repository against Microsoft Learn, using the…
@vanterxCreates a new skill in this repository end to end — directory layout, SKILL.md, references, evals, examples, scripts — and…
@vanterxTriages failures from the repository's T-SQL lint gate (scripts/lint-tsql.ps1, run by lint-scripts.sh) — classifies each failing…
@vanterxSearches Microsoft Learn documentation for official Microsoft and Azure guidance.
@vanterxIs this you? Claim your profilePut a plugin at the top of Plugins, from $9
