Its not that bullet proof. It still runs into issues with version control type conflicts made by multiple developers/branches. Something like FlywayDB can at least spot these problems but not prevent them.

Not sure if any of the migration tooling can handle multiple branches or unordered changes.