# 使用 Homebrew 安装 sqlancer

查看 sqlancer 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。

## 安装

```sh
sudo av install brew:sqlancer
```

其他安装命令:

### macOS

- Homebrew (100%):

```sh
brew install sqlancer
```

  证据: local Homebrew formula metadata

## 软件包事实

- **软件包键:** brew:sqlancer
- **软件包管理器:** Homebrew
- **版本:** 2.0.0
- **来源摘要:** Detecting Logic Bugs in DBMS
- **主页:** <https://github.com/sqlancer/sqlancer>
- **仓库:** <https://github.com/sqlancer/sqlancer>
- **已生成:** 2026-08-03T19:37:03+00:00

## 可执行文件

- sqlancer (别名)

## 安装行为

- Bottle: 不可用

## 版本和新鲜度

- 页面生成时间: 2026-08-03
- 管理器版本: 2.0.0
## 项目历史与用法

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.

### 项目历史

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.

### 采用历史

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.

### 使用方式

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.

### 为什么软件包爱好者会关心

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.

### 时间线

- 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.

### 来源

- <https://api.github.com/repos/sqlancer/sqlancer>
- <https://api.github.com/repos/sqlancer/sqlancer/releases>
- <https://github.com/sqlancer/sqlancer#readme>
- <https://github.com/sqlancer/sqlancer/blob/main/docs/PAPERS.md>


## 安全说明

broad file, network, media, or database tool signal.

- **Geiger 风险:** blue / 中
- broad file, network, media, or database tool signal


## Combined YAML source

View the package source record on GitHub. [combined/sqlancer.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlancer.yml)


## 来源

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