How do your teams run DB migrations?

We're a new team and looking to standardise on an approach. Currently, devs run them manually from their machines (using flyway), migrations scripts are checked in to version control.

We'd like to try run them automatically on every merge to master across all envs.

This would require the application & DB evolution to be decoupled, which I think is a good practice anyway.

Wanted to canvas the community for any opinions, this is quite a common problem so I'm hoping there's a fair bit of experience I can leverage!

Thanks