rls-policy-consolidator

Consolidate redundant RLS policies by auditing current policies per table, identifying those with the same role and action, creating a migration that drops redundant policies and creates a unified policy using OR logic, then verifying permissions with Supabase advisor.

Multiple permissive policies granting the same role and action across tables cause sequential policy evaluation overhead. Consolidating them into a single unified policy with OR logic reduces evaluation cycles and resolves performance warnings.

Yes. You can merge redundant permissive policies by creating a migration that combines conditions using OR logic, eliminating sequential evaluation of duplicate policies while maintaining the same permissions.

This approach targets Supabase tables including cotizaciones, items_cotizacion, lead_actividades, leads, precios_escalonados, productos, and profiles where redundant permissive policies exist for the same role and action.

After applying the migration, test permissions in a development environment using MCP Supabase to confirm that the unified policy grants the same access as the original redundant policies without performance degradation.

Consolidate when Supabase advisor warns of performance issues, or when multiple policies grant identical permissions to the same role and action—consolidation reduces policy evaluation overhead without changing access behavior.