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

データベース管理

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.

主な機能

Automated EXPLAIN and EXPLAIN ANALYZE integration for query plan deep-dives
Efficient batch loading and DataLoader implementations to reduce roundtrips
Comprehensive indexing strategies including composite, partial, and expression indexes
N+1 query resolution using SQLAlchemy joinedload and selectinload patterns
Real-time query performance monitoring and slow query logging decorators
0 GitHub stars

ユースケース

Implementing proactive query monitoring to identify slow database interactions in production environments
Refactoring legacy ORM code to resolve critical performance bottlenecks and N+1 issues
Architecting high-performance database schemas with optimized indexes for complex search queries

概要

主な機能

Automated EXPLAIN and EXPLAIN ANALYZE integration for query plan deep-dives
Efficient batch loading and DataLoader implementations to reduce roundtrips
Comprehensive indexing strategies including composite, partial, and expression indexes
N+1 query resolution using SQLAlchemy joinedload and selectinload patterns
Real-time query performance monitoring and slow query logging decorators
0 GitHub stars

ユースケース

Implementing proactive query monitoring to identify slow database interactions in production environments
Refactoring legacy ORM code to resolve critical performance bottlenecks and N+1 issues
Architecting high-performance database schemas with optimized indexes for complex search queries