install

Additional install commands

macOS

Homebrewverified · 100%

brew install sqlc

local Homebrew formula metadata

MacPortsverified · 94%

sudo port install sqlc

MacPorts ports tree · devel/sqlc/Portfile · source: api.github.com

Linux

Nixverified · 92%

nix profile install nixpkgs#sqlc

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

Arch Linux pacmanverified · 92%

sudo pacman -S sqlc

Arch Linux sync databases · sqlc · source: geo.mirror.pkgbuild.com

Windows

Scoopverified · 92%

scoop install main/sqlc

Scoop official bucket manifest trees · bucket/sqlc.json · source: api.github.com

overview

Package summary

Generate type safe Go from SQL

Project links

Commands and aliases

sqlc

history

Project history and usage

sqlc is a command-line SQL compiler that generates type-safe application code from handwritten SQL queries. It began in the Go ecosystem and later expanded its generator model beyond Go.

Project history

The sqlc repository was created in 2019. Its first public GitHub release, v0.1.0, appeared in January 2020, followed by v1.0.0 in February 2020.

The project documentation now describes a configuration-driven compiler with support for PostgreSQL, MySQL, and SQLite inputs, plus generator plugins for languages beyond the original Go target.

Adoption history

sqlc found a niche among developers who wanted to keep SQL as the source of truth while avoiding hand-written row scanning and fragile stringly typed database code. The input package metadata lists Homebrew, MacPorts, Nix, Arch, and Scoop packaging, showing broad CLI distribution across Unix-like and Windows package-manager ecosystems.

How it is used

A common workflow is to write schema and query SQL files, configure them in sqlc.yaml, sqlc.yml, or sqlc.json, and run sqlc to produce typed query methods used by application code.

Why package nerds care

Package nerds care about sqlc because it turns SQL into a build-time artifact. It fits neatly into reproducible developer environments, CI checks, and generated-code workflows without requiring a running ORM runtime.

Timeline

2019: GitHub repository created.
2020: v0.1.0 released.
2020: v1.0.0 released.
Current docs: configuration centers on sqlc.(yaml|yml) or sqlc.json and supports plugins and multiple language targets.

Related projects

The SQLBoiler README lists sqlc as an alternative for users who want type-safe SQL-generated code without an ORM model. sqlc's own README lists sqlc-gen-go, sqlc-gen-kotlin, sqlc-gen-python, and sqlc-gen-typescript as supported language generator projects.

Sources

https://api.github.com/repos/sqlc-dev/sqlc
https://api.github.com/repos/sqlc-dev/sqlc/releases
https://docs.sqlc.dev/en/stable/reference/config.html
https://github.com/sqlc-dev/sqlc#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: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: sqlc.yamlsqlc.ymlsqlc.json

executables

Installed executables

Command	Kind	Exposure	Note
`sqlc`	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 version1.31.1

manager updated2026-04-22

local dataok

upstreamcurrent

latest detectedv1.31.1

https://github.com/sqlc-dev/sqlc

okNo freshness warnings were generated.

install metadata

Package metadata

Package key	brew:sqlc
Version	1.31.1
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/sqlc
Homepage	https://sqlc.dev/
Repository	https://github.com/sqlc-dev/sqlc
Upstream docs	https://docs.sqlc.dev/en/stable
License	MIT
Source archive	https://github.com/sqlc-dev/sqlc/archive/refs/tags/v1.31.1.tar.gz
Last updated	2026-04-22T16:58:03Z
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	sqlc
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%

sqlc

nix profile install nixpkgs#sqlc

normalized package name match
Matched by: Sqlc

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

pacman95%

sqlc 1.31.1-1

Compile SQL to type-safe Go

https://sqlc.dev

sudo pacman -S sqlc

License: MIT
Architecture: x86_64
1 dependencies
normalized package name match
Matched by: Sqlc

Arch Linux sync databases · geo.mirror.pkgbuild.com · Arch Linux sync databases: sqlc from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz

MacPorts95%

sqlc

sudo port install sqlc

normalized package name match
Matched by: Sqlc

MacPorts ports tree · api.github.com · MacPorts ports tree: devel/sqlc/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

Scoop95%

main/sqlc

scoop install main/sqlc

normalized package name match
Matched by: Sqlc

Scoop official bucket manifest trees · api.github.com · Scoop official bucket manifest trees: bucket/sqlc.json from https://api.github.com/repos/ScoopInstaller/Main/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/sqlc.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 sqlc with Homebrew, MacPorts, Nix, pacman, scoop