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

데이터베이스 관리

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.

주요 기능

Multi-tenant data isolation and organization-based access control
MFA-restricted and role-based access policy implementation
Automated RLS enablement for Supabase database tables
Performance-optimized SQL patterns for authentication checks
0 GitHub stars
Granular policy generation for SELECT, INSERT, UPDATE, and DELETE

사용 사례

Isolating user data so individuals can only view and edit their own records
Enforcing strict multi-tenant boundaries for enterprise SaaS applications
Creating public-read tables with restricted write access for authenticated users

소개

주요 기능

Multi-tenant data isolation and organization-based access control
MFA-restricted and role-based access policy implementation
Automated RLS enablement for Supabase database tables
Performance-optimized SQL patterns for authentication checks
0 GitHub stars
Granular policy generation for SELECT, INSERT, UPDATE, and DELETE

사용 사례

Isolating user data so individuals can only view and edit their own records
Enforcing strict multi-tenant boundaries for enterprise SaaS applications
Creating public-read tables with restricted write access for authenticated users