Generates secure, production-ready PostgreSQL functions and triggers optimized for Supabase databases.
This skill provides comprehensive guidance for creating high-quality PostgreSQL functions within the Supabase ecosystem. It enforces critical security patterns such as 'SECURITY INVOKER' and 'search_path' isolation to protect against schema hijacking and privilege escalation. Whether you are building automated triggers, complex business logic, or helper functions for Row-Level Security (RLS), this skill ensures your database-side code follows production-grade standards and integrates seamlessly with Supabase client libraries and PostgREST.
Key Features
01Automatically qualifies database object references to avoid schema resolution attacks
02Prevents common SQL injection vulnerabilities through proper quoting and input validation
03Provides clear patterns for error handling and data validation within PL/pgSQL
04Enforces SECURITY INVOKER and search_path isolation for maximum database security
051 GitHub stars
06Generates optimized templates for triggers, stored procedures, and immutable functions
Use Cases
01Building secure trigger functions for automated table operations and data auditing
02Implementing complex backend business logic in the database to optimize performance
03Creating specialized helper functions for hardening Row-Level Security (RLS) policies
