Skip to main content
Glama

openfinance_list_investments

Read-onlyIdempotent

Returns the investment portfolio for a connection (broker or bank with INVESTMENTS product enabled): FIIs, stocks, ETFs, fixed income (CDB/LCI/LCA/Tesouro), mutual funds, retirement (previdência) and COE. Each row carries balance, amount, amountOriginal, amountProfit, lastMonthRate / annualRate / lastTwelveMonthsRate (when available), dueDate, issuer, ISIN, etc. Returns { total:0, results:[], warning } instead of throwing when INVESTMENTS isn't enabled (403) or other upstream errors. DATA INTEGRITY: when MULTIPLE positions come back as TOTAL_WITHDRAWAL with balance/quantity 0 at once (mass zeroing), the tool cross-checks each position's own transaction history upstream; if the zeroing is contradicted (BUY with no sale/redemption/transfer) the response carries data_integrity_warning and the affected rows are flagged integrity:'suspect_zeroed' — treat those balances as UNAVAILABLE (likely a temporary connector failure publishing zeros), never as real R$0, and do NOT sum them into the portfolio.

Bulk support: accepts item_ids for batched execution.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
itemNo
pageNo
typeNo
item_idNo
item_idsNo
page_sizeNo

Schema Changelog

Changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. Added
  2. Removed
  3. Added
  4. Removed
  5. Added
  6. Removed
  7. Changed2 schema fields changed
    • addedInput schema / properties / item_id
      Added value: +{
      +  "type": "string"
      +}
    • addedInput schema / properties / item_ids
      Added value: +{
      +  "items": {
      +    "type": "string"
      +  },
      +  "type": "array"
      +}
  8. Added
  9. Removed
  10. First observed

TDQS

A4.1/5.0
Behavior5/5

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

Beyond annotations (readOnlyHint, destructiveHint), the description discloses critical behaviors: returns a safe response on errors instead of throwing, and details the data integrity warning for mass zeroing of positions. This extra context is highly valuable for correct invocation and interpretation.

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 moderately concise but packs significant detail. It front-loads the main purpose and then logically covers error handling, data integrity, and bulk support. Could be slightly more structured (e.g., bullet points) but is not overly verbose.

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

Completeness4/5

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

Given the moderate complexity (portfolio listing with integrity checks), the description covers core behaviors well. However, parameter descriptions are missing, and the return structure is only partially described. No output schema exists, so the description bears the burden, which is mostly but not fully met.

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

Parameters2/5

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

With 0% schema description coverage, the description only explains 'item_ids' for bulk support. The other five parameters (item, page, type, item_id, page_size) are not clarified at all. The type enum values are listed in the schema but not explained. This is insufficient for an agent to use these parameters correctly.

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 explicitly states it returns the investment portfolio for a connection, listing specific asset types (FIIs, stocks, ETFs, etc.) and key fields. This clearly distinguishes it from sibling tools like openfinance_list_investment_transactions, which deals with transactions.

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

Usage Guidelines4/5

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

The description explains that the tool is for connections with INVESTMENTS enabled and describes error handling when not enabled. It provides implicit context but does not explicitly contrast with alternatives or state when not to use it. The bulk support note adds practical guidance.

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

A4/5.0
Disambiguation3/5

The openfinance_* tools are mostly distinct resource/action pairs, but several boundaries blur: openfinance_list_transactions vs openfinance_list_transactions_by_item vs openfinance_get_credit_card_bill(include_transactions) all return transaction data, and openfinance_get_item_status / openfinance_provider_status / openfinance_list_connections all concern connection health. The monolithic marketplace tool also bundles search/describe/invoke/install/prompt-library operations, adding further ambiguity.

Naming Consistency4/5

The 19 openfinance_* tools follow a clean snake_case verb_noun pattern (list_accounts, get_item_status, update_transaction_category), but the six platform tools break it with bare verbs (authenticate, connect) and noun-style names (marketplace, toolkit_info). The split is namespace-based and still readable, so it is only a minor inconsistency.

Tool Count3/5

25 tools is on the heavy side, but the server spans two domains: an Open Finance banking surface (accounts, bills, loans, investments, connections) and a marketplace/platform layer (auth, search, prompts, bug reporting). Many openfinance tools are necessary for that breadth, though the count is high enough to feel bloated.

Completeness4/5

The Open Finance surface is nearly complete: connections can be searched, listed, disconnected, force-synced, and health-checked; accounts, transactions, bills, loans, and investments all have read/detail paths; transaction categories can be updated. Minor gaps exist, such as no granular marketplace tools outside the monolithic marketplace tool and no single-transaction detail endpoint, but core workflows do not dead-end.