beanquery ☆

« Back to VersTracker

Description:
Customizable lightweight SQL query tool

Type: Formula | Latest Version: 0.2.0@0 | Tracked Since: Dec 17, 2025

Links: Homepage | formulae.brew.sh

Category: Productivity

Tags: finance sql accounting beancount cli

Install: brew install beanquery

About:
Beanquery is a customizable SQL query tool designed for querying financial data stored in the Beancount format. It allows users to execute standard SQL queries against their plain-text accounting ledgers, effectively bridging the gap between double-entry bookkeeping and relational database analysis. The tool supports extensibility through user-defined functions and custom column types.

Key Features:

SQL interface for Beancount ledgers
Customizable with user-defined functions
Supports standard SQL syntax and aggregation
Lightweight and command-line based

Use Cases:

Generating custom financial reports from Beancount data
Analyzing spending habits and budget adherence via SQL
Integrating accounting data into external data pipelines

Alternatives:

fava – Fava provides a web-based UI and built-in charts, whereas beanquery offers a CLI SQL interface for data extraction.
beancount – The core beancount CLI focuses on validation and text editing, while beanquery specifically enables SQL querying capabilities.

Version History

Detected	Version	Rev	Change	Commit
Sep 13, 2025 12:56pm		0	VERSION_BUMP	e6568422