Rolling back migrations in Supabase - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does 'rolling back migrations' mean in Supabase?

It means undoing changes made to the database schema by reversing the last migration or a set of migrations.

beginner

Which Supabase CLI command is used to roll back the last migration?

The command is supabase db migration down to undo the last migration specifically, or supabase db reset which resets the database including rolling back all migrations.

intermediate

Why should you be careful when rolling back migrations in Supabase?

Because rolling back can delete or alter data and schema, potentially causing data loss if not backed up or tested properly.

intermediate

What is a safe practice before rolling back migrations?

Always back up your database and test the rollback process in a development environment before applying it in production.

intermediate

How does Supabase track migrations to enable rolling back?

Supabase stores migration history in a special table that records applied migrations, allowing it to know which ones to undo.

Which command rolls back the last migration in Supabase?

A supabase db migrate apply

B supabase db migration down

C supabase db push

D supabase db reset --no-rollback

supabase db migration down reverses the last migration applied to the database.

What is a risk of rolling back migrations without backup?

A Increased storage space

B Faster database queries

C Data loss or corruption

D Automatic schema upgrade

Rolling back can remove schema changes and data, causing data loss if no backup exists.

Where does Supabase store migration history?

A In a special migrations table

B In the application code

C In the cloud storage bucket

D In the user session

Migration history is stored in a database table to track applied migrations.

What should you do before rolling back migrations in production?

A Back up the database

B Delete all data

C Restart the server

D Ignore warnings

Backing up ensures you can restore data if rollback causes issues.

Which command resets the database including rolling back all migrations?

A supabase db push

B supabase db migrate undo

C supabase db status

D supabase db reset

supabase db reset resets the database and rolls back all migrations.

Explain the process and risks of rolling back migrations in Supabase.

Think about what happens to your database schema and data when you reverse migrations.

Describe best practices to follow before and after rolling back migrations.

Consider safety steps to avoid data loss and ensure smooth rollback.