following-supabase-postgres-best-practices

What problem does it solve?

This Skill addresses common and costly production issues in Supabase and PostgreSQL by applying best practices for query performance, schema design, security, and connection management.

Core Features & Use Cases

• Query Optimization: Identifies and fixes slow queries through proper indexing and query planning.
• Schema Design: Guides the creation of robust and maintainable database schemas.
• Security: Ensures secure data access with Row Level Security (RLS) and least privilege principles.
• Connection Management: Optimizes connection pooling and timeouts for efficient resource usage.
• Use Case: Before deploying a new feature that heavily relies on database interactions, use this Skill to review your schema, RLS policies, and critical queries to prevent performance bottlenecks and security vulnerabilities.

Quick Start

Review the current database schema and identify any missing indexes or suboptimal RLS policies.