install

Additional install commands

macOS

Homebrewverified · 100%

brew install sqlboiler

local Homebrew formula metadata

Linux

Nixverified · 92%

nix profile install nixpkgs#sqlboiler

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

overview

Package summary

Generate a Go ORM tailored to your database schema

Project links

Commands and aliases

sqlboiler
sqlboiler-mssql
sqlboiler-mysql
sqlboiler-psql
sqlboiler-sqlite3

history

Project history and usage

SQLBoiler is a database-first Go ORM generator: users point it at an existing schema and it generates Go models, query helpers, and database-specific code rather than asking developers to describe the schema in Go structs.

Project history

The project appeared publicly on GitHub in 2016 and its first GitHub release was tagged v1.0.0 in September 2016. Its README explains that it grew out of an attempt to bring ActiveRecord-like productivity to Go while avoiding reflection-heavy, code-first ORM designs.

By the maintained v4 line, SQLBoiler had moved with the Go ecosystem toward Go modules; the README notes that v3 was the last GOPATH-compatible version and that v4 is the maintained version.

Adoption history

SQLBoiler became one of the recognizable Go database code-generation tools, especially for teams with existing PostgreSQL, MySQL, SQL Server, or SQLite schemas. The input package metadata lists Homebrew and Nix packaging, which reflects its use as an installable developer CLI rather than only a Go library.

How it is used

Typical use starts with a database schema and a sqlboiler.toml file, then runs the sqlboiler CLI with a database driver such as sqlboiler-psql, sqlboiler-mysql, sqlboiler-mssql, or sqlboiler-sqlite3 to regenerate models as the schema changes.

Why package nerds care

Package-manager users care about SQLBoiler because it is a classic generated-code CLI: installing the formula gives repeatable access to the generator and its driver commands without making every project vendor a local toolchain bootstrap step.

Timeline

2016: GitHub repository created.
2016: v1.0.0 tagged as the initial release.
v4 era: Go modules become the maintained line; v3 remains the last GOPATH-compatible line.
Current README: project is in maintenance mode and points active-development users toward alternatives such as Bob and sqlc.

Related projects

The README contrasts SQLBoiler with code-first Go ORMs such as gorm and gorp, and lists Bob and sqlc as alternatives for users who want active development or a non-ORM SQL compiler approach.

Sources

https://api.github.com/repos/aarondl/sqlboiler/releases
https://api.github.com/repos/volatiletech/sqlboiler
https://github.com/volatiletech/sqlboiler#readme
input.source_facts.package-manager

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:database,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: sqlboiler.toml$XDG_CONFIG_HOME/sqlboiler/sqlboiler.toml~/.config/sqlboiler/sqlboiler.toml

Credential files

Credential-bearing paths to review before unattended agent runs.

Unix: sqlboiler.toml$XDG_CONFIG_HOME/sqlboiler/sqlboiler.toml~/.config/sqlboiler/sqlboiler.toml

executables

Installed executables

Command	Kind	Exposure
`sqlboiler`	cli	global executable
`sqlboiler-mssql`	cli	global executable
`sqlboiler-mysql`	cli	global executable
`sqlboiler-psql`	cli	global executable
`sqlboiler-sqlite3`	cli	global 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-08

manager version4.19.7

manager updated2026-07-04

local dataok

upstreamcurrent

latest detectedv4.19.7

https://github.com/aarondl/sqlboiler

okNo freshness warnings were generated.

install metadata

Package metadata

Package key	brew:sqlboiler
Version	4.19.7
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/sqlboiler
Homepage	https://github.com/aarondl/sqlboiler
Repository	https://github.com/aarondl/sqlboiler
Upstream docs	https://github.com/volatiletech/sqlboiler#readme
License	BSD-3-Clause
Source archive	https://github.com/aarondl/sqlboiler/archive/refs/tags/v4.19.7.tar.gz
Last updated	2026-07-04T16:53:45+09:00
Pulse	updated
Build dependencies	go
Bottle	available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install	not defined
Service	none declared

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	sqlboiler
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

source database matches

Other package-manager records

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

Nix95%

sqlboiler

nix profile install nixpkgs#sqlboiler

normalized package name match
Matched by: Sqlboiler

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

package graph

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

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.

Combined YAML source

View the package source record on GitHub.

combined/sqlboiler.yml

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

Install sqlboiler with Homebrew, Nix