create-migration

To create a Supabase migration with RLS policies, generate a scaffold containing an initial table with id, user_id, and created_at columns, alongside built-in row-level security rules for select, insert, update, and delete operations.

Scaffolding secure CRUD tables in Supabase requires generating a migration template with predefined RLS policies and indexing, which reduces setup errors and accelerates secure schema changes across your database environments.

You apply a Supabase migration using the MCP workflow by generating the migration scaffold and then following the provided guidance to deploy it via the MCP Supabase deployment workflow while updating your PRD modules.

Yes, the Supabase migration scaffold includes row-level security configurations for all CRUD operations. The generated template ensures policy consistency by applying select, insert, update, and delete RLS policies directly to the target table.

RLS policies are important when setting up Supabase database migrations because they enforce data access control at the database level. Including them in a scaffold prevents security misconfigurations during initial table creation and subsequent schema updates.

Yes, you can ensure policy consistency across different Supabase environments by applying the same migration scaffold. This template standardizes RLS policy generation and deployment, maintaining uniform security rules throughout your development and production setups.