Optimizes database performance through indexing strategies, EXPLAIN plan analysis, and query refactoring.
This skill empowers Claude to transform slow database queries into high-performance operations by applying systematic optimization patterns and deep database analysis. It provides expert guidance on interpreting EXPLAIN execution plans, implementing sophisticated index types like B-Tree, GIN, and Composite indexes, and resolving common performance bottlenecks such as N+1 queries and inefficient OFFSET pagination. Whether you are architecting a new schema or debugging a bottlenecked production database, this skill provides the implementation patterns needed to reduce database load, lower costs, and ensure application scalability.
Key Features
01Advanced indexing strategies including Partial, Expression, and Covering indexes
02Optimization of complex aggregates, subqueries, and window functions
034 GitHub stars
04High-performance pagination techniques using cursor-based navigation
05Proven patterns to eliminate N+1 query anti-patterns using batching and JOINs
06Deep EXPLAIN and EXPLAIN ANALYZE plan interpretation for PostgreSQL and MySQL
Use Cases
01Designing performant database schemas for data-intensive applications
02Refactoring legacy SQL or ORM-generated queries for better resource efficiency
03Troubleshooting and fixing slow-running production database queries
