DBLift is an open-source, Apache 2.0 licensed database migration tool designed for Python teams. It offers a Flyway-style approach for raw SQL migrations, easily installable with pip, eliminating the need for a JVM. You can write versioned SQL or Python migration files and preview every statement before execution using the `--dry-run --show-sql` command, ensuring safety and transparency.

• The open core component manages migrations under a lock, records each version in a schema history table, and provides commands like `dblift info` to display applied, pending, and reversible migrations.

• It validates history against the repository and supports rollbacks using custom undo files.

• DBLift allows you to baseline existing databases or import Flyway histories.

• It supports twenty database engines, including PostgreSQL, MySQL, SQL Server, DuckDB, MongoDB, and PostgreSQL-compatible clouds, all managed through a single CLI.

• A Python API, pytest-dblift integration, and a GitHub Action are available for streamlined development workflows.

• Pro features include SQL review, schema comparison, and audited data fixes.

• Enterprise features offer offline plans, preflight rehearsals, and retained release evidence for approvers.

• DBLift serves as a Flyway alternative for Python teams, enabling them to maintain versioned SQL and understand changes during migrations.

• It facilitates Python migrations for data changes requiring Python code using `MigrationContext`.

• MongoDB migrations in Python are supported with a workflow for collections, indexes, and backfills, including real command output.