Can I use this with Supabase storage?

Absolutely, it includes templates for securing storage buckets and folders based on user IDs and folder naming conventions.

How do I debug my policies using this skill?

The skill includes specific SQL snippets for impersonating users, checking active policies, explaining queries with RLS, and finding tables missing security.

How does it help with policy recursion?

It identifies common recursion causes and provides three specific solutions, including security definer functions and denormalized arrays for better performance.

Does this skill support multi-tenant architectures?

Yes, it includes specific patterns for tenant isolation, get_user_tenant_id functions, and cross-tenant admin access configurations.

What is the primary benefit of the rls-security skill?

It provides standardized, battle-tested SQL templates for implementing Row-Level Security, reducing the risk of data leaks and common policy configuration errors.

Row-Level Security Patterns

Name: Row-Level Security Patterns
Author: JaveedIshaq

byJaveedIshaq

•

데이터베이스 관리

Implements robust database row-level security policies for multi-tenant and user-scoped data architectures.

소개

This skill provides a comprehensive library of Row-Level Security (RLS) patterns and best practices, specifically optimized for PostgreSQL and Supabase environments. It guides developers through enabling RLS, implementing essential bypass policies for admins and service roles, and managing complex access controls like team-based or role-based permissions. By providing ready-to-use templates and debugging strategies, it helps prevent common pitfalls like infinite recursion and security leaks in production database schemas.

주요 기능

Storage bucket security configurations for file access management
Recursive policy detection and performance-optimized solutions
Essential bypass patterns for super admins and backend service roles
1 GitHub stars
Multi-tenant isolation strategies with tenant-specific scoping
Comprehensive templates for SELECT, INSERT, UPDATE, and DELETE policies

사용 사례

Implementing Role-Based Access Control (RBAC) in a Supabase project
Debugging and auditing existing RLS policies for security gaps
Securing a SaaS application with multi-tenant data isolation

소개

주요 기능

Storage bucket security configurations for file access management
Recursive policy detection and performance-optimized solutions
Essential bypass patterns for super admins and backend service roles
1 GitHub stars
Multi-tenant isolation strategies with tenant-specific scoping
Comprehensive templates for SELECT, INSERT, UPDATE, and DELETE policies

사용 사례

Implementing Role-Based Access Control (RBAC) in a Supabase project
Debugging and auditing existing RLS policies for security gaps
Securing a SaaS application with multi-tenant data isolation