Postgres Best Practices

This is Supabase's internal Postgres performance guide packaged as a skill. It covers eight categories of optimization rules, from query performance and connection pooling to Row-Level Security and schema design. Each rule includes incorrect and correct SQL examples with explanations. The structure is solid: rules are prioritized by impact (critical, high, medium), prefixed for easy reference, and compiled into a full AGENTS.md document. Use it when you're writing queries, reviewing schemas, or debugging slow database operations. It's opinionated in the good way, the kind of reference that saves you from rediscovering why your N+1 query is killing production or why connection pooling matters at scale.

skills.sh installs: 361
GitHub stars: 39.4K
last updated: Jun 3, 2026

View on GitHub

Install

$ npx -y skills add sickn33/antigravity-awesome-skills --skill postgres-best-practices --agent claude-code

Installs into .claude/skills of the current project.

Files

Supabase Postgres Best Practices

Community-bundled Postgres guide attributed to Supabase; upstream maintenance and example performance numbers are not independently certified. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.

When to Use

Reference these guidelines when:

Writing SQL queries or designing schemas
Implementing indexes or query optimization
Reviewing database performance issues
Configuring connection pooling or scaling
Optimizing for Postgres-specific features
Working with Row-Level Security (RLS)

Rule Categories by Priority

Priority	Category	Impact	Prefix
1	Query Performance	CRITICAL	`query-`
2	Connection Management	CRITICAL	`conn-`
3	Security & RLS	CRITICAL	`security-`
4	Schema Design	HIGH	`schema-`
5	Concurrency & Locking	MEDIUM-HIGH	`lock-`
6	Data Access Patterns	MEDIUM	`data-`
7	Monitoring & Diagnostics	LOW-MEDIUM	`monitor-`
8	Advanced Features	LOW	`advanced-`