Does this skill support both PostgreSQL and MySQL?

Yes, it covers universal SQL optimization patterns as well as specific techniques for both PostgreSQL and MySQL, including dialect-specific EXPLAIN syntax and index types.

Can it help resolve high latency in API responses?

Absolutely. This skill specializes in identifying database-level bottlenecks like N+1 queries and inefficient JOINs that are the primary causes of slow API performance.

Is it useful for managing very large datasets?

Yes, it includes advanced strategies like table partitioning, BRIN indexes, and materialized views specifically designed for maintaining performance with large volumes of data.

How does it help with indexing strategy?

It provides guidance on selecting the right index type (B-Tree, GIN, Hash) and designing composite or covering indexes to ensure the database can satisfy queries without full table scans.

Can it suggest improvements for batch operations?

Yes, it provides patterns for optimized batch INSERTs and UPDATEs, including the use of temporary tables and the COPY command for bulk data handling.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: EricGrill

byEricGrill

•

Database Management

Optimizes database performance through systematic query analysis, advanced indexing strategies, and efficient SQL design patterns.

SQL Optimization Patterns is a comprehensive skill designed to transform slow database queries into high-performance operations by providing Claude with specialized knowledge in query tuning and schema design. It enables the systematic analysis of EXPLAIN plans, the implementation of sophisticated indexing strategies like partial and covering indexes, and the resolution of common performance bottlenecks such as N+1 query patterns. Whether you are debugging production latency, designing scalable schemas, or implementing batch operations, this skill provides the patterns necessary to reduce database load and improve application responsiveness across various SQL dialects.

Key Features

012 GitHub stars

02Advanced optimization via materialized views and table partitioning

03Detection and elimination of N+1 query anti-patterns

04Advanced indexing strategies including Composite, GIN, and Partial indexes

05Query execution plan (EXPLAIN) analysis and interpretation

06Efficient cursor-based pagination and batch processing techniques

Use Cases

01Debugging and fixing slow-running legacy queries in production environments

02Reducing database infrastructure costs by optimizing resource-heavy queries

03Designing high-performance database schemas for data-intensive applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ericgrill/agents-skills-plugins sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill