Can it help me choose the right type of index?

Yes, it provides a decision framework for using B-Tree, composite, partial, and covering indexes based on column cardinality and query patterns.

Does this skill support both PostgreSQL and MySQL?

Yes, it provides specific guidance for PostgreSQL-specific features like EXPLAIN ANALYZE and general SQL optimization techniques applicable to MySQL and other relational databases.

How does it help with the N+1 query problem?

It identifies common ORM patterns that cause excessive queries and provides code-level solutions like eager loading using select_related or prefetch_related.

Does it provide advice on database architecture?

Beyond query tuning, it includes best practices for connection pooling, materialized views, and application-level caching strategies to improve overall system throughput.

Query Optimization & Database Performance

Name: Query Optimization & Database Performance
Author: cyperx84

bycyperx84

•

データベース管理

Optimizes SQL database performance through advanced indexing strategies, execution plan analysis, and query refactoring.

概要

This skill transforms Claude into a database performance expert capable of diagnosing bottlenecks and optimizing relational database operations. It provides comprehensive guidance on interpreting EXPLAIN plans, implementing advanced indexing techniques like composite and partial indexes, and resolving the common N+1 query problem found in modern ORMs. Whether you are debugging slow production queries or architecting a new data model, this skill offers production-ready patterns for caching, connection pooling, and SQL refactoring to ensure your application remains scalable and efficient.

主な機能

Query refactoring for optimized JOIN execution and logical flow
Implementation patterns for materialized views and Redis caching
Automated detection and remediation of N+1 query patterns
2 GitHub stars
Expert interpretation of SQL EXPLAIN and ANALYZE plans
Strategic indexing recommendations including covering and functional indexes

ユースケース

Optimizing application code to reduce database load and connection overhead
Identifying and fixing slow-running queries in production environments
Designing high-performance indexing strategies for large-scale datasets

概要

主な機能

Query refactoring for optimized JOIN execution and logical flow
Implementation patterns for materialized views and Redis caching
Automated detection and remediation of N+1 query patterns
2 GitHub stars
Expert interpretation of SQL EXPLAIN and ANALYZE plans
Strategic indexing recommendations including covering and functional indexes

ユースケース

Optimizing application code to reduce database load and connection overhead
Identifying and fixing slow-running queries in production environments
Designing high-performance indexing strategies for large-scale datasets