rls-policy-generator

What problem does it solve?

This Skill simplifies the complex and error-prone process of writing and managing Row Level Security (RLS) policies in Supabase, preventing data breaches and ensuring proper access control.

Core Features & Use Cases

• Generate Production-Ready Policies: Creates RLS policies with super admin bypass, correct USING/WITH CHECK clauses, and handles common account-based access patterns.
• Prevent Common Bugs: Guides users away from critical mistakes like infinite recursion and incorrect handling of personal vs. team accounts.
• Storage Bucket Security: Provides patterns for securing files in Supabase Storage.
• Use Case: When creating a new table in Supabase, use this Skill to generate secure RLS policies that automatically protect the data based on user roles and ownership, ensuring only authorized users can access or modify records.

Quick Start

Use the rls-policy-generator skill to create a new RLS policy for the 'events' table that allows authenticated users to select their own events.