database-optimizer
CommunityTune DB queries for peak performance.
Data & Analytics#monitoring#PostgreSQL#MySQL#execution plan#database optimization#index optimization#slow query
AuthorJeffallan
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps diagnose slow queries and optimize database performance across PostgreSQL and MySQL.
Core Features & Use Cases
- Query Analysis: Execution plans, slow queries, and index strategy.
- Index Strategies: Covering/index optimization and partial indexes.
- Tuning & Monitoring: PostgreSQL/MySQL tuning and monitoring patterns.
- Validation: Before/after performance checks.
Quick Start
Analyze a slow query, generate an EXPLAIN ANALYZE plan, and propose an index improvement.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: database-optimizer Download link: https://github.com/Jeffallan/claude-skills/archive/main.zip#database-optimizer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.