npm

beanquery

Customizable lightweight SQL query tool for financial data

brewmacoslinux

Try with needOr install directly

Source

About

Customizable lightweight SQL query tool

Commands

bean-query

Examples

Query transactions from a Beancount ledger file

$ bean-query myledger.beancount "SELECT account, sum(position.number) as total WHERE account ~ 'Assets' GROUP BY account"

Interactive mode to explore ledger data with SQL queries$ bean-query myledger.beancount

Calculate total expenses by category for a date range

$ bean-query myledger.beancount "SELECT account, sum(position.number) as amount WHERE account ~ 'Expenses' AND date >= 2024-01-01 AND date <= 2024-12-31 GROUP BY account ORDER BY amount DESC"