29 agent markdown files indexed from vanterx/mssql-performance-skills. Install any of them pinned to an exact hash with mdr add vanterx/mssql-performance-skills/<name>.
AGENTS.md agents
vanterx/mssql-performance-skills · AGENTS.md
git:20260709.012214c · audit A · 5 stars
CLAUDE.md claude
vanterx/mssql-performance-skills · CLAUDE.md
git:20260919.8a7bf7e · audit A · 5 stars
mssql-performance-review 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:20260919.8a7bf7e · audit A · 5 stars
sqlag-review 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:20260622.55f8c85 · audit A · 5 stars
sqlblocking-review 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:20260919.8a7bf7e · audit A · 5 stars
sqlbootstraplog-review 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:20260611.bd7f3cf · audit A · 5 stars
sqlclusterlog-review 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:20260622.55f8c85 · audit A · 5 stars
sqldbconfig-review skill
vanterx/mssql-performance-skills · skills/sqldbconfig-review/SKILL.md · Analyze SQL Server instance and database configuration drift against proven DBA best practices. Applies 29 checks…
git:20260919.8a7bf7e · audit A · 5 stars
sqldeadlock-review 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:20260919.8a7bf7e · audit A · 5 stars
sqldiskio-review 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:20260622.55f8c85 · audit A · 5 stars
sqlencryption-review 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:20260622.55f8c85 · audit A · 5 stars
sqlerrorlog-review 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:20260622.55f8c85 · audit A · 5 stars
sqlhadr-review 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:20260622.55f8c85 · audit A · 5 stars
sqlindex-advisor 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:20260728.82e1136 · audit A · 5 stars
sqlmemory-review 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:20260622.55f8c85 · audit A · 5 stars
sqlmigration-objects-review 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:20260622.55f8c85 · audit A · 5 stars
sqlmigration-review 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:20260701.321a668 · audit A · 5 stars
sqlmigration-security-review 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:20260622.55f8c85 · audit A · 5 stars
sqlplan-batch 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:20260607.6ff4f7a · audit A · 5 stars
sqlplan-compare 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:20260607.6ff4f7a · audit A · 5 stars
sqlplan-review 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:20260919.8a7bf7e · audit A · 5 stars
sqlprocstats-review 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:20260618.73ca134 · audit A · 5 stars
sqlquerystore-review 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:20260622.55f8c85 · audit A · 5 stars
sqlspn-review 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:20260907.492bd70 · audit A · 5 stars
sqlstats-review 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:20260618.c07d217 · audit A · 5 stars
sqltrace-review 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 25…
git:20260618.5cdc14a · audit A · 5 stars
sqlwait-review 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 44 checks (V1–V44) covering…
git:20260919.8a7bf7e · audit A · 5 stars
ssrstracelog-review skill
vanterx/mssql-performance-skills · skills/ssrstracelog-review/SKILL.md · Analyze SQL Server Reporting Services (SSRS) report server trace logs, RSReportServer.config /…
git:20260615.fa3d3ad · audit A · 5 stars
tsql-review 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:20260623.4a7462d · audit A · 5 stars