What problem does it solve? Writing or changing anything in a Postgres database without established rules leads to slow queries, missing indexes, connection exhaustion, insecure RLS policies, and failed migrations. This Skill gives an AI agent a prioritized, Supabase-maintained rule set so every schema change, query, or migration follows proven Postgres practices. ## Core Features & Use Cases - Prioritized rule library: 8 categories ranked by impact, from critical query performance and connection management to advanced features like full-text search and JSONB indexing. - Error-first SQL examples: Each rule shows an incorrect pattern, a corrected pattern, quantified impact, and EXPLAIN or metrics context. - Security and RLS guidance: Covers Row-Level Security policies, SECURITY DEFINER functions, least-privilege roles, and RLS performance optimization. - Use Case: Before writing a migration that adds a column and an RLS policy, load this Skill so the agent applies idempotent constraint patterns, indexes the foreign key, and wraps auth.uid() in a subquery for performance. ## Quick Start Review my Postgres schema and queries using the Supabase Postgres best practices skill and fix any performance or security issues you find.
