postgres-patterns

To optimize slow PostgreSQL queries, apply efficient SQL patterns and indexing strategies. This Skill provides reference guides for troubleshooting slow queries and recommending appropriate database indexes to improve performance.

PostgreSQL schema design best practices involve selecting appropriate data types and table structures. This Skill provides reference patterns for designing efficient schemas based on Supabase best practices to ensure optimal data operations.

Implement Row Level Security (RLS) in PostgreSQL by applying established security patterns. This Skill provides guidance on setting up RLS policies to secure database operations based on Supabase best practices.

Find unindexed foreign keys in your PostgreSQL database by consulting this Skill's quick reference guides. It provides specific patterns and queries to identify missing indexes on foreign keys for performance tuning.

Yes, this Skill covers connection pooling setup for PostgreSQL. It addresses scenarios including setting up connection pooling alongside query optimization, schema design, and security to ensure efficient database operations.