# sqlsmith を Homebrew, apt, pacman でインストール

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
- **パッケージマネージャページ:** <https://formulae.brew.sh/formula/sqlsmith>
- **バージョン:** 1.5
- **ソース概要:** Random SQL query generator
- **ホームページ:** <https://github.com/anse1/sqlsmith>
- **リポジトリ:** <https://github.com/anse1/sqlsmith>
- **ライセンス:** GPL-3.0-only
- **ソースアーカイブ:** <https://github.com/anse1/sqlsmith/archive/refs/tags/v1.5.tar.gz>
- **最終更新:** 2026-06-07T21:46:28Z
- **生成日時:** 2026-08-04T22:13:35+00:00

## 実行可能ファイル

- sqlsmith (cli)
- sqlsmith (エイリアス)

## 依存関係

- libpq
- libpqxx

## ビルド依存関係

- autoconf
- autoconf-archive
- automake
- pkgconf

## macOS 提供ライブラリ

- sqlite

## インストール挙動

- post-install フック: 未定義
- Bottle: 利用可能 対象 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## バージョンと鮮度

- ページ生成日: 2026-08-04
- マネージャ版: 1.5
- マネージャ更新日: 2026-06-07
- ローカルデータ: OK
- 上流リポジトリ: https://github.com/anse1/sqlsmith
- 検出された最新: v1.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

## ソースデータベース詳細

- **Source Database:** Homebrew formula API
- **Tap:** homebrew/core
- **Full Name:** sqlsmith
- **Version Scheme:** 0
- **Revision:** 1
- **Head Version:** HEAD
- **Bottle Stable Root URL:** <https://ghcr.io/v2/homebrew/core>
- **Deprecated:** no
- **Disabled:** no
- **Keg Only:** no
- **URL Keys:** head, stable

## 他のパッケージマネージャ記録

- 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


## 関連リンク

- [Source-control packages](https://pkg.so/ja/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://pkg.so/ja/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://pkg.so/ja/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://pkg.so/ja/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [libpq](https://pkg.so/ja/brew/libpq/) - Runtime dependency declared by Homebrew.
- [pkgconf](https://pkg.so/ja/brew/pkgconf/) - Build dependency declared by Homebrew.
- [autoconf](https://pkg.so/ja/brew/autoconf/) - Build dependency declared by Homebrew.
- [automake](https://pkg.so/ja/brew/automake/) - Build dependency declared by Homebrew.
- [dbmate](https://pkg.so/ja/brew/dbmate/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sql, sqlite.
- [sqlx-cli](https://pkg.so/ja/brew/sqlx-cli/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sql, sqlite.
- [pgformatter](https://pkg.so/ja/brew/pgformatter/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sql.
- [sqldiff](https://pkg.so/ja/brew/sqldiff/) - Shares pkgdb curated category or tags: cli, developer-tools, sql, sqlite.
- [postgres-language-server](https://pkg.so/ja/brew/postgres-language-server/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sql.
- [dblab](https://pkg.so/ja/brew/dblab/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sqlite.
- [atuin-server](https://pkg.so/ja/brew/atuin-server/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sqlite.
- [pg-schema-diff](https://pkg.so/ja/brew/pg-schema-diff/) - Shares pkgdb curated category or tags: cli, developer-tools, postgresql, sql.
- [sqlancer](https://pkg.so/ja/brew/sqlancer/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, database, database-testing, developer, developer-tools.

## 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
- package-page enrichment
- curated package history
- package version freshness
- pkgdb category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph