Yoyo is a database schema migration tool. You write database migrations as Python scripts containing raw SQL statements or Python functions.

As your database application evolves, changes to the database schema may be required. Yoyo lets you write migration scripts in Python containing SQL statements to migrate your database schema to a new version.

A simple migration script looks like this:

Yoyo manages these database migration scripts, gives you command line tools to apply and rollback migrations, and manages dependencies between migrations.

PostgreSQL, MySQL and SQLite databases are supported. ODBC and Oracle database backends are available (but unsupported).

Yoyo migrations documentation | Repository