Skip to content
Development
MCP

microsoft-learn

Searches Microsoft Learn documentation for official Microsoft and Azure guidance.

BOOST
@vanterxvanterx@vanterx
From plugin
mssql-performance-skills
1329 skills8 agents1 MCP

Claude Code

> /plugin marketplace add vanterx/mssql-performance-skills
> /plugin install mssql-performance-skills@mssql-performance-skills

Security report

Found

Low risk

  • Known flaws

    Not published

  • Signed build

    Not published

  • Maintained

    Oct 29, 2026

    Last push

  • Licence

    MIT

  • Runs as

    Remote

    learn.microsoft.com

  • Deprecated

    Not published

Signals from public registries, not an audit. Checked Nov 15, 2026.

mssql-performance-skills README

ExcerptRead the full README on GitHub

mssql-performance-skills — SQL Server Performance Tuning Skills for LLMs

https://github.com/vanterx/mssql-performance-skills

Claude.ai (Remote MCP)

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.

Skills

SkillPurpose
mssql-performance-reviewAgentic 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-reviewAnalyze raw T-SQL source code — 85 checks (T1–T85) — structural, security, correctness, performance, SQL 2017–2022 modern syntax
sqlstats-reviewParse and analyze SET STATISTICS IO, TIME ON output — 27 checks (I1–I18 IO, W1–W9 time)
sqltrace-reviewAnalyze Profiler trace / Extended Events output — 27 checks (X1–X12 event-level, X13–X27 workload aggregate)
sqlwait-reviewAnalyze 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-reviewAnalyze a single .sqlplan file — 112 checks, prioritized report
sqlplan-compareDiff two plans to find what caused a regression
sqlindex-advisorDerive indexes from operator patterns + consolidate optimizer suggestions into a ranked CREATE INDEX script
sqldeadlock-reviewAnalyze a deadlock XML graph — identify pattern and fix
sqlblocking-reviewAnalyze 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-batchBatch-analyze a folder of plans — dashboard + index script
sqlquerystore-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-reviewAudit 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-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-compareCompare 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-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-reviewAnalyze 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-reviewAudit 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-reviewAudit security-object portability for a SQL Server migration — 15 checks (J1–J15): login portability, permission fidelity, credentials/proxies, certificates/keys, CMS registrations
sqlmigration-objects-reviewAudit 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

Quick Start

5 minutes to your first analysis:

  1. Install the skills (see Installation below)
  2. In SSMS, open skills/sqlplan-review/examples/horrible.sqlplan
  3. In Claude Code, type: 
    /sqlplan-review skills/sqlplan-review/examples/horrible.sqlplan
  4. Compare the output to skills/sqlplan-review/examples/horrible-analysis.md — that's the reference gold-standard output showing the expected Critical / Warning / Info findings and Passed Checks table.

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.

Installation

The skills are plain Markdown files. Copy them into your agent's skills directory — no build, no runtime, no dependencies.

Claude Code

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
Stats
TypeScriptJavaScriptNodeBashSQLAzureCloudflareLinuxGitGitHubAnthropicMCP
13
Stars
2
Forks
Active
Maintenance
TypeScript
Language
MIT
License
Last commit
Created

Repo: vanterx/mssql-performance-skills

In this plugin
29 skills8 agents1 MCP
See everything inside
@vanterx
Ships withmssql-performance-skills

SQL Server performance tuning skills for LLMs — 829 checks across 26 skills covering T-SQL, execution plans, wait stats, deadlocks, Query Store, indexes, encryption, Always On AG, WSFC, ERRORLOG, SPN, memory, disk I/O, config drift, setup logs, SSRS & migration readiness. Remote MCP server on Cloudflare Workers.

1329 skills8 agents1 MCP
Get the whole plugin

Stars on GitHub

Momentum

stars in total
13
Star history of vanterx/mssql-performance-skills on GitHub, a chart by star-history.com
See what's trending this week

More MCP servers from other plugins.

chrome-devtools
Auto-invoked

chrome-devtools

MCP

Connects to Chrome over the DevTools Protocol to inspect the DOM, network requests and console output.

ecc2w293k
@affaan-m@affaan-mInstall MCP
supabase

supabase

MCP

Queries a Supabase project: Postgres tables, auth users, storage and edge functions.

supabase2w114k
@supabase@supabaseInstall MCP

Questions about microsoft-learn.

Which coding agents can use microsoft-learn?
microsoft-learn works in any agent that reads an MCP config file: Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode and Windsurf. Each agent reads it from its own file; this page names the file for each one.
How do I add microsoft-learn to Claude Code?
Run these in order, one at a time. 1. In Claude Code: /plugin marketplace add vanterx/mssql-performance-skills 2. In Claude Code: /plugin install mssql-performance-skills@mssql-performance-skills
Is microsoft-learn safe to install?
Low risk. Signals from public registries, not an audit.