aerich

What it is and what it does

Aerich is a migration tool designed specifically for TortoiseORM, an async Python ORM. It provides a command-line interface and programmatic API to generate, version, and apply database schema changes. The tool detects model changes, generates migration files with timestamped versions, and can upgrade or downgrade the database schema. It also includes an inspectdb command to reverse-engineer existing database tables into TortoiseORM model definitions.

The package depends on tortoise-orm (the ORM it targets), dictdiffer (for comparing model states), asyncclick (for CLI), and anyio (for async compatibility). It's actively maintained and supports modern Python versions (3.10 through 3.14). However, the project's own documentation warns that tortoise-orm>=1.0.0 includes built-in migration support as an alternative, so users should verify whether Aerich or the built-in solution better fits their needs.

Use it for

• Track and apply schema changes in TortoiseORM projects without manually writing SQL or managing version state.
• Reverse-engineer existing MySQL, PostgreSQL, or SQLite databases into TortoiseORM model definitions via inspectdb.
• Manage multiple database connections and per-app migration directories in complex projects.
• Programmatically run migrations within an application using the Command class instead of CLI.
• Roll back database changes to a previous version when a migration causes issues.

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

aerich on PyPI

Before you install

Installation is straightforward with low friction—a pure-Python wheel with four runtime dependencies. The package is actively maintained with a recent release and no known vulnerabilities, though the warning in its own documentation notes that tortoise-orm>=1.0.0 includes built-in migration support as an alternative.

Requires Python >=3.10; tortoise-orm must be installed and configured with aerich.models included in the app config.

License in practice

Licensed under Apache-2.0 (permissive), which allows free use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.

Quickstart

pip install aerich

# In your project, add aerich.models to your Tortoise-ORM config:
TORTOISE_ORM = {
    "connections": {"default": "sqlite://:memory:"},
    "apps": {
        "models": {
            "models": ["myapp.models", "aerich.models"],
            "default_connection": "default",
        },
    },
}

# Then initialize and run migrations:
# aerich init -t myapp.config.TORTOISE_ORM
# aerich init-db
# aerich migrate --name add_column
# aerich upgrade

Package facts

Evidence: aerich-0.10.0-py3-none-any.whl

Tags

More Python Modules packages

See also tortoise-orm · alembic · pypika-tortoise · peewee-migrate · Flask-Migrate · pytest-alembic · mongodb-migrations · sqlalchemy-migrate · yoyo-migrations · Flask-Alembic