amacneil/dbmate
Dbmate
Dbmate is a framework-agnostic SQL database migration tool used for tracking, applying, and rolling back schema changes to ensure consistent environments. It functions as a database schema versioning tool that manages updates independently of any specific application framework by relying on raw SQL and connection URLs.
The project distinguishes itself by offering a container-based approach to database administration, allowing schema updates to be executed via Docker to avoid local binary installations. It also supports embedding migration scripts directly into the compiled binary to eliminate external file dependencies during deployment.
The tool covers a broad range of database lifecycle management capabilities, including the generation of timestamped migration files, schema exporting, and the ability to poll for database availability. It provides automated version control through state tracking and supports CI/CD integration with features such as sensitive log redaction.
Features
- Database Schema Migrations - Executes versioned SQL scripts in numerical order to update the database schema independently of any application framework.
- Database Migration Tools - Provides a command-line tool for managing database schema changes using versioned SQL scripts independently of any application framework.
- Atomic Transaction Execution - Wraps individual migration blocks in database transactions to ensure atomic schema updates.
- Database Connection Configurations - Provides mechanisms to define target databases using connection URLs via flags, environment variables, or config files.
- Database Migrations - Manages versioned SQL scripts to update database structures across different environments without requiring a specific framework.
- Database Versioning - Tracks changes to database schemas over time via SQL exports and reversible migration scripts.
- Migration File Generation - Includes a utility for generating timestamped SQL files with dedicated apply and revert sections.
- Framework-Agnostic Managers - Provides a schema versioning utility that works across different programming languages by relying on raw SQL and connection URLs.
- File Sequencing - Ensures a deterministic execution sequence of schema changes by using timestamped SQL file prefixes.
- Containerized Migration Tooling - Allows executing schema changes via a Docker container image to avoid installing binaries on the host system.
- Migration State Tracking - Maintains a dedicated database table to track which migration versions have been applied to prevent duplicate runs.
- Transactional Migration Managers - Allows specifying whether migration blocks execute inside an atomic database transaction or as standalone operations.
- Availability Polling - Implements polling logic that waits for the database server to be reachable before proceeding with migrations.
- Containerized Database Administration - Provides a container-based approach to executing schema updates and lifecycle tasks without requiring local installations.
- Schema Exports - Dumps the current database structure into a single SQL file for version control and environment setup.
- Binary Embedding - A feature in the tool that integrates schema migration scripts directly into the application binary to eliminate external file dependencies during deployment.
- CI CD Pipelines - Automates schema updates in deployment pipelines, including database readiness checks and containerized execution.
- Database Lifecycle Management - Provides utilities for creating, dropping, and verifying the status of databases to ensure consistent environments.
- Database Readiness Polling - Pauses execution until the database server is reachable to prevent failures during automated deployments.
- Binary Asset Embedding - Provides the capability to bake migration scripts directly into the compiled executable binary for simpler deployments.
- Database Tools - Database migration tool.
- Schema Migration Tools - Lightweight, framework-agnostic database migration tool.
