supabase-postgres-best-practices

@ecocee

Postgres performance, security, and schema best practices for Supabase projects. Trigger when the user is writing SQL queries, designing a schema, adding indexes, setting up Row-Level Security (RLS), configuring connection pooling, debugging slow queries, reviewing database code, or asking anything related to Supabase or Postgres optimization. Also trigger on phrases like "is this query good?", "how do I speed this up?", "set up RLS for my table", "design my schema", "is this schema correct?", or "how should I structure this database?". Covers query performance, connection management, security, schema design, concurrency, data access patterns, monitoring, and advanced Postgres features. Applies to all Supabase-hosted and self-hosted Postgres instances.