Database Design and Safe Migrations

Treat migrations as durable production code. Fetch the latest repository state before creating one, inspect every existing migration, choose the next unused number, and test both forward and reverse behavior.