Implements robust database row-level security policies for multi-tenant and user-scoped data architectures.
This skill provides a comprehensive library of Row-Level Security (RLS) patterns and best practices, specifically optimized for PostgreSQL and Supabase environments. It guides developers through enabling RLS, implementing essential bypass policies for admins and service roles, and managing complex access controls like team-based or role-based permissions. By providing ready-to-use templates and debugging strategies, it helps prevent common pitfalls like infinite recursion and security leaks in production database schemas.
主な機能
01Storage bucket security configurations for file access management
02Recursive policy detection and performance-optimized solutions
03Essential bypass patterns for super admins and backend service roles
041 GitHub stars
05Multi-tenant isolation strategies with tenant-specific scoping
06Comprehensive templates for SELECT, INSERT, UPDATE, and DELETE policies
ユースケース
01Implementing Role-Based Access Control (RBAC) in a Supabase project
02Debugging and auditing existing RLS policies for security gaps
03Securing a SaaS application with multi-tenant data isolation
