Flyway can run static code analysis over your SQL migration scripts. This validates your SQL to check for errors or bad practice.

No database connection is required to run this check so it can easily performed as a validation step in a continuous integration build process.

Flyway provides built in support for integrating with SQLFluff. This is an analysis engine which supports a large number of SQL dialects and can detect a variety of SQL violations.

At Flyway Enterprise tier it is also possible to create regular expression rules, which allow for a simple way of detecting simple undesirable patterns.

Running code analysis

See Running code analysis