sqlserver-advisor
CommunityAutomate offline analysis and performance optimization of SQL Server databases
Software Engineering#performance optimization#recommendations#sql server#database analysis#offline analysis
Authorchrishuffman5
Version1.0.0
Installs0
System Documentation
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'.
Dependency Matrix
Required Modules
duckdb
Components
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sqlserver-advisor Download link: https://github.com/chrishuffman5/sqlserver/archive/main.zip#sqlserver-advisor Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.