Postgres Patterns

A quick reference guide for PostgreSQL best practices pulled from Supabase's patterns. You get index selection rules (B-tree vs GIN vs BRIN), proper data type choices (bigint for IDs, timestamptz over timestamp), and common patterns like cursor pagination and queue processing with SKIP LOCKED. The real value is in the specific examples: composite index column ordering, covering indexes to avoid table lookups, and that RLS policy trick where you wrap auth.uid() in a SELECT. Also includes queries to find unindexed foreign keys and detect table bloat. It's meant as a cheat sheet when writing migrations or troubleshooting slow queries, not a tutorial. For deeper analysis, they point you to a database-reviewer agent.

Install to Claude Code

npx -y skills add affaan-m/ecc --skill postgres-patterns --agent claude-code