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

•

Database Management

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.

Key Features

01Query refactoring for optimized JOIN execution and logical flow

02Implementation patterns for materialized views and Redis caching

03Automated detection and remediation of N+1 query patterns

042 GitHub stars

05Expert interpretation of SQL EXPLAIN and ANALYZE plans

06Strategic indexing recommendations including covering and functional indexes

Use Cases

01Optimizing application code to reduce database load and connection overhead

02Identifying and fixing slow-running queries in production environments

03Designing high-performance indexing strategies for large-scale datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cyperx84/claude-code-plugin-examples query-optimization

For use in Claude.ai and ChatGPT

Download Skill