Automic VaultAutomic Vault

brew

Install sqlsmith with Homebrew, apt, pacman

Random SQL query generator. Version 1.5 via Homebrew; verified 2026-06-07.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sqlsmith

local Homebrew formula metadata

overview

Package summary

Random SQL query generator

Commands and aliases

  • sqlsmith

history

Project history and usage

SQLsmith is a random SQL query generator used for database fuzz testing and benchmarking.

Project history

The official README describes SQLsmith as a random SQL query generator whose paragon is Csmith, the random C program generator used for compiler quality assurance. The first GitHub release, SQLsmith 1.0, was published on May 30 after development that had already found about thirty PostgreSQL bugs.

Version 1.0 targeted PostgreSQL 9.5 or later. Later official release notes document a broader scope, including version 1.2 adding SQLite3 and MonetDB support, support for older PostgreSQL releases, automatic blacklisting of unsupported grammar, and grammar improvements.

Adoption history

The README states that since 2015 SQLsmith found 118 bugs in alphas, betas, and releases of supported database products, including security vulnerabilities, plus bugs in extensions and libraries. The supplied package-manager facts show distribution through Homebrew, Debian, Ubuntu, and Arch.

How it is used

SQLsmith connects to a target database, reads schema information, generates random SQL, sends it to the database, and rolls statements back. The README documents PostgreSQL, SQLite, and MonetDB invocations, logging with --log-to, verbose progress output, seeds, dry runs, and large-scale testing support.

Why package nerds care

Package nerds care about SQLsmith because it turns database fuzzing into an installable CLI. It is useful to database hackers, distro maintainers, and extension authors who want randomized workload generation without building a custom fuzzer for every database target.

Timeline

  • 2015: README says SQLsmith began finding bugs in supported database products.
  • 2016: SQLsmith 1.0 release notes describe PostgreSQL fuzz testing and about thirty bugs found during development.
  • 2018: SQLsmith 1.2 release notes add SQLite3 and MonetDB support.
  • 2026: Repository release list shows SQLsmith 1.5 as latest.

Related projects

  • The official README explicitly relates SQLsmith to Csmith and supports PostgreSQL, SQLite3, and MonetDB targets.

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.
  • Installs with 2 runtime dependencies.
  • Build metadata lists 4 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.

executables

Installed executables

CommandKindExposureNote
sqlsmithcliglobal 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.5
manager updated2026-06-07
local dataok
upstreamcurrent
latest detectedv1.5

https://github.com/anse1/sqlsmith

  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:sqlsmith
Version1.5
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/sqlsmith
Homepagehttps://github.com/anse1/sqlsmith
Repositoryhttps://github.com/anse1/sqlsmith
Upstream docshttps://github.com/anse1/sqlsmith#readme
LicenseGPL-3.0-only
Source archivehttps://github.com/anse1/sqlsmith/archive/refs/tags/v1.5.tar.gz
Last updated2026-06-07T21:46:28Z
Pulseupdated
Dependencieslibpq, libpqxx
Build dependenciesautoconf, autoconf-archive, automake, pkgconf
Uses from macOSsqlite
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 Namesqlsmith
Version Scheme0
Revision1
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%

sqlsmith 1.4-1+b4

random SQL query generator

https://github.com/anse1/sqlsmith

sudo apt install sqlsmith
  • Section: database
  • Architecture: amd64
  • Source Package: sqlsmith
  • 6 dependencies
  • normalized package name match
  • Matched by: Sqlsmith
Debian stable package indexes · deb.debian.org · Debian stable package indexes: sqlsmith from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Ubuntu apt95%

sqlsmith 1.4-1build2

random SQL query generator

https://github.com/anse1/sqlsmith

sudo apt install sqlsmith
  • Section: universe/database
  • Architecture: amd64
  • 6 dependencies
  • normalized package name match
  • Matched by: Sqlsmith
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: sqlsmith from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz
pacman95%

sqlsmith 1.5-1

A random SQL query generator

https://github.com/anse1/sqlsmith

sudo pacman -S sqlsmith
  • License: GPL-3.0-only
  • Architecture: x86_64
  • 6 dependencies
  • normalized package name match
  • Matched by: Sqlsmith
Arch Linux sync databases · geo.mirror.pkgbuild.com · Arch Linux sync databases: sqlsmith from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz

package graph

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

Related tools

  • libpqRuntime dependency declared by Homebrew.
  • autoconfBuild dependency declared by Homebrew.
  • automakeBuild dependency declared by Homebrew.
  • pkgconfBuild dependency declared by Homebrew.

Same workflow

  • sqlx-cliShares av.db curated category or tags: cli, databases, developer-tools, postgresql, sql.
  • sqlancerShares av.db curated category or tags: cli, database-testing, developer-tools, sql, testing.
  • dbmateShares av.db curated category or tags: cli, developer-tools, postgresql, sql, sqlite.
  • tsungShares av.db curated category or tags: cli, developer-tools, postgresql, testing.
  • abnfgenShares av.db curated category or tags: cli, developer-tools, testing.
  • allureShares av.db curated category or tags: cli, developer-tools, testing.

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 package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment