supabase-postgres-best-practices

Fix slow PostgreSQL queries in Supabase by identifying missing indexes, restructuring inefficient JOINs, and avoiding full table scans. This Skill provides detailed SQL examples and rules to guide query optimization and schema design for better performance.

The best way to manage Postgres database connections in Supabase is implementing connection pooling, timeouts, and connection limits. This Skill details strategies to ensure database stability and prevent connection exhaustion under heavy load.

You can improve Row-Level Security (RLS) performance in Supabase by applying the principle of least privilege and optimizing RLS policies. This Skill covers techniques to prevent RLS policies from causing critical performance bottlenecks.

Design a PostgreSQL schema for better performance by following best practices for data types, primary keys, and table partitioning. This Skill offers guidance on schema design to eliminate common performance bottlenecks and anti-patterns.

You need to add indexes to foreign keys in PostgreSQL to prevent performance degradation during JOIN operations. This Skill helps identify missing indexes on foreign key columns in your database schema through quick start rules.