Pushing Local Changes to Prod Environment
- Make database changes to the local supabase dashboard or wherever
- Create a new migration by running
supabase db diff -f insert_good_migration_name_here
- Review the generated migration file and ensure all the changes expected changes
- Reset your local database to ensure the migration works as expected
supabase db reset
- Once you’ve tested everything now you can push your migrations
supabase db push
warning
supabase db push
will update the production environment. REALLY make sure it doesn't break anything before you run this command.