Implements high-performance and secure Row Level Security (RLS) policies and functions for Supabase projects.
This skill provides a standardized framework for implementing Supabase Row Level Security (RLS) with a focus on performance and security. It enforces best practices such as B-tree indexing on filter columns, leveraging initPlan caching via auth.uid() wrapping, and securing SECURITY DEFINER functions through schema qualification and search_path definitions. By following these guidelines, developers can ensure that security boundaries are strictly maintained at the database level while optimizing query execution plans and migration workflows.
主な機能
01Secure SECURITY DEFINER function patterns with schema qualification
02Standardized error handling logic using RETURN false versus RAISE EXCEPTION
03Migration-based workflow for RLS policy management and rollbacks
040 GitHub stars
05Performance optimization through B-tree indexing and JWT function caching
06Enforcement of security boundaries within the database layer
ユースケース
01Scaling Supabase applications with complex multi-tenant security requirements
02Hardening database security through robust Row Level Security implementations
03Optimizing RLS query performance for high-traffic PostgreSQL databases
