postgres-patterns

PostgreSQL best practices for indexing, schema design, query optimization, and security. Quick reference for PostgreSQL best practices. For detailed guidance, use the database-reviewer agent. Composite Index Order: Covering Index: Partial Index: RLS Policy (Optimized): UPSERT: Cursor Pagination: Queue Processing: Based on Supabase Agent Skills (credit: Supabase team) (MIT License) - Covers six index types with specific use cases: B-tree for equality/range queries, composite for multi-column filters, GIN for JSONB and full-text search, and BRIN for time-series data - Includes data type guidance (bigint for IDs, text over varchar, timestamptz for timestamps, numeric for money) and anti-pattern detection queries for unindexed foreign keys and slow queries - Provides ready-to-use SQL patterns for covering indexes, partial indexes, cursor pagination, UPSERT, queue processing, and Row Level Security policies - Configuration template covers connection limits, timeouts, monitoring setup, and security defaults - Writing SQL queries or migrations - Designing database schemas - Troubleshooting slow queries - Implementing Row Level Security - Setting up connection pooling - Agent: database-reviewer - Full database review workflow - Skill: clickhouse-io - ClickHouse analytics patterns - Skill: backend-patterns - API and backend patterns