SQL Query Optimizer

About

This specialized skill enables Claude to handle complex database performance tuning across PostgreSQL, MySQL, and MongoDB. It guides users through a systematic optimization lifecycle—from identifying bottlenecks and analyzing baseline metrics to implementing structural changes and configuring real-time monitoring. By automating best practices in query design and infrastructure scaling, it ensures high-performance data operations while minimizing risks through robust validation and rollback procedures.

Key Features

• Structured deployment workflow with staging validation
• Automated query plan analysis and bottleneck identification
• Monitoring and observability dashboard configuration
• Cross-platform support for PostgreSQL, MySQL, and MongoDB
• Runbook and operational documentation generation
• 0 GitHub stars

Use Cases

• Establishing performance baselines and real-time alerts
• Optimizing slow legacy queries to reduce application latency
• Automating database indexing and schema refactoring