supabase-postgres-best-practices

What problem does it solve?

This Skill addresses common performance bottlenecks and anti-patterns in PostgreSQL databases, particularly within the Supabase ecosystem, enabling developers to write more efficient queries, design better schemas, and manage connections effectively.

Core Features & Use Cases

• Query Optimization: Provides guidance on indexing, query structure, and avoiding full table scans.
• Schema Design: Offers best practices for data types, primary keys, and partitioning.
• Connection Management: Details strategies for pooling, timeouts, and limits to ensure stability.
• Security & RLS: Covers applying the principle of least privilege and optimizing Row-Level Security policies.
• Use Case: A developer is experiencing slow query performance on their Supabase project. They can use this Skill to identify missing indexes, inefficient JOINs, or poorly configured RLS policies, leading to significant performance improvements.

Quick Start

Use the supabase-postgres-best-practices skill to identify missing indexes on foreign key columns in your database schema.