Database Performance Patterns

소개

This skill provides a comprehensive set of patterns and guidelines designed to enhance database efficiency and stability. It focuses on identifying and fixing common anti-patterns like N+1 queries and sequential independent requests, while offering practical templates for batch operations and indexing strategies. Ideal for developers working with Supabase or PostgreSQL, it ensures applications scale effectively by managing connection limits and reducing latency through parallelized queries and memory-based aggregation.

주요 기능

• 1 GitHub stars
• Automated indexing strategies for foreign keys and frequent filters
• Detection and correction of N+1 query anti-patterns
• Implementation of batch insert and update operations
• Connection pool monitoring and configuration for Supabase environments
• Optimization of sequential independent queries using Promise.all

사용 사례

• Implementing efficient data fetching for complex entities with multiple relationships
• Optimizing slow-running cron jobs or high-volume batch processing services
• Reviewing backend code to prevent database connection pool exhaustion