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

The analysis can be run without a database connection but typically Flyway would establish a connection to identify which migrations are pending and only analyze these.

This makes it a valuable validation step in a continuous integration build process or a simple way to determine if your SQL meets your organization's expectations 

Community Tier

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

Enterprise Tier

• Flyway ships with additional Redgate SQLFLuff rules aimed at identifying data loss and security issues.
• Flyway removes the need to install Python and SQLFluff yourself
• Flyway has an additional analysis engine that lets you easily configure pattern-matching rules for simple user extensions to the analysis capabilities 
• Flyway can halt your CI pipeline in the event of code analysis errors being identified 

Running code analysis

See Running code analysis