Skip to content

finance_query, read-only finance answers in chat

forge/scripts/forge_finance_query.py, shipped 2026-06-09. Coordinator brain tool finance_query(question_type, month=None):

  • monthly_spend: spend by category for a month (default current, local TZ), excludes Transfer + Credit Card Payment categories.
  • recurring: active recurring outflows (status confirmed/detected) with monthlyized total.
  • net_worth: live compute, parity-verified to the dollar against forge_finance_networth.networth_sections (kind-based bucketing, GOC at 40%).

Strict sqlite3.connect("file:...?mode=ro", uri=True); never writes (finance sessions own the DB, see forge/data/finance/COORDINATION.md). Net-worth logic intentionally duplicated read-only because the canonical module connects rw via forge_finance_db. Output via mono_table/kv_block ([[feedback_telegram_no_tables]]). CLI: python3 scripts/forge_finance_query.py net_worth.

[Claude Code]