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

0•

数据库管理

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.

主要功能

01Expert interpretation of EXPLAIN and EXPLAIN ANALYZE execution plans

020 GitHub stars

03High-performance pagination techniques using cursor-based navigation

04Advanced indexing strategies including partial, expression, and covering indexes

05N+1 query pattern detection and remediation via batch loading or JOINs

06Optimization patterns for subqueries, CTEs, and batch write operations

使用场景

01Debugging and fixing slow-running production database queries and bottlenecks

02Refactoring legacy application code to eliminate inefficient ORM-generated queries

03Designing high-performance database schemas and indexing strategies for new projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add engineerwithai/engineerwith-agents sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill