Alembic vs Sqitch
Alembic
alembic.sqlalchemy.orgSqitch
sqitch.orgSide by side
| Figure | Alembic | Sqitch |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Database Migration Tools | 7.9 (#12) | 7.9 (#13) |
| Installation | Alembic can be installed with pip and is commonly installed in a project-local Python virtual environment. | The project provides source and Docker installation options, Linux distribution packages, a macOS Homebrew installation, and Windows installation instructions. |
| License | The repository license grants permission to use, copy, modify, distribute, and sell the software, subject to its stated conditions. | The manual grants permission to use, modify, publish, distribute, sublicense, and sell the software subject to its stated condition, and provides it without warranty. |
| Maintainer | Alembic is developed by Mike Bayer and is part of the SQLAlchemy project. | The manual names David E. Wheeler as the author. |
Plans
In their own words
Alembic
Alembic has no write-up on Specifiction yet; its figures are above.
Sqitch
Sqitch is a database change management application for deploying and tracking database changes. It is a standalone system, not tied to a framework, ORM, database engine, or development environment. Changes are written as scripts native to the chosen database, and can declare dependencies—including changes in other Sqitch projects—to establish execution order. A plan file and Merkle tree pattern support deployment integrity without requiring numbered change names. Sqitch can deploy and revert changes, report status and history, and run optional verification scripts. Its manual lists PostgreSQL, YugabyteDB, CockroachDB, SQLite, MySQL, MariaDB, Oracle, Firebird, Vertica, Exasol, Snowflake, and ClickHouse. Connecting and executing scripts requires the database's native command-line client and connector libraries. Installation options include source, Docker, Linux distribution packages, macOS Homebrew, and Windows instructions. Sqitch is free, with a license permitting use and distribution, and is available for Linux, macOS, Windows, and self-hosted use.