supabase-postgres-best-practices
Pass
Audited by Gen Agent Trust Hub on Sep 15, 2026
Risk Level: SAFE
Full Analysis
- Security Guidance and Best Practices: The skill offers extensive guidance on implementing secure database patterns. It emphasizes the principle of least privilege and provides correct SQL examples for granular role management, which helps reduce the potential attack surface of database users.
- RLS and Multi-tenancy Safety: The documentation includes detailed instructions for Row-Level Security (RLS), highlighting the importance of database-level enforcement to prevent data leaks. It specifically addresses performance and security considerations for complex RLS policies, such as the safe use of
SECURITY DEFINERfunctions by incorporating fixed search paths and explicit identity checks. - Safe Schema Migrations: The guidelines include idempotent migration patterns using PL/pgSQL blocks to safely add constraints. This approach minimizes the risk of migration failures in automated deployment environments.
- Resource Management and Stability: The skill provides recommendations for connection limits, memory settings, and timeouts. These configurations are essential for maintaining database stability and preventing resource exhaustion that could lead to service unavailability.
Audit Metadata