We have recently developed a preview feature which can check for externally made changes (e.g. those not made by Flyway) before the next migration is ran which is available in Flyway versions 10.20.1 and later.

Database drift is the unintentional divergence of a database schema from its version-controlled state, often due to direct changes made outside the standard deployment process.

Drift is detected by comparing the state of your SQLServer/PostgreSQL/MySQL or Oracle schema after your last migration and before your next migration scripts have been applied and will tell you if out-of-process changes have occurred in between those two states. You will be able to see information regarding the database objects that have drifted in a drift report within Flyway Pipelines

To start using this feature today visit https://flyway.red-gate.com/ for instructions on how to configure the drift check and download the latest version of Flyway.