Postgres Patterns

Solid reference for the PostgreSQL patterns you'll actually need when building production apps. Covers the index cheat sheet everyone wishes they had bookmarked (composite vs GIN vs BRIN), common gotchas like RLS policy wrapping and cursor pagination over OFFSET, and those diagnostic queries for finding unindexed foreign keys or table bloat. The data type guide alone saves you from the classic varchar(255) and float-for-money mistakes. It's based on Supabase's internal patterns, so the recommendations come from teams running Postgres at scale. Activate this when writing migrations or debugging slow queries, then escalate to the database-reviewer agent if you need deeper analysis.

Install to Claude Code

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