Can it handle sensitive data requiring MFA?

Yes, it can implement restrictive policies that check for specific Authenticator Assurance Levels (AAL) before allowing access to sensitive database operations.

How does it optimize RLS performance?

The skill generates optimized SQL queries, such as wrapping authentication functions in sub-selects, to minimize the performance overhead of permission checks.

What tools does this skill require to operate?

The skill uses the Read, Write, Edit, and Grep tools to analyze your current schema and apply the necessary SQL policy changes directly to your project files.

What is the setup-rls Claude Code skill?

It is a specialized capability that helps developers configure and implement Row Level Security (RLS) policies for Supabase tables using industry-standard security patterns and best practices.

Does this skill support multi-tenant applications?

Yes, it includes specific patterns for isolating data based on tenant IDs found within the Supabase JWT, ensuring users only see data belonging to their organization.

Supabase RLS Policy Setup

Name: Supabase RLS Policy Setup
Author: rdimascio

byrdimascio

0•

Database Management

Configures production-ready Row Level Security policies for Supabase tables to ensure secure, role-based data access.

The setup-rls skill empowers developers to implement robust security layers within Supabase databases by automating the creation and management of Row Level Security (RLS) policies. It analyzes access requirements for various user roles—handling scenarios like multi-tenant isolation, user-owned records, and MFA-restricted permissions—to generate optimized SQL policies for SELECT, INSERT, UPDATE, and DELETE operations. By following performance best practices, such as wrapping auth functions in SELECT statements, it ensures that application data remains isolated and secure without compromising database performance.

Key Features

01Multi-tenant data isolation and organization-based access control

02MFA-restricted and role-based access policy implementation

03Automated RLS enablement for Supabase database tables

04Performance-optimized SQL patterns for authentication checks

050 GitHub stars

06Granular policy generation for SELECT, INSERT, UPDATE, and DELETE

Use Cases

01Isolating user data so individuals can only view and edit their own records

02Enforcing strict multi-tenant boundaries for enterprise SaaS applications

03Creating public-read tables with restricted write access for authenticated users

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rdimascio/supabase-marketplace setup-rls

For use in Claude.ai and ChatGPT

Download Skill