pkg.soopen package index

brew / rank 8249

Install sqlancer with Homebrew

Detecting Logic Bugs in DBMS. Version 2.0.0 via Homebrew; verified from local package data.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sqlancer

local Homebrew formula metadata

overview

Package summary

Detecting Logic Bugs in DBMS

Commands and aliases

  • sqlancer

history

Project history and usage

SQLancer is an automated DBMS testing tool focused on finding logic and performance bugs in database systems. The official README states that it has found hundreds of bugs in mature and widely known DBMSs.

Project history

The GitHub repository was created in April 2020, around the publication period of SQLancer's core research techniques. Its documentation ties the implementation to Pivoted Query Synthesis, Non-optimizing Reference Engine Construction, Ternary Logic Partitioning, Query Plan Guidance, CERT, Differential Query Plans, and later CODDTest.

Adoption history

SQLancer moved from a research prototype into a packaged CLI distributed through GitHub releases, Maven Central, Docker Hub, and Homebrew. The README recommends using the latest source version but documents these release channels for users who need packaged artifacts.

How it is used

A typical source-build workflow clones the repository, runs Maven, then starts the jar with a DBMS target and oracle, for example SQLite with NoREC. The CLI is long-running by default, emits progress, stores reproduction logs under `target/logs`, and can be stopped manually or bounded with options such as timeout or number of tries.

Why package nerds care

Package nerds care about SQLancer because it is research-grade database fuzzing packaged as a normal Java command-line tool. It lets database maintainers, distro maintainers, and curious operators test real packaged DBMS builds for wrong-result bugs, not just crashes.

Timeline

  • 2020: GitHub repository created.
  • 2020: Papers for PQS, NoREC, and TLP established SQLancer's core logic-bug testing approaches.
  • 2021: Initial GitHub release v1.0 published.
  • 2021: v1.1.0 release added Docker Hub publishing.
  • 2022: v2.0.0 release added OceanBase and document-store component support.
  • 2025: README listed broad DBMS support including SQLite, PostgreSQL, MySQL, MariaDB, TiDB, DuckDB, ClickHouse, CockroachDB, and others.

Related projects

  • The README lists related tools and reimplementations including go-sqlancer, Jepsen, SQLRight, SQLsmith, and Squirrel. It also documents Maven, Docker Hub, and Maven Central distribution surfaces.

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 bottle metadata was recorded.

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
sqlancerexecutableindexed executableDiscovered from the local executable index.

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-08-03
manager version2.0.0
manager updated
local dataunknown
upstreamnot available
latest detectednot detected
  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:sqlancer
Version2.0.0
Package managerHomebrew
Homepagehttps://github.com/sqlancer/sqlancer
Repositoryhttps://github.com/sqlancer/sqlancer
Bottlenot recorded
Servicenone declared

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.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated package history
  • pkg.so package database
  • pkgdb category and tag curation