Sqitch Database Change Management

Sqitch is a database change management and migration system that brings framework-free, dependable deployment to database schema evolution. Unlike migration frameworks that rely on linear version numbers or timestamps, Sqitch uses a dependency graph approach where each change explicitly declares its dependencies on other changes, enabling parallel development branches that can be merged without conflicts. This design allows database changes to be developed independently, reviewed through pull requests, and deployed in any order as long as dependencies are satisfied. The system tracks which changes have been applied to each database through a dedicated tracking schema, providing reliable state management across development, staging, and production environments. Changes can include deploy scripts for applying modifications, revert scripts for rolling back, and verify scripts for validating successful application. Sqitch supports multiple database engines natively including PostgreSQL, MySQL, MariaDB, SQLite, Oracle, Firebird, Vertica, and Exasol, with each engine having its own client and native SQL dialect support. The tool integrates with Git for version control of change scripts and supports tagging to mark release points for reproducible deployments. Licensed under the MIT License, Sqitch is written in Perl and distributed as a standalone executable. Used by organizations including iovation and other enterprise teams, it provides the structure and reliability needed for managing complex database schema changes in agile development environments.