supabase-admin

Supabase Row Level Security policies for owner-based access are designed using auth.uid() within policy definitions to restrict data access. The skill provides specific RLS policy patterns for owner-only, role-based, and team access controls to enforce correct data visibility.

Zero-downtime migration in Supabase is achieved using safe migration templates and non-blocking schema change patterns. The skill provides naming conventions and production-safe migration templates to add columns or alter schemas without locking the database.

Users see no rows when Supabase PostgreSQL RLS policies block access to the data. The skill includes debugging queries and diagnostics to identify why RLS policies are filtering out rows, helping you correct policy logic and permissions.

To auto-populate profiles on Supabase signup, you create PostgreSQL functions and triggers that respond to auth events. The skill provides auth integration examples and trigger templates to automatically generate profile records when new users register.

Supabase PostgreSQL performance is optimized by using subqueries to extract auth.jwt() claims once, rather than parsing the JWT per row. The skill offers indexing recommendations and pagination strategies to improve query throughput and database scaling.

Hierarchical access controls in Supabase RLS are supported through specific policy patterns for nested data relationships. The skill provides design patterns for hierarchical privacy and team-based access to manage complex data permissions.