macOS
Homebrew已验证 · 100%
brew install sqlsmithlocal Homebrew formula metadata
安装
其他安装命令
Linux
Debian apt已验证 · 92%
sudo apt install sqlsmithDebian stable package indexes · sqlsmith · 来源: deb.debian.org
Arch Linux pacman已验证 · 92%
sudo pacman -S sqlsmithArch Linux sync databases · sqlsmith · 来源: geo.mirror.pkgbuild.com
概览
软件包摘要
Random SQL query generator
历史
项目历史与用法
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.
来源
安全态势
风险级别：blue
broad file, network, media, or database tool signal.
风险分类器
blue 风险 · 中 置信度 · tool
原因
- broad file, network, media, or database tool signal
信号
- text:sql
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 6 个平台目标。
- 安装时包含 2 个运行时依赖。
- 构建元数据列出 4 个构建依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
sqlsmith | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-07-25
管理器版本1.5
管理器更新时间2026-06-07
本地数据OK
上游当前
检测到的最新版本v1.5
https://github.com/anse1/sqlsmith
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:sqlsmith |
|---|---|
| 版本 | 1.5 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/sqlsmith |
| 主页 | https://github.com/anse1/sqlsmith |
| 仓库 | https://github.com/anse1/sqlsmith |
| 上游文档 | https://github.com/anse1/sqlsmith#readme |
| 许可证 | GPL-3.0-only |
| 源码归档 | https://github.com/anse1/sqlsmith/archive/refs/tags/v1.5.tar.gz |
| 最后更新 | 2026-06-07T21:46:28Z |
| Pulse | updated |
| 依赖 | libpq, libpqxx |
| 构建依赖 | autoconf, autoconf-archive, automake, pkgconf |
| macOS 提供的库 | sqlite |
| Bottle | 可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
注册表事实
源数据库详情
| 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 |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Debian apt95%
sqlsmith 1.4-1+b4
random SQL query generator
https://github.com/anse1/sqlsmith
sudo apt install sqlsmith- Section: database
- Architecture: amd64
- Source Package: sqlsmith
- 6 依赖
- normalized package name match
- 匹配方式：Sqlsmith
Ubuntu apt95%
sqlsmith 1.4-1build2
random SQL query generator
https://github.com/anse1/sqlsmith
sudo apt install sqlsmith- Section: universe/database
- Architecture: amd64
- 6 依赖
- normalized package name match
- 匹配方式：Sqlsmith
pacman95%
sqlsmith 1.5-1
A random SQL query generator
https://github.com/anse1/sqlsmith
sudo pacman -S sqlsmith- License: GPL-3.0-only
- Architecture: x86_64
- 6 依赖
- normalized package name match
- 匹配方式：Sqlsmith
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment