Implements robust Row-Level Security (RLS) policies for multi-tenant and user-scoped database architectures.
The rls-security skill provides a comprehensive library of battle-tested patterns for implementing Row-Level Security in PostgreSQL and Supabase environments. It guides developers through the critical steps of enabling RLS, defining granular access policies for CRUD operations, and setting up essential admin and service role bypasses. The skill specifically addresses advanced scenarios like multi-tenant isolation, role-based access control (RBAC), and performance-optimized strategies to avoid infinite recursion, while offering deep diagnostic utilities to audit and verify security constraints during development.
Key Features
01Advanced recursion prevention strategies using denormalized arrays and helper functions
02Multi-tenant isolation patterns using tenant_id enforcement and JWT claims
03Critical admin and service role bypass implementations for backend SDK compatibility
04Standardized RLS policy templates for SELECT, INSERT, UPDATE, and DELETE operations
051 GitHub stars
06Diagnostic tools for auditing missing policies and impersonating users for security testing
Use Cases
01Debugging and resolving silent database failures or infinite recursion loops in security policies
02Implementing granular Role-Based Access Control (RBAC) directly at the database layer
03Building a multi-tenant SaaS application with strict data isolation between organizations
