Does it provide guidance on pagination for large datasets?

Yes, the skill details why offset pagination is slow for large datasets and provides implementation patterns for faster cursor and keyset pagination.

What types of indexing strategies are covered?

It covers standard B-Tree indexes, composite indexes (multi-column), partial indexes for filtered data, and covering indexes to avoid table lookups.

How do I handle expensive data aggregations?

The skill suggests using Materialized Views for pre-computing expensive calculations and implementing Redis-based caching strategies for frequently accessed data.

Can this skill help with Prisma or other ORM performance?

Yes, it includes specific patterns for avoiding N+1 queries through eager loading and batching, as well as efficient field selection and bulk operations.

How does this skill help identify slow database queries?

The skill provides patterns for using EXPLAIN ANALYZE to read query plans, helping you identify whether the database is performing inefficient sequential scans or optimal index scans.

Database Query Optimization

Name: Database Query Optimization
Author: bradtaylorsf

bybradtaylorsf

•

Database Management

Optimizes database performance through efficient query patterns, advanced indexing strategies, and comprehensive performance analysis.

This skill equips Claude with specialized knowledge to diagnose and resolve database performance bottlenecks. It provides standardized patterns for interpreting execution plans via EXPLAIN ANALYZE, implementing sophisticated indexing strategies like partial and covering indexes, and refactoring inefficient ORM code to eliminate N+1 query issues. By applying these patterns, developers can ensure their applications handle large datasets efficiently through optimized pagination, bulk operations, and caching strategies, ultimately reducing latency and infrastructure costs.

Key Features

01High-performance pagination strategies using cursor and keyset-based methods

026 GitHub stars

03Query plan analysis and performance bottleneck identification using EXPLAIN ANALYZE

04Implementation of caching layers and materialized views for expensive aggregations

05Advanced indexing patterns including composite, partial, and covering indexes

06ORM optimization techniques for Prisma and SQL to prevent N+1 query patterns

Use Cases

01Refactoring slow-running legacy SQL queries to reduce execution time and resource usage

02Optimizing backend API performance by batching database operations and implementing Redis caching

03Designing optimal indexing schemas for new database tables based on expected access patterns

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team query-optimization

For use in Claude.ai and ChatGPT

Download Skill