Nice writeup. It's one of those things not taught in school and always learn in the hard way.

We at Bytebase also recognize this and have spent over 2 years to build a solution for team to coordinate the database migrations better.