Supabase Auth — Admin/User Role Separation

Skill for configuring admin/user role separation in Supabase with proper RLS policies, avoiding the common infinite recursion pitfall.

Triggers

• "add admin roles"
• "is_admin"
• "role separation"
• "SECURITY DEFINER"
• "admins table"
• "RLS recursion"

When to Use

• Creating an admin/user role system in Supabase
• Fixing "infinite recursion detected in policy" errors
• Configuring RLS policies that check user roles
• Debugging 500 errors on REST API related to RLS