rls-policy

Creates and enforces Supabase Row Level Security policies for users and roles.

Updated Dec 1, 2025
One-click install
npx skills add https://github.com/jj8127/Appointment-Process --skill rls-policy
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rls-policy
Source: https://github.com/jj8127/Appointment-Process/tree/main/.claude/skills/rls-policy
Command: npx skills add https://github.com/jj8127/Appointment-Process --skill rls-policy

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps teams implement safe, scalable Row Level Security (RLS) policies in Supabase, enabling fine-grained access control to database rows across applications and services.

Core Features & Use Cases

  • Enable RLS on tables to enforce per-user access.
  • Provide templates for common policies: authenticated users, service roles, and owner-based updates.
  • Guide storage bucket access control and policy patterns for secure data handling in Supabase.

Quick Start

Use the guidance in this skill to plan and implement RLS policies in your Supabase project. Start by enabling RLS on your tables, then apply policies for authenticated users, service roles, and owners. Run the SQL templates against your database and storage to establish secure, auditable access rules.

Frequently Asked Questions about rls-policy

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I enable Supabase Row Level Security to isolate data across users?

Supabase Row Level Security (RLS) isolates database rows by enabling RLS on Postgres tables and defining SQL policies for authenticated users, owners, and service roles to enforce strict per-user data access.

What is the best way to write RLS policies for authenticated users in Supabase?

The best way to write RLS policies for authenticated users in Supabase is to use SQL policy templates that grant per-row access based on user roles and ownership, ensuring fine-grained, auditable data access control.

How do I secure Supabase storage buckets with RLS policy rules?

Securing Supabase storage buckets with RLS policy rules involves applying SQL policies to the storage layer to control access, establishing safe, scalable rules for data handling and restricting file access by user or role.

Does Supabase Row Level Security work with service role edge cases?

Yes, Supabase Row Level Security handles service role edge cases by providing specific SQL policy templates that define access rules, ensuring service roles bypass or comply with strict data isolation requirements as needed.

Why do I need to enable RLS on Postgres tables for per-user data access?

You need to enable RLS on Postgres tables to enforce per-user data access because RLS prevents unauthorized row visibility, providing the strict data isolation required across applications and services in Supabase.