yoyo-migrations

About yoyo-migrations

Database schema migration tool that lets you manage your database schema by applying and rolling back migration scripts written in pure SQL or Python. Simple and flexible approach to database migrations.

Key Features

• 1Lightweight SQL migration tool using plain .sql files for schema changes
• 2Migration tracking via a database table recording applied migrations
• 3Step-based rollback support using down.sql files
• 4Command-line interface for applying, rolling back, and listing migrations
• 5Compatible with PostgreSQL, MySQL, SQLite, and any database with a Python DBAPI driver

How Python Data Engineers Use yoyo-migrations

Python data engineers use yoyo-migrations for managing database schema changes in projects where plain SQL migrations are preferred over ORM-based tools like Alembic or Django migrations. It is used to version-control schema changes for analytics databases, pipeline metadata stores, and data warehouse tables, keeping DDL changes in source control and ensuring consistent schema state across development, staging, and production environments.