RLS Policy Templates
OfficialGenerate RLS Policies for User-owned and Shared Resources in Supabase
Authorbytetalent
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates the generation of Row Level Security (RLS) policies for user-owned and shared resources in Supabase databases, reducing manual configuration efforts and ensuring consistent application of security rules.
Core Features & Use Cases
- Auto-generated RLS Policies: Create RLS policies based on the configuration of the Supabase database, catering to user-owned tables, org-shared tables, and read-only reference tables.
- Integration with JWT Authentication: Integrates with Clerk JWT-based authentication for secure user identification in RLS policies.
- System Catalog and Reference Tables: Provides pre-written policies for system catalog tables and reference tables that can be enabled for read access without write operations.
- Drizzle Defense-in-Depth: Implements additional application-side filtering to reinforce database-level RLS and ensure security.
Quick Start
Execute the script to generate RLS policies for a user-owned table in the database named 'entities'.
Dependency Matrix
Required Modules
supabasedrizzleclerk
Components
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: RLS Policy Templates Download link: https://github.com/bytetalent/docs/archive/main.zip#rls-policy-templates Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.