macOS
Homebrewverified · 100%
brew install sqlancerlocal Homebrew formula metadata
brew
Install sqlancer with Homebrew
Detecting Logic Bugs in DBMS. Version 2.0.0 via Homebrew; verified from local package data.
install
Additional install commands
overview
Package summary
Detecting Logic Bugs in DBMS
Project links
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.
Sources
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 13 platform targets.
- Installs with 1 runtime dependencies.
- 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.
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
sqlancer | 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 version2.0.0
manager updated
local dataok
upstreamcurrent
latest detectedv2.0.0
https://github.com/sqlancer/sqlancer
- infoNo package-manager update timestamp was available.low confidence
install metadata
Package metadata
| Package key | brew:sqlancer |
|---|---|
| Version | 2.0.0 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/sqlancer |
| Homepage | https://github.com/sqlancer/sqlancer |
| Repository | https://github.com/sqlancer/sqlancer |
| Upstream docs | https://github.com/sqlancer/sqlancer#readme |
| License | MIT |
| Source archive | https://github.com/sqlancer/sqlancer/archive/refs/tags/v2.0.0.tar.gz |
| Dependencies | openjdk |
| Build dependencies | maven |
| Bottle | available (on arm64_big_sur, arm64_linux, arm64_monterey, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, big_sur, catalina, monterey, sonoma, ventura, 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 | sqlancer |
| 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 |
|
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.
Used sources
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated package history
- package relationship graph
- package version freshness
- package-page enrichment