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.