macOS
Homebrew已验证 · 100%
brew install beanquerylocal Homebrew formula metadata
安装
其他安装命令
Linux
Nix已验证 · 92%
nix profile install nixpkgs#beanquerynixpkgs package indexes · beanquery · 来源: raw.githubusercontent.com
Debian apt已验证 · 92%
sudo apt install python3-beanqueryDebian stable package indexes · python3-beanquery · 来源: deb.debian.org
概览
软件包摘要
Customizable lightweight SQL query tool
历史
项目历史与用法
beanquery is a lightweight SQL-like query tool for tabular data, especially Beancount ledger data.
项目历史
Beancount's query-language documentation describes bean-query as a custom SQL-like client created because plain SQLite export was awkward for Beancount's inventory and lot-aware accounting model.
The current beanquery repository presents it as a standalone, customizable, extensible SQL query tool that works on tabular data including Beancount ledgers.
采用历史
beanquery is mainly adopted as part of the Beancount ecosystem. The supplied package metadata shows it packaged for Homebrew, Debian as python3-beanquery, and Nix.
使用方式
The Beancount docs show bean-query running interactively on a ledger file or receiving a query directly on the command line, for example to produce balances, journals, and custom accounting reports.
为什么软件包爱好者会关心
beanquery is the small-tool companion to Beancount: it turns ledger data into queryable tabular output without requiring users to flatten accounting inventories into a general SQL database first.
时间线
- 2014: Beancount documentation says about 70 percent of the planned query-language features were implemented and the first iteration was merged.
- 2021: The official GitHub repository for beanquery was created as a separate project.
- 2024: Beancount v3's README describes former v2 tools moving into independent GitHub projects, matching beanquery's standalone packaging role.
Related projects
- Beancount is the primary related project. The tool also overlaps conceptually with SQL shells and Beancount's older SQLite-export experiments.
来源
- https://beancount.github.io/docs/beancount_query_language/
- https://github.com/beancount/beancount#readme
- https://github.com/beancount/beanquery#readme
- input.json source_facts.package-manager
安全态势
风险级别：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 个平台目标。
- 安装时包含 1 个运行时依赖。
- 构建元数据列出 3 个构建依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
bean-query | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-07-25
管理器版本0.2.0
管理器更新时间2026-07-13
本地数据OK
上游not checked
检测到的最新版本未检测到
https://github.com/beancount/beanquery
- 信息No cached GitHub release or tag data was available.https://github.com/beancount/beanquerynone 置信度
安装元数据
软件包元数据
| 软件包键 | brew:beanquery |
|---|---|
| 版本 | 0.2.0 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/beanquery |
| 主页 | https://github.com/beancount/beanquery |
| 仓库 | https://github.com/beancount/beanquery |
| 上游文档 | https://github.com/beancount/beanquery#readme |
| 许可证 | GPL-2.0-only |
| 源码归档 | https://files.pythonhosted.org/packages/7c/90/801eec23a07072dcf8df061cb6f27be6045e08c12a90b287e872ce0a12d3/beanquery-0.2.0.tar.gz |
| 最后更新 | 2026-07-13T12:20:50Z |
| Pulse | updated |
| 依赖 | python@3.14 |
| 构建依赖 | bison, meson, ninja |
| 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 | beanquery |
| Version Scheme | 0 |
| Revision | 1 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Debian apt95%
python3-beanquery 0.2.0-1
Customizable lightweight SQL query tool (Python 3)
https://github.com/beancount/beanquery
sudo apt install python3-beanquery- Section: python
- Architecture: amd64
- Source Package: beanquery
- 5 依赖
- 1 提供
- normalized package name match
- 匹配方式：Beanquery
Nix95%
beanquery
nix profile install nixpkgs#beanquery- normalized package name match
- 匹配方式：Beanquery
来源线索
由仓库数据生成
此页面由 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