supabase-rls-fix

The Supabase RLS Fix skill is designed to address common issues related to Row-Level Security (RLS) in Supabase projects. It helps resolve errors caused by missing user or tenant context, particularly in system processes, background jobs, or scheduled tasks. This skill ensures that RLS policies do not inadvertently block legitimate access for system operations and provides a framework for consistently implementing RLS across new and existing tables. By standardizing these fixes, it reduces the risk of runtime errors like 'relation does not exist' or 'Tenant or user not found'.

The skill offers several core capabilities. It includes quick fixes for common issues, such as creating a compatibility view for missing user-related tables and updating functions to handle system processes when no user context is present. Additionally, it provides permanent solutions through standardized helper functions, including checks for system processes and universal access validation based on user and tenant IDs. Templates for applying RLS to new tables streamline the setup process, ensuring that developers can consistently enforce access rules without manual intervention or error-prone custom implementations.

This skill is primarily intended for developers and database administrators working with Supabase, especially those managing multi-tenant applications or background jobs that require automated access control. Use cases include fixing errors in existing RLS configurations, enabling RLS on new tables, and supporting system processes that need temporary access to data without violating security policies. It is particularly useful for teams seeking to maintain consistent RLS practices, reduce maintenance overhead, and prevent downtime caused by access-related failures in both interactive and automated workflows.