Skip to main content
Glama

openfinance_list_transactions_by_item

Read-onlyIdempotent

Consolidated cash-flow analysis for a whole bank CONNECTION over a period, in ONE call. Resolves the connection's accounts internally and fans out their transactions, so you do NOT need to call openfinance_list_accounts first nor carry account_id uuids between calls. Pass item (connector_id, connector_name or item_id) to target one bank, or OMIT it to analyze ALL linked banks at once. from/to are ISO dates (YYYY-MM-DD). Default granularity:'monthly' returns a COMPACT summary (no raw rows): total entradas, saídas, saldo_liquido, monthly evolution (por_mes), and top_despesas/top_recebimentos (largest N each), plus a per-account breakdown (by_account). Use this for 'análise anual/mensal', 'fluxo de caixa', 'entradas e saídas', 'maiores gastos/recebimentos'. Set granularity:'raw' to ALSO get every consolidated transaction (heavier — only when itemized rows are needed); combine with detail:'rich' to enrich those rows with merchantInfo (cnpj/cnae/businessName/category) + extra creditCardMetadata (billId, purchaseDate, fees), or detail:'raw' for the full untouched Pluggy object per row, when the connector provides them. type filters BANK or CREDIT accounts. On a connection with many transactions the scan caps at 5000/account and flags truncated:true. May include a provider_incident block when the Open Finance provider has an OPEN incident affecting a connected bank: the totals/rows may be incomplete or wrong until the provider recovers, and reconnecting does not fix it.

Bulk support: accepts item_ids for batched execution.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
toNo
fromNo
itemNo
typeNo
top_nNo
detailNo
item_idNo
item_idsNo
granularityNo

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint, idempotentHint, and destructiveHint false. The description adds critical behavioral traits: a cap of 5000 transactions per account with a truncated flag, potential provider_incident block explaining incomplete data, and that it resolves accounts internally. These go beyond annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is thorough but somewhat lengthy. It is well-structured with key sections (bullets in original? but here as prose). Every sentence adds value, but could be more concise by combining some sentences. Still, it remains readable and front-loaded with the main purpose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no output schema, the description thoroughly explains the return structure: totals, monthly evolution, top expenses/revenues, per-account breakdown, and the optional raw rows with detail levels. It also covers edge cases like truncation and provider incidents. This is complete for a complex tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must compensate. It explains every parameter: item (connector_id/connector_name/item_id), from/to (ISO dates), granularity (monthly/raw), detail (compact/rich/raw with explanation of each), type (BANK/CREDIT), and item_ids for bulk. The meaning of top_n is implied by 'largest N'.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it provides 'consolidated cash-flow analysis for a whole bank CONNECTION over a period, in ONE call.' It distinguishes from sibling tools like openfinance_list_accounts by explicitly saying you don't need to call them first. The verb 'analyze' and resource 'connection transactions' are specific.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives explicit guidance: when to set granularity to monthly vs raw, when to use detail options, and filters. It states usage scenarios like 'análise anual/mensal, fluxo de caixa'. It also advises that for all linked banks you omit the item parameter.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

TDQS

A3.9/5.0
Disambiguation4/5

The openfinance_* family is cleanly separated by resource and action, and tricky pairs like list_accounts vs get_account_balance and list_transactions vs list_transactions_by_item are explicitly cross-referenced in descriptions. However, marketplace bundles a large set of sub-actions, and connect/toolkit_info partially overlap on reporting connection state, so a couple of boundaries are fuzzy.

Naming Consistency4/5

The openfinance_* tools consistently follow a verb_resource pattern with snake_case, which is highly predictable. The generic platform tools mostly fit the same style, but marketplace and toolkit_info are noun-only names, and openfinance_provider_status also breaks the verb pattern, so it is not perfectly uniform.

Tool Count3/5

At 25 tools, this server falls at the heavy end of the borderline range. The many openfinance_* list/get tools are individually justified for the financial domain, but adding platform tools like marketplace, connect, toolkit_info, and show_version makes the overall surface larger than a minimal server needs.

Completeness5/5

The financial surface is remarkably thorough: accounts, transactions, credit card bills, loans, investments, categories, connection lifecycle, sync, and provider health are all covered with list/get and update paths where applicable. The platform side also covers auth, connection status, marketplace discovery/execution, versioning, and bug reporting, leaving no obvious dead ends.