Flyway

About Flyway

Robust version control tool for databases with support for SQL-based migrations. While not Python-specific, widely used in the community and easily integrated into Python projects for database schema management.

Key Features

• 1SQL-first migrations stored as versioned files (V1__, V2__, etc.)
• 2Checksums detect accidental changes to already-applied migrations
• 3Supports PostgreSQL, MySQL, SQLite, Oracle, SQL Server, and more
• 4Java-based CLI and Maven/Gradle plugins; also available as Docker image
• 5Repair command fixes checksum mismatches and failed migration state

How Python Data Engineers Use Flyway

Python data engineers use Flyway when SQL migrations need to be shared across polyglot teams. The CLI is invoked from Python scripts, Makefiles, or CI pipelines via subprocess — pointing Flyway at a directory of numbered SQL files and a JDBC connection string. This makes it easy to apply identical migrations to dev, staging, and production databases in automated deployments.