yoyo-migrations

What it is and what it does

Yoyo-migrations is a database schema migration tool that manages version-controlled changes to your database structure. You write migrations as either raw SQL files or Python scripts containing SQL statements, and yoyo provides command-line tools to apply them forward, roll them back, and manage dependencies between migration steps. It supports PostgreSQL, MySQL, and SQLite out of the box.

The tool is designed to integrate into your application's deployment workflow, letting you track schema changes alongside code changes. Migrations are simple to write—a Python migration is just a call to the step() function with forward and rollback SQL—and yoyo handles the bookkeeping of which migrations have been applied to which database. It has been marked Production/Stable since its first release in 2010, though it has not had a new release for 734 days.

Use it for:

• Manage schema changes in a PostgreSQL, MySQL, or SQLite application as part of your deployment pipeline.
• Write reversible database migrations in Python or SQL to evolve your schema safely across environments.
• Track and enforce migration dependencies so that schema changes are applied in the correct order.
• Rollback a migration if a deployment fails or a schema change needs to be undone.
• Version-control your database schema changes alongside your application code.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Yoyo-migrations is a database schema migration tool that lets you write and manage migrations as SQL files or Python scripts, with command-line tools to apply, rollback, and track dependencies across PostgreSQL, MySQL, and SQLite databases.

Yes, if your project uses PostgreSQL, MySQL, or SQLite and you need a lightweight, straightforward migration tool. The low install friction and permissive license make it accessible. However, be aware that the package is dormant (no releases for 734 days), so consider whether you need active maintenance for compatibility with newer database versions or Python releases, or whether an actively maintained alternative better fits your risk tolerance.

Install

yoyo-migrations on PyPI

pip install yoyo-migrations

uv add yoyo-migrations

poetry add yoyo-migrations

Installing yoyo-migrations

Before you install

Low install friction with only three runtime dependencies (sqlparse, tabulate, importlib-metadata). However, the package is dormant—no releases for 734 days as of the fact sheet date—which may signal reduced maintenance responsiveness for bug fixes or compatibility updates.

License in practice

Licensed under Apache (permissive), which allows commercial and private use with minimal restrictions, making it safe for most projects from a licensing standpoint.

Quickstart

pip install yoyo-migrations

from yoyo import step
step(
    "CREATE TABLE foo (id INT, bar VARCHAR(20), PRIMARY KEY (id))",
    "DROP TABLE foo",
)

Requires a supported database (PostgreSQL, MySQL, or SQLite) and appropriate database driver installed separately.

Verify before relying

• Whether the 734-day dormancy affects real-world compatibility with recent database versions or Python releases.
• Whether ODBC and Oracle backends mentioned as 'unsupported' are maintained or functional.
• Comparison of feature completeness and migration workflow against actively maintained alternatives like Alembic or South.

Package facts

Evidence: yoyo_migrations-9.0.0-py3-none-any.whl

Keywords: migrations, migrate, database, alembic, south

Tags

More Software Development packages