Does it provide guidance on index creation?

Absolutely. It covers when and how to implement single-column, composite, partial, and expression indexes based on your specific WHERE, JOIN, and ORDER BY requirements.

How does this skill help resolve N+1 query problems?

It provides standardized patterns using SQLAlchemy's eager loading options, such as joinedload for many-to-one relationships and selectinload for one-to-many relationships, ensuring data is fetched in the most efficient manner.

What database tools are included in the analysis patterns?

The skill focuses on EXPLAIN ANALYZE for query plan inspection and leverages system views like pg_stat_statements to identify the most expensive queries in your database.

Can I use this for real-time performance monitoring?

Yes, the skill includes a performance monitoring decorator that tracks execution time and logs warnings whenever a query exceeds a defined millisecond threshold.

Database Query Optimizer

Name: Database Query Optimizer
Author: ricardoroche

byricardoroche

0•

Gestión de Bases de Datos

Optimizes database performance by implementing EXPLAIN analysis, strategic indexing, and N+1 query prevention patterns.

This skill empowers Claude to act as a specialized database performance engineer, focusing on the identification and resolution of SQL bottlenecks. It provides standardized implementation patterns for running EXPLAIN ANALYZE, creating advanced indexes (composite, partial, and expression-based), and utilizing SQLAlchemy's eager loading features to eliminate N+1 query issues. By integrating performance monitoring decorators and batch loading techniques, it ensures that backend applications remain scalable and responsive even under heavy data loads.

Características Principales

01Automated EXPLAIN and EXPLAIN ANALYZE integration for query plan deep-dives

02Efficient batch loading and DataLoader implementations to reduce roundtrips

03Comprehensive indexing strategies including composite, partial, and expression indexes

04N+1 query resolution using SQLAlchemy joinedload and selectinload patterns

05Real-time query performance monitoring and slow query logging decorators

060 GitHub stars

Casos de Uso

01Implementing proactive query monitoring to identify slow database interactions in production environments

02Refactoring legacy ORM code to resolve critical performance bottlenecks and N+1 issues

03Architecting high-performance database schemas with optimized indexes for complex search queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ricardoroche/ricardos-claude-code query-optimization

For use in Claude.ai and ChatGPT

Download Skill