# Install sql-migrate with Homebrew, apt, Nix

SQL schema migration tool for Go. Version 1.8.1 via Homebrew; verified from local package data.

## Install

```sh
sudo av install brew:sql-migrate
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install sql-migrate
```

  Evidence: local Homebrew formula metadata

### Linux

- Debian apt (92%):

```sh
sudo apt install sql-migrate
```

  Evidence: Debian stable package indexes: sql-migrate from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz

- Nix (92%):

```sh
nix profile install nixpkgs#sql-migrate
```

  Evidence: nixpkgs package indexes: pkgs/by-name/sq/sql-migrate/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

## Package facts

- **Package key:** brew:sql-migrate
- **Package manager:** Homebrew
- **Package manager page:** <https://formulae.brew.sh/formula/sql-migrate>
- **Version:** 1.8.1
- **Source summary:** SQL schema migration tool for Go
- **Homepage:** <https://github.com/rubenv/sql-migrate>
- **Repository:** <https://github.com/rubenv/sql-migrate>
- **Upstream docs:** <https://github.com/rubenv/sql-migrate#readme>
- **License:** MIT
- **Source archive:** <https://github.com/rubenv/sql-migrate/archive/refs/tags/v1.8.1.tar.gz>
- **Generated:** 2026-07-08T07:18:31+00:00

## Executables

- sql-migrate (cli)
- sql-migrate (alias)

## Build dependencies

- go

## Install behavior

- Post-install hook: not defined
- Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## Freshness

- Page generated: 2026-07-08
- Package-manager version: 1.8.1
- Local data: ok
- Upstream repository: https://github.com/rubenv/sql-migrate
- Upstream latest detected: v1.8.1 (current)
- info: No package-manager update timestamp was available.
## Project history and usage

sql-migrate is a Go SQL schema migration tool that can be used as either a standalone CLI or an importable Go library. Its README describes it as based on gorp and goose, with migrations written directly in SQL.

### Project history

The public GitHub repository was created in September 2014, in the period when Go database tooling was maturing around small command-line programs and libraries. The project kept the classic migration commands: `up`, `down`, `redo`, `status`, and `new`.

### Adoption history

The project accumulated broad package-manager availability in the supplied package facts, including Homebrew, Debian, Ubuntu, and Nix. Its GitHub repository also shows thousands of stars, indicating durable use beyond a single distribution channel.

### How it is used

As a CLI, sql-migrate reads `dbconfig.yml` by default, selects an environment with `-env`, and applies or rolls back SQL migration files. As a Go library, it can run migrations from memory, a folder, embedded assets, or an HTTP filesystem, which made it useful for Go applications that wanted migration logic inside the binary.

### Why package nerds care

For package-manager culture, sql-migrate represents the Go tradition of shipping one small static-ish executable that can also serve as a library. Package maintainers care because database migration tools sit in deployment paths, and users often want the exact same binary available in local development, CI, and server provisioning.

### Timeline

- 2014: GitHub repository created.
- 2014: README examples show migration status output and timestamped SQL migration files.
- 2020s: README documents Go module-era installation with `go install ...@latest` for Go 1.18 and later.
- 2026: Repository remained active according to GitHub metadata.

### Related projects

- The README explicitly says sql-migrate is based on gorp and goose and works well with sqlx. It also documents database drivers for SQLite, PostgreSQL, MySQL, MSSQL, and Oracle.

### Sources

- <https://api.github.com/repos/rubenv/sql-migrate>
- <https://github.com/rubenv/sql-migrate#readme>
- <https://pkg.go.dev/github.com/rubenv/sql-migrate>
- source_facts.package-manager


## Security Notes

broad file, network, media, or database tool signal.

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal


## Configuration and credential file locations

These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.


## Configuration files

- Unix: dbconfig.yml

## Credential files

- Unix: dbconfig.yml
## Source Database Details

- **Source Database:** Homebrew formula API
- **Tap:** homebrew/core
- **Full Name:** sql-migrate
- **Version Scheme:** 0
- **Revision:** 0
- **Head Version:** HEAD
- **Bottle Stable Root URL:** <https://ghcr.io/v2/homebrew/core>
- **Deprecated:** no
- **Disabled:** no
- **Keg Only:** no
- **URL Keys:** head, stable

## Other Package-Manager Records

- Debian apt - sql-migrate - 0.0~git20191213.0633851-3+b16: normalized package name match | Debian stable package indexes: sql-migrate from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | SQL schema migration tool for Go (program) | https://github.com/rubenv/sql-migrate
- Nix - sql-migrate: normalized package name match | nixpkgs package indexes: pkgs/by-name/sq/sql-migrate/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
- Ubuntu apt - sql-migrate - 0.0~git20191213.0633851-3build1: normalized package name match | Ubuntu 24.04 LTS package indexes: sql-migrate from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | SQL schema migration tool for Go (program) | https://github.com/rubenv/sql-migrate


## Related links

- [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [go](https://www.automicvault.com/pkg/brew/go/) - Build dependency declared by Homebrew.
- [golang-migrate](https://www.automicvault.com/pkg/brew/golang-migrate/) - Shares av.db curated category or tags: cli, database, developer-tools, go, migrations.
- [dbmate](https://www.automicvault.com/pkg/brew/dbmate/) - Shares av.db curated category or tags: cli, database, database-migrations, developer-tools, sql.
- [jet](https://www.automicvault.com/pkg/brew/jet/) - Shares av.db curated category or tags: cli, database, developer-tools, go, sql.
- [sqlboiler](https://www.automicvault.com/pkg/brew/sqlboiler/) - Shares av.db curated category or tags: cli, database, developer-tools, go, sql.
- [sqlc](https://www.automicvault.com/pkg/brew/sqlc/) - Shares av.db curated category or tags: cli, database, developer-tools, go, sql.
- [dbml-cli](https://www.automicvault.com/pkg/brew/dbml-cli/) - Shares av.db curated category or tags: cli, database, developer-tools, sql.
- [harlequin](https://www.automicvault.com/pkg/brew/harlequin/) - Shares av.db curated category or tags: cli, database, developer-tools, sql.
- [pg-schema-diff](https://www.automicvault.com/pkg/brew/pg-schema-diff/) - Shares av.db curated category or tags: cli, database, developer-tools, sql.
- [sql-translator](https://www.automicvault.com/pkg/brew/sql-translator/) - Package names and metadata indicate a similar tool family. Shared terms: cli, database, developer, developer-tools, schema.

## Combined YAML source

View the package source record on GitHub. [combined/sql-migrate.yml](https://github.com/automic-vault/db/blob/main/combined/sql-migrate.yml)


## Sources

- Nucleus package database
- Geiger risk classifier
- package-page enrichment
- curated configuration and credential file locations
- curated package history
- package version freshness
- av.db category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph
