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.

skills.sh installs: 7.1K
GitHub stars: 229.1K
last updated: Jul 14, 2026

View on GitHub

Install

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

Installs into .claude/skills of the current project.

Files

PostgreSQL Patterns

Quick reference for PostgreSQL best practices. For detailed guidance, use the database-reviewer agent.

When to Activate

Writing SQL queries or migrations
Designing database schemas
Troubleshooting slow queries
Implementing Row Level Security
Setting up connection pooling

Quick Reference

Index Cheat Sheet

Query Pattern	Index Type	Example
`WHERE col = value`	B-tree (default)	`CREATE INDEX idx ON t (col)`
`WHERE col > value`	B-tree	`CREATE INDEX idx ON t (col)`
`WHERE a = x AND b > y`	Composite	`CREATE INDEX idx ON t (a, b)`
`WHERE jsonb @> '{}'`	GIN	`CREATE INDEX idx ON t USING gin (col)`
`WHERE tsv @@ query`	GIN	`CREATE INDEX idx ON t USING gin (col)`
Time-series ranges	BRIN	`CREATE INDEX idx ON t USING brin (col)`