31 instruction files for AI agents, collected from vanterx/mssql-performance-skills. Install any of them at an exact version with mdr add vanterx/mssql-performance-skills/<name>.
AGENTS.md AGENTS.md file
vanterx/mssql-performance-skills · AGENTS.md
git:20260709.012214c · audit A · 12 stars
CLAUDE.md CLAUDE.md file
vanterx/mssql-performance-skills · CLAUDE.md
git:20261028.d6bebb7 · audit A · 12 stars
mssql-performance-review SKILL.md skill
vanterx/mssql-performance-skills · skills/mssql-performance-review/SKILL.md · Agentic offline orchestrator for end-to-end SQL Server performance reviews. Forms hypotheses from artifacts or…
git:20261015.4b8976e · audit B · 12 stars
sqlag-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlag-review/SKILL.md · Audits SQL Server Always On Availability Group configuration correctness across all layers — prerequisites, replica…
git:20261015.4b8976e · audit B · 12 stars
sqlblocking-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlblocking-review/SKILL.md · Analyze SQL Server lock blocking from sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_os_waiting_tasks…
git:20261006.2c73ad2 · audit B · 12 stars
sqlbootstraplog-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlbootstraplog-review/SKILL.md · Analyze SQL Server Setup Bootstrap log files to diagnose failed installations, failed Cumulative Update or Service Pack…
git:20261015.4b8976e · audit B · 12 stars
sqlclusterlog-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlclusterlog-review/SKILL.md · Analyzes Windows Server Failover Cluster (WSFC) CLUSTER.LOG files for Always On Availability Group root-cause…
git:20261006.2c73ad2 · audit B · 12 stars
sqldbconfig-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqldbconfig-review/SKILL.md · Analyze SQL Server instance and database configuration drift against proven DBA best practices. Applies 38 checks…
git:20261015.4b8976e · audit B · 12 stars
sqldeadlock-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqldeadlock-review/SKILL.md · Analyze SQL Server deadlock XML (from system_health XE session, SSMS deadlock graph, or trace) to identify root cause…
git:20261006.2c73ad2 · audit B · 12 stars
sqldiskio-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqldiskio-review/SKILL.md · Analyze SQL Server file-level I/O latency and auto-growth events using sys.dm_io_virtual_file_stats, sys.master_files…
git:20261006.2c73ad2 · audit B · 12 stars
sqlencryption-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlencryption-review/SKILL.md · Analyze SQL Server encryption posture across all layers — TDE, Always Encrypted, cell-level encryption, backup…
git:20261027.374fdae · audit B · 12 stars
sqlerrorlog-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlerrorlog-review/SKILL.md · Analyzes SQL Server ERRORLOG files for operational issues, availability group failures, memory pressure, I/O subsystem…
git:20261006.2c73ad2 · audit B · 12 stars
sqlhadr-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlhadr-review/SKILL.md · Analyzes sys.dm_hadr_* DMV output to assess Always On Availability Group replica health, synchronization state…
git:20261006.2c73ad2 · audit B · 12 stars
sqlindex-advisor SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlindex-advisor/SKILL.md · Analyze SQL Server execution plans to produce a ranked CREATE INDEX script. Applies 13 checks (D1–D13). Derives index…
git:20261006.2c73ad2 · audit B · 12 stars
sqlmemory-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlmemory-review/SKILL.md · Analyze SQL Server memory pressure using buffer pool metrics, plan cache composition, memory grants, and memory clerk…
git:20261006.2c73ad2 · audit B · 12 stars
sqlmigration-objects-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlmigration-objects-review/SKILL.md · Audits the operational-object migration plan for a SQL Server move with 16 checks (M1-M16) — SQL Agent…
git:20261006.2c73ad2 · audit B · 12 stars
sqlmigration-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlmigration-review/SKILL.md · Audits a SQL Server migration plan with 15 checks (Y1-Y15) for version, edition, platform, and source-topology…
git:20261015.4b8976e · audit B · 12 stars
sqlmigration-security-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlmigration-security-review/SKILL.md · Audits the security-object migration plan for a SQL Server move with 15 checks (J1-J15) — logins, server and database…
git:20261006.2c73ad2 · audit B · 12 stars
sqlperfmon-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlperfmon-review/SKILL.md · Analyze Windows Performance Monitor counter data for a SQL Server host to establish whether the operating system itself…
git:20261015.4b8976e · audit B · 12 stars
sqlplan-batch SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlplan-batch/SKILL.md · Batch-analyze a folder of SQL Server .sqlplan files and produce a summary dashboard of the top issues, most common…
git:20261006.2c73ad2 · audit B · 12 stars
sqlplan-compare SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlplan-compare/SKILL.md · Diff two SQL Server execution plans (baseline vs regression) to identify what changed — join strategies, memory grants…
git:20261006.2c73ad2 · audit B · 12 stars
sqlplan-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlplan-review/SKILL.md · Analyze SQL Server execution plans for performance anti-patterns, bottleneck identification, and actionable fix…
git:20261027.374fdae · audit B · 12 stars
sqlprocstats-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlprocstats-review/SKILL.md · Analyze SQL Server procedure/trigger/function runtime stats collected from sys.dm_exec_procedure_stats into…
git:20261015.4b8976e · audit B · 12 stars
sqlquerystore-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlquerystore-review/SKILL.md · Analyze SQL Server Query Store data to identify regressed queries, plan instability, top resource consumers…
git:20261016.b128771 · audit B · 12 stars
sqlspn-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlspn-review/SKILL.md · Analyzes SQL Server SPN (Service Principal Name) configuration and Kerberos delegation settings to diagnose…
git:20261027.3c735c4 · audit B · 12 stars
sqlstats-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlstats-review/SKILL.md · Parse and analyze SQL Server SET STATISTICS IO, TIME ON output. Extracts per-table IO metrics and per-statement…
git:20261006.2c73ad2 · audit B · 12 stars
sqltrace-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqltrace-review/SKILL.md · Analyze SQL Server trace files and Extended Events output to identify workload-level performance patterns. Applies 27…
git:20261015.4b8976e · audit B · 12 stars
sqlwait-review SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlwait-review/SKILL.md · Analyze SQL Server wait statistics to identify why the server or a session is slow. Applies 45 checks (V1–V45) covering…
git:20261016.b128771 · audit B · 12 stars
sqlworkload-compare SKILL.md skill
vanterx/mssql-performance-skills · skills/sqlworkload-compare/SKILL.md · Compare two SQL Server workload captures — a baseline and a current period, a fast day and a slow day, before and after…
git:20261015.4b8976e · audit B · 12 stars
ssrstracelog-review SKILL.md skill
vanterx/mssql-performance-skills · skills/ssrstracelog-review/SKILL.md · Analyze SQL Server Reporting Services (SSRS) report server trace logs, RSReportServer.config /…
git:20261006.2c73ad2 · audit B · 12 stars
tsql-review SKILL.md skill
vanterx/mssql-performance-skills · skills/tsql-review/SKILL.md · Analyze raw T-SQL source code for anti-patterns, security risks, and static performance smells. Applies 85 checks…
git:20261006.2c73ad2 · audit B · 12 stars