macOS
Homebrewverified · 100%
brew install beanquerylocal Homebrew formula metadata
brew
Install beanquery with Homebrew, apt, Nix
Customizable lightweight SQL query tool. Version 0.2.0 via Homebrew; verified from local package data.
install
Additional install commands
Linux
Debian aptverified · 92%
sudo apt install python3-beanqueryDebian stable package indexes · python3-beanquery · source: deb.debian.org
Nixverified · 92%
nix profile install nixpkgs#beanquerynixpkgs package indexes · beanquery · source: raw.githubusercontent.com
overview
Package summary
Customizable lightweight SQL query tool
Project links
Commands and aliases
- bean-query
history
Project history and usage
beanquery is a lightweight SQL-like query tool for tabular data, especially Beancount ledger data.
Project history
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.
Adoption history
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.
How it is used
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.
Why package nerds care
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.
Timeline
- 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.
Sources
- 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
security posture
Risk level: blue
broad file, network, media, or database tool signal.
Risk classifier
blue risk · medium confidence · tool
Why
- broad file, network, media, or database tool signal
Signals
- text:sql
Install behavior
- No Homebrew post-install hook is recorded in formula metadata.
- Homebrew bottle metadata is available for 6 platform targets.
- Installs with 1 runtime dependencies.
- Build metadata lists 3 build dependencies.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
bean-query | cli | global executable |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-07-08
manager version0.2.0
manager updated
local dataok
upstreamnot checked
latest detectednot detected
https://github.com/beancount/beanquery
- infoNo package-manager update timestamp was available.low confidence
- infoNo cached GitHub release or tag data was available.https://github.com/beancount/beanquerynone confidence
install metadata
Package metadata
| Package key | brew:beanquery |
|---|---|
| Version | 0.2.0 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/beanquery |
| Homepage | https://github.com/beancount/beanquery |
| Repository | https://github.com/beancount/beanquery |
| Upstream docs | https://github.com/beancount/beanquery#readme |
| License | GPL-2.0-only |
| Source archive | https://files.pythonhosted.org/packages/7c/90/801eec23a07072dcf8df061cb6f27be6045e08c12a90b287e872ce0a12d3/beanquery-0.2.0.tar.gz |
| Dependencies | python@3.14 |
| Build dependencies | bison, meson, ninja |
| Bottle | available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | not defined |
| Service | none declared |
registry facts
Source database details
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | beanquery |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
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 dependencies
- 1 provides
- normalized package name match
- Matched by: Beanquery
Nix95%
beanquery
nix profile install nixpkgs#beanquery- normalized package name match
- Matched by: Beanquery
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- 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