sql-server-skills

name

sql-server-skills

description

Comprehensive SQL Server performance diagnostics, index analysis, execution plan interpretation, query optimization, schema management, backup/restore, and monitoring using sqlcmd and T-SQL DMVs. Use when analyzing slow queries, investigating wait stats, finding missing indexes, reading execution plans, optimizing stored procedures or views, managing migrations, monitoring SQL Agent jobs, or diagnosing blocking/deadlocks on Microsoft SQL Server. Triggers on: SQL Server, MSSQL, sqlcmd, T-SQL performance, slow query, execution plan, DMV, missing index, wait stats, blocking, deadlock, stored procedure optimization, view tuning.

SQL Server Skills

Comprehensive SQL Server skill for AI agents. Covers performance diagnostics, index analysis, execution plan interpretation, query optimization, schema management, backup/restore, and monitoring — all via sqlcmd and T-SQL DMVs.

---

Requirements

• sqlcmd — Microsoft Download
• SQL Server 2016+ — All DMV queries target compatibility level 130+
• Permissions — VIEW SERVER STATE for most DMV queries; sysadmin or db_owner for some operations

---

Quick Connect

# Windows Authentication (domain-joined machine)
sqlcmd -S "$SQL_SERVER" -E

# SQL Authentication
sqlcmd -S "$SQL_SERVER" -U "$SQL_USER" -P "$SQL_PASSWORD" -d 


sqlcmd -S  -U  -P  -d 


sqlcmd -S  -U  -P  -d master -i scripts/top-slow-queries.sql


sqlcmd -S  -U  -P  -d master -i scripts/wait-stats.sql -o results.txt -s  -W