supabase-rls-policy

What problem does it solve?

This Skill provides expert guidance for writing Supabase PostgreSQL Row-Level Security policies, ensuring correct syntax, role usage (anon, authenticated), and production-ready patterns.

Core Features & Use Cases

• Policy Structure: separate policies for SELECT, INSERT, UPDATE, DELETE
• Supabase Roles: anon and authenticated and how to apply TO clause
• Helper Functions: auth.uid() and auth.jwt()
• MFA & Performance: MFA checks and indexing recommendations

Quick Start

Create a policy example on a table to restrict access to authenticated users using their user id.