What database systems does this skill support?

While many examples focus on PostgreSQL, the core optimization concepts and patterns are applicable to MySQL, MariaDB, and other major SQL relational databases.

Does it cover more than just basic indexes?

Absolutely. It includes advanced indexing strategies like partial, expression, GIN for JSONB/full-text search, and BRIN for large datasets.

Can it help me understand why my query is slow?

Yes, it provides a comprehensive guide to interpreting EXPLAIN and EXPLAIN ANALYZE outputs to identify bottlenecks like sequential scans or high-cost joins.

Is this skill useful for database schema design?

Yes, it includes best practices for data types, normalization, and partitioning to ensure performance from the start of a project.

How does this help with N+1 query problems?

The skill provides specific SQL join and batch-loading patterns to replace repetitive individual queries with efficient single-trip operations.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: sla-te

bysla-te

0•

Database Management

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

This skill provides specialized knowledge to identify and resolve database bottlenecks, transforming slow queries into high-performance operations. It covers systematic analysis of EXPLAIN plans, sophisticated indexing strategies (B-Tree, GIN, BRIN), and the elimination of common anti-patterns like N+1 queries. Whether you're designing schemas for scale or debugging existing performance issues, this skill offers production-ready patterns for PostgreSQL, MySQL, and general SQL environments to reduce latency and infrastructure costs.

Key Features

01Implementation of advanced indexing strategies including composite, partial, and covering indexes

02Detailed analysis and interpretation of SQL EXPLAIN query plans

030 GitHub stars

04Best practices for batch operations and efficient data aggregation

05Solutions for common performance anti-patterns like N+1 queries and slow OFFSET pagination

06Guidance on advanced database features like Materialized Views and Table Partitioning

Use Cases

01Designing high-performance database schemas for new applications

02Reducing database CPU and memory usage to lower cloud infrastructure costs

03Debugging and fixing slow-running production database queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sla-te/copilot-converter sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill