supabase-postgres-best-practices

What problem does it solve? Writing Postgres schemas, queries, migrations, and RLS policies without established rules leads to slow queries, connection exhaustion, deadlocks, and data leaks. This Skill provides a prioritized rule set maintained by Supabase so every database change follows proven best practices. ## Core Features & Use Cases - Prioritized Rule Categories: Eight categories ranked by impact, from query performance and connection management (critical) to advanced features like full-text search and JSONB indexing. - Incorrect vs. Correct SQL Examples: Each rule file shows the anti-pattern first, then the optimized rewrite, with quantified impact such as 100x faster queries or 50% smaller indexes. - Security & RLS Guidance: Covers Row Level Security policies, SECURITY DEFINER functions, least-privilege roles, and performance-safe policy patterns. - Use Case: Before writing a migration that adds a column and index to a multi-tenant orders table, load this Skill to get the correct composite index strategy, idempotent constraint syntax, and RLS policy pattern. ## Quick Start Ask the AI to review your Postgres schema or query using the Supabase Postgres best practices before writing any SQL.