dbmate Lightweight Database Migration CLI

dbmate Lightweight Database Migration CLI

dbmate is a standalone, framework-agnostic database migration tool that uses plain SQL files. It supports PostgreSQL, MySQL, SQLite, ClickHouse, BigQuery, and Spanner, and works with any programming language or framework.

Installation

Use the upstream install or setup path that matches your environment:

• npm install --save-dev dbmate
• npx dbmate --help
• brew install dbmate
• Docker images are published to GitHub Container Registry (ghcr.io/amacneil/dbmate).

Requirements and caveats from upstream:

• It is a standalone command line tool that can be used with Go, Node.js, Python, Ruby, PHP, Rust, C++, or any other language or framework you are using to write database-backed applications. This is especially helpful...
• Docker
• Remember to set --network=host or see this comment for more tips on using dbmate with docker networking):

Basic usage or getting-started notes:

• Usage

• Migrations are run atomically inside a transaction

• NPM

• Source: https://github.com/amacneil/dbmate

• Extracted from upstream docs: https://raw.githubusercontent.com/amacneil/dbmate/HEAD/README.md

Source

• Agent Skill Exchange