Optimizes database performance and security using proven PostgreSQL patterns and Supabase best practices.
PostgreSQL Patterns is a specialized skill for Claude Code that provides high-performance database architectural guidance. It offers a comprehensive library of indexing strategies, data type recommendations, and advanced SQL patterns for common tasks like UPSERTs and cursor pagination. By integrating production-grade patterns for Row Level Security (RLS) and anti-pattern detection, this skill helps developers build scalable, secure, and efficient database layers while avoiding common pitfalls like table bloat or unindexed foreign keys.
주요 기능
01Automated anti-pattern detection for slow queries and unindexed keys
02Security-first configuration templates and Row Level Security (RLS) optimization
03Comprehensive indexing cheat sheet for B-tree, GIN, BRIN, and Composite types
041 GitHub stars
05Optimized data type selection for performance and storage efficiency
06Advanced SQL implementation patterns for job queues and cursor pagination
사용 사례
01Designing scalable database schemas for new applications
02Optimizing slow SQL queries and improving database response times
03Implementing secure multi-tenant data access using RLS policies
