Supabase Postgres Best Practices

syahiidkamil/software-engineer-ai-agent-atlas

This is Supabase's internal Postgres optimization guide packaged as a skill. It covers eight categories of performance rules, from critical items like missing indexes and connection pooling to advanced features, each with before/after SQL examples and query plan analysis. Use it when writing queries, designing schemas, or debugging performance issues. The rules are well-prioritized by impact, which is helpful when you're trying to figure out what actually matters versus what's just nice to have. Heavy emphasis on RLS patterns and Supabase-specific gotchas, so it's most valuable if you're in that ecosystem, though the core Postgres advice applies anywhere.

GitHub stars: 298
last updated: Jun 11, 2026

View on GitHub

Install

$ npx -y skills add syahiidkamil/software-engineer-ai-agent-atlas --skill supabase-postgres-best-practices --agent claude-code

Installs into .claude/skills of the current project.

Files

Supabase Postgres Best Practices

Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.

When to Apply

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-`