Supabase Auth — Multi-Tenant Organization Pattern

Skill for building multi-tenant applications with organizations, roles (admin/member), and org-scoped RLS policies in Supabase.

Triggers

• "multi-tenant"
• "organizations"
• "organization_members"
• "org-scoped RLS"
• "get_user_org_id"

When to Use

• Building applications where users belong to organizations
• Configuring admin/member roles within an organization context
• Creating RLS policies that restrict data to the user's organization
• Fixing RLS recursion errors in tables with self-referencing subqueries