# 使用 Homebrew, apt, pacman 安装 sqlsmith

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

## 安装

```sh
sudo av install brew:sqlsmith
```

其他安装命令:

### macOS

- Homebrew (100%):

```sh
brew install sqlsmith
```

  证据: local Homebrew formula metadata

### Linux

- Debian apt (92%):

```sh
sudo apt install sqlsmith
```

  证据: Debian stable package indexes: sqlsmith from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz

- pacman (92%):

```sh
sudo pacman -S sqlsmith
```

  证据: Arch Linux sync databases: sqlsmith from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz

## 软件包事实

- **软件包键:** brew:sqlsmith
- **软件包管理器:** Homebrew
- **版本:** 1.5
- **来源摘要:** Random SQL query generator
- **主页:** <https://github.com/anse1/sqlsmith>
- **仓库:** <https://github.com/anse1/sqlsmith>
- **最后更新:** 2026-06-07T21:46:28Z
- **已生成:** 2026-08-03T19:37:03+00:00

## 可执行文件

- sqlsmith (别名)

## 安装行为

- Bottle: 不可用

## 版本和新鲜度

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

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

### 项目历史

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.

### 采用历史

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.

### 使用方式

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.

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

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.

### 时间线

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

### 来源

- <https://github.com/anse1/sqlsmith>
- <https://github.com/anse1/sqlsmith/releases>
- <https://github.com/anse1/sqlsmith/wiki#score-list>
- source_facts.package-manager


## 安全说明

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

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

## 其他软件包管理器记录

- Debian apt - sqlsmith - 1.4-1+b4: normalized package name match | Debian stable package indexes: sqlsmith from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | random SQL query generator | https://github.com/anse1/sqlsmith
- Ubuntu apt - sqlsmith - 1.4-1build2: normalized package name match | Ubuntu 24.04 LTS package indexes: sqlsmith from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | random SQL query generator | https://github.com/anse1/sqlsmith
- pacman - sqlsmith - 1.5-1: normalized package name match | Arch Linux sync databases: sqlsmith from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz | A random SQL query generator | https://github.com/anse1/sqlsmith


## Combined YAML source

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


## 来源

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