AgentSkillsCN

opengasti-query

支持用西班牙语自然语言查询 BeanCount 个人理财。将西班牙语问题翻译为 BQL，并通过 bean-query 执行。可用于诸如“我这个月花了多少钱”、“按类别统计支出”、“最近的交易”等查询。触发词：‘/query’、‘cuánto’、‘gasté’、‘ingresos’、‘gastos’。

SKILL.md
--- frontmatter
name: opengasti-query
description: Natural language queries for beancount personal finance. Translates Spanish questions to BQL and executes with bean-query. Use for queries like 'cuánto gasté este mes', 'gastos por categoría', 'transacciones recientes'. Triggers: '/query', 'cuánto', 'gasté', 'ingresos', 'gastos'.

opengasti-query

Natural language interface for querying your personal finances in Beancount.

Workflow

  1. •Parse Spanish question: Identify the intent (expenses, income, net worth, etc.) and time period.
  2. •Translate to BQL: Map the intent to a Beancount Query Language (BQL) statement or a pre-defined query name.
  3. •Execute: Run the query using the uv run prefix.
    bash
    uv run bean-query main.bean "QUERY_NAME_OR_BQL"

Pre-built Queries

Always check references/queries.md for the full list of available pre-configured queries.

Common Spanish-to-BQL Translations

  • •"cuánto gasté este mes" -> Use gastos-mes-actual
  • •"gastos por categoría" -> SELECT root(account, 2) AS categoria, sum(position) WHERE account ~ 'Expenses' GROUP BY categoria
  • •"transacciones recientes" -> Use transacciones-recientes (last 30 days)
  • •"patrimonio neto" -> Use net-worth-usd

CRITICAL Rules

  • •ALWAYS prefix beancount commands with uv run.
  • •NEVER use bean-query directly.
  • •Use main.bean as the target file for all queries.