skills.rest
chrishuffman5
chrishuffman5COMMUNITY
Explore all skills by this author →
GitHub

sqlserver-advisor

Capture SQL Server DMV data into DuckDB and generate prioritized recommendations.

Updated May 27, 2026
Search Tags:#performance optimization#recommendations#sql server#database analysis#offline analysis
One-click install
npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-advisor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-advisor
Source: https://github.com/chrishuffman5/sqlserver/tree/main/skills/sqlserver-advisor
Command: npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-advisor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill performs an automated offline analysis of SQL Server databases, identifying areas for improvement and performance bottlenecks.

Core Features & Use Cases

  • Offline Analysis: Captures read-only system-view/DMV/catalog data from a target instance once, and analyzes it using DuckDB for prioritized recommendations.
  • Performance Optimization: Provides recommendations across table/schema design, indexing, sizing & capacity, statistics, query hotspots, and configuration.
  • Use Case: Use this Skill to analyze a database and receive a prioritized report with recommendations on how to improve its performance and efficiency.

Quick Start

Use the sqlserver-advisor skill to analyze the database 'mydatabase'.

Frequently Asked Questions about sqlserver-advisor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform offline analysis on a SQL Server database to identify performance bottlenecks?▼

Perform offline analysis by capturing read-only system-view, DMV, and catalog data from a SQL Server instance, then loading it into DuckDB to run queries that generate prioritized performance optimization recommendations.

What kind of recommendations can I get from analyzing SQL Server DMV data?▼

Analyzing SQL Server DMV data provides prioritized recommendations covering table/schema design, indexing, sizing and capacity, statistics, query hotspots, and configuration improvements to optimize database performance.

Do I need DuckDB to analyze captured SQL Server system-view data?▼

Yes, you need DuckDB to analyze the captured SQL Server system-view data, as it serves as the offline analytical engine to process the snapshot and identify performance bottlenecks for the final report.

Can I analyze a live SQL Server instance without impacting database performance?▼

Yes, this approach captures read-only system-view and DMV data from the target instance once, allowing all subsequent bottleneck analysis and optimization recommendation generation to run offline in DuckDB.

What is the best way to automate SQL Server performance optimization and capacity sizing reports?▼

Automate SQL Server performance optimization by capturing catalog and DMV data into DuckDB, which runs analysis queries offline to automatically generate a prioritized report covering sizing, indexing, and query hotspots.

Does this offline database analysis approach work for identifying missing indexes and query hotspots?▼

Yes, offline database analysis works for identifying missing indexes and query hotspots by running targeted analysis queries in DuckDB against captured SQL Server catalog and DMV data to prioritize improvements.

Related Skills

Explore More Software Engineering Skills→
InsightpulseaiInsightpulseai
5

supabase-schema-catalog

Generate an offline JSON catalog of a Supabase Postgres schema.

Official
Intermediate
JosiahSiegelJosiahSiegel
51

index-strategies

Guide SQL Server index design, optimization, and maintenance strategies.

Community
Intermediate
OpsinTechOpsinTech
91

data-analysis

Analyze Excel and CSV files with SQL queries and statistical summaries.

Official
Intermediate
TurnaboutHeroTurnaboutHero
12

sql-master

Diagnose SQL queries and recommend indexes for performance optimization.

Community
Advanced