Automic VaultAutomic Vault

brew

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 commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sql-migrate

local Homebrew formula metadata

Linux

Debian aptverified · 92%
sudo apt install sql-migrate

Debian stable package indexes · sql-migrate · source: deb.debian.org

Nixverified · 92%
nix profile install nixpkgs#sql-migrate

nixpkgs package indexes · pkgs/by-name/sq/sql-migrate/package.nix · source: api.github.com

overview

Package summary

SQL schema migration tool for Go

Commands and aliases

  • sql-migrate

history

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.

security posture

Risk level: blue

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

Risk classifier

blue risk · medium confidence · tool

Why

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

Signals

  • text:sql

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 6 platform targets.
  • Build metadata lists 1 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

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

Config paths the tool may read or write during local use.

Unix
dbconfig.yml

Credential files

Credential-bearing paths to review before unattended agent runs.

Unix
dbconfig.yml

executables

Installed executables

CommandKindExposureNote
sql-migratecliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-07-07
manager version1.8.1
manager updated
local dataok
upstreamcurrent
latest detectedv1.8.1

https://github.com/rubenv/sql-migrate

  • infoNo package-manager update timestamp was available.low confidence

install metadata

Package metadata

Package keybrew:sql-migrate
Version1.8.1
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/sql-migrate
Homepagehttps://github.com/rubenv/sql-migrate
Repositoryhttps://github.com/rubenv/sql-migrate
Upstream docshttps://github.com/rubenv/sql-migrate#readme
LicenseMIT
Source archivehttps://github.com/rubenv/sql-migrate/archive/refs/tags/v1.8.1.tar.gz
Build dependenciesgo
Bottleavailable (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namesql-migrate
Version Scheme0
Revision0
Head VersionHEAD
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • head
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

sql-migrate 0.0~git20191213.0633851-3+b16

SQL schema migration tool for Go (program)

https://github.com/rubenv/sql-migrate

sudo apt install sql-migrate
  • Section: devel
  • Architecture: amd64
  • Source Package: golang-github-rubenv-sql-migrate
  • 2 dependencies
  • normalized package name match
  • Matched by: Sql Migrate
Debian stable package indexes · deb.debian.org · Debian stable package indexes: sql-migrate from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Nix95%

sql-migrate

nix profile install nixpkgs#sql-migrate
  • normalized package name match
  • Matched by: Sql Migrate
nixpkgs package indexes · api.github.com · 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 apt95%

sql-migrate 0.0~git20191213.0633851-3build1

SQL schema migration tool for Go (program)

https://github.com/rubenv/sql-migrate

sudo apt install sql-migrate
  • Section: universe/devel
  • Architecture: amd64
  • Source Package: golang-github-rubenv-sql-migrate
  • 2 dependencies
  • normalized package name match
  • Matched by: Sql Migrate
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: sql-migrate from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

Related tools

  • goBuild dependency declared by Homebrew.
  • sql-translatorPackage names and metadata indicate a similar tool family. Shared terms: cli, database, developer, developer-tools, schema.

Same workflow

  • golang-migrateShares av.db curated category or tags: cli, database, developer-tools, go, migrations.
  • dbmateShares av.db curated category or tags: cli, database, database-migrations, developer-tools, sql.
  • jetShares av.db curated category or tags: cli, database, developer-tools, go, sql.
  • sqlboilerShares av.db curated category or tags: cli, database, developer-tools, go, sql.
  • sqlcShares av.db curated category or tags: cli, database, developer-tools, go, sql.
  • dbml-cliShares av.db curated category or tags: cli, database, developer-tools, sql.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

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