Can it help with PostgreSQL-specific features?

Yes, it includes advanced PostgreSQL patterns like GIN/GiST indexes, Materialized Views, and table partitioning strategies.

Does this skill support cursor-based pagination?

Yes, it provides optimized patterns to replace slow OFFSET/LIMIT pagination with high-performance cursor-based navigation for large datasets.

How does this skill help with slow database queries?

It provides a systematic framework for analyzing execution plans (EXPLAIN) and suggests specific indexing or query refactoring patterns to reduce execution costs.

How does it handle N+1 query issues?

It identifies common ORM pitfalls and provides optimized SQL solutions using JOINs, window functions, or batch loading to minimize database roundtrips.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: EngineerWithAI

byEngineerWithAI

データベース管理

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL implementation patterns.

概要

This skill empowers Claude to transform sluggish database operations into high-performance queries by applying systematic optimization techniques across various database engines. It provides comprehensive guidance on interpreting EXPLAIN plans, implementing sophisticated index types like GIN and BRIN, eliminating N+1 query issues, and optimizing complex joins or subqueries. Whether you are debugging production bottlenecks or architecting a scalable schema for growing datasets, this skill ensures your database layer remains responsive, scalable, and cost-effective.

主な機能

Expert interpretation of EXPLAIN and EXPLAIN ANALYZE execution plans
0 GitHub stars
High-performance pagination techniques using cursor-based navigation
Advanced indexing strategies including partial, expression, and covering indexes
N+1 query pattern detection and remediation via batch loading or JOINs
Optimization patterns for subqueries, CTEs, and batch write operations

ユースケース

Debugging and fixing slow-running production database queries and bottlenecks
Refactoring legacy application code to eliminate inefficient ORM-generated queries
Designing high-performance database schemas and indexing strategies for new projects

概要

主な機能

Expert interpretation of EXPLAIN and EXPLAIN ANALYZE execution plans
0 GitHub stars
High-performance pagination techniques using cursor-based navigation
Advanced indexing strategies including partial, expression, and covering indexes
N+1 query pattern detection and remediation via batch loading or JOINs
Optimization patterns for subqueries, CTEs, and batch write operations

ユースケース

Debugging and fixing slow-running production database queries and bottlenecks
Refactoring legacy application code to eliminate inefficient ORM-generated queries
Designing high-performance database schemas and indexing strategies for new projects