vanterx/mssql-performance-skills
Plugin Claude Code
SQL Server performance tuning skills for Claude Code — 836 checks across 26 skills covering T-SQL static analysis, execution plan review, wait statistics, deadlock diagnosis, Query Store, Always On AG health, AG configuration correctness, ERRORLOG, Kerberos/SPN, memory, disk I/O, encryption, configuration drift, SSRS…
vanterx/mssql-performance-skills
Plugin Claude Code
26 SQL Server performance tuning skills for Claude Code — static T-SQL analysis, execution plans, wait stats, deadlock, query store, AG health, AG configuration, ERRORLOG, SPN, memory, disk I/O, encryption, configuration drift, setup bootstrap log, SSRS trace log review, and migration readiness.
vanterx/mssql-performance-skills
Hook Claude Code
Runs before the agent uses a tool for Bash tool calls, executing pre-tool-security.js and ensure-gitignore.js via node (2 commands). From vanterx/mssql-performance-skills.
vanterx/mssql-performance-skills
Hook Claude Code
Runs after a tool call finishes for Write and Edit tool calls, executing scoped-verify-docs.js via node. From vanterx/mssql-performance-skills.
vanterx/mssql-performance-skills
Hook Claude Code
Runs when the agent finishes a response, executing stop-secret-scan.js via node. From vanterx/mssql-performance-skills.
vanterx/mssql-performance-skills
Settings file Claude Code
Agent settings declaring 3 hook events (PreToolUse, PostToolUse, Stop) and 30 allowed tools.
vanterx/mssql-performance-skills
MCP server Claude CodeCodexCursor +2
MCP server "microsoft-learn", hosted remotely at learn.microsoft.com, as configured in vanterx/mssql-performance-skills.
vanterx/mssql-performance-skills
Instructions file CodexOpenCode
Instructions for vanterx/mssql-performance-skills, covering agents.md — mssql-performance-skills, what this is, verify before commit, critical gotchas and full contributor guide.
vanterx/mssql-performance-skills
Instructions file
Instructions for vanterx/mssql-performance-skills, covering mssql-performance-skills, purpose, tech stack, key files and skills (skill.md — loaded at runtime).
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Agentic offline orchestrator for end-to-end SQL Server performance reviews. Forms hypotheses from artifacts or symptoms, dispatches the specialised review skills (tsql-review, sqlplan-review, sqlwait-review, sqlstats-review, sqltrace-review, sqlquerystore-review, sqlprocstats-review, sqldeadlock-review…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Audits SQL Server Always On Availability Group configuration correctness across all layers — prerequisites, replica design, listener architecture, backup strategy, endpoint security, distributed AG topology, Basic and Contained AG constraints, and application integration readiness. Use this skill when setting up a new…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server Setup Bootstrap log files to diagnose failed installations, failed Cumulative Update or Service Pack patching, failed cluster node operations, and risky setup-time configuration. Parses Summary.txt, Detail.txt, MSI/MSP logs, ConfigurationFile.ini, and SystemConfigurationCheckReport content from the…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyzes Windows Server Failover Cluster (WSFC) CLUSTER.LOG files for Always On Availability Group root-cause diagnosis. Use this skill when an availability group has gone offline, a failover occurred unexpectedly, or a node was evicted, and you need to identify the WSFC-level cause that SQL Server DMVs cannot see.…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server instance and database configuration drift against proven DBA best practices. Applies 29 checks (B1–B29) across five categories: parallelism tuning (MAXDOP, Cost Threshold for Parallelism, Optimize for Ad Hoc Workloads), memory configuration (Max Server Memory, Lock Pages in Memory), database-level…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server deadlock XML (from systemhealth XE session, SSMS deadlock graph, or trace) to identify root cause and produce a prioritized remediation plan. Applies 17 known deadlock patterns (P1–P17). Use when a deadlock monitor captures a graph or users report intermittent deadlock errors (error 1205).
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server file-level I/O latency and auto-growth events using sys.dmiovirtualfilestats, sys.masterfiles, and default trace auto-growth records. Applies 15 checks (Z1–Z15) covering data and log file latency thresholds, hot file detection, stall ratio analysis, data and log placement on the same volume, TempDB…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server encryption posture across all layers — TDE, Always Encrypted, cell-level encryption, backup encryption, transport/TLS, certificate lifecycle, asymmetric and symmetric key management, DMK/SMK key hierarchy including spcontroldbmasterkeypassword and SSISDB, EKM/AKV, sensitivity-classification gaps…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyzes SQL Server ERRORLOG files for operational issues, availability group failures, memory pressure, I/O subsystem warnings, and security events. Use this skill whenever a SQL Server instance has experienced unexpected behavior, an AG failover, memory warnings, I/O latency alerts, or abnormal shutdown, and you…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyzes sys.dmhadr DMV output to assess Always On Availability Group replica health, synchronization state, secondary lag, redo and log send queue sizes, and configuration gaps. Use this skill when an availability group is behaving unexpectedly, a secondary replica is lagging, data loss is a concern, a database…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server execution plans to produce a ranked CREATE INDEX script. Applies 13 checks (D1–D13). Derives index recommendations from operator patterns (Key Lookups, scans, sorts, spools, nested loops, filtered index opportunities, hash match probe-side scans — D1–D10) and the optimizer's explicit…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Analyze SQL Server memory pressure using buffer pool metrics, plan cache composition, memory grants, and memory clerk data. Applies 20 checks (O1–O20) covering Page Life Expectancy degradation, single-use plan cache bloat, RESOURCESEMAPHORE queue depth, memory grant timeouts, buffer pool concentration, ColumnStore and…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Audits the operational-object migration plan for a SQL Server move with 16 checks (M1-M16) — SQL Agent jobs/operators/alerts/proxies, linked servers, Database Mail, backup devices, custom error messages, server-level triggers, Extended Events sessions, and endpoints. Use this skill when a user is migrating a SQL…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Audits a SQL Server migration plan with 15 checks (Y1-Y15) for version, edition, platform, and source-topology compatibility, then dispatches to sqlmigration-security-review, sqlmigration-objects-review, and other specialised skills for overlap areas. Use this skill when a user is planning, mid-flight on, or…
vanterx/mssql-performance-skills
Skill Claude CodeCodex
Audits the security-object migration plan for a SQL Server move with 15 checks (J1-J15) — logins, server and database permissions, credentials, certificates/keys ownership, and Central Management Server registrations. Use this skill when a user is migrating a SQL Server database or instance and needs to carry over…