Skip to main content
Glama
araujoviana

hwc-calculator

by araujoviana

export_quotes_xlsx

Builds an .xlsx workbook from Huawei Cloud quote lists, with one row per environment plus sheets for decisions, priced resources, and totals; aborts without writing if any list cannot be read.

Instructions

Write a workbook of price lists, one row per environment, on four sheets: Quotes (environment, list name, total USD, link), Decisions (what was chosen and why), Resources (every priced resource) and Totals (instances, vCPUs, RAM, storage).

rows: [{"env": "prod", "list": share url or id, "draft_id"?: id}], kept in this order. A list saved by publish_quote finds its decisions by itself; "draft_id" is for any other. Reads the lists anonymously. path must end in .xlsx and is overwritten. Nothing is written if any list cannot be read.

Input Schema

NameRequiredDescriptionDefault
pathNoquotes.xlsx
rowsYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.4

TDQS

A4.2/5.0
Behavior4/5

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

With no annotations, the description carries the full burden and does substantial work: it discloses anonymous read access, that `path` is overwritten, and the atomic all-or-nothing guarantee ('Nothing is written if any list cannot be read'). These are exactly the side-effect and failure semantics an agent needs before a write operation.

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?

Front-loaded with the purpose and output sheets, then constraints. Dense but nearly every clause carries information; the awkward line breaks and trailing parenthetical 'kept in this order' add minor noise but no real waste.

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?

For a no-annotation, no-output-schema tool, the description covers the produced artifact, auth model, and failure behavior. It stops short of describing error reporting or how unreadable lists are signalled, but an agent has enough to invoke it correctly.

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 coverage is 0%, so the description must compensate, and it does: it defines the row object shape (env, list as share url or id, optional draft_id), the ordering guarantee, and the `.xlsx` suffix requirement for `path`. Both parameters gain meaning that the bare schema does not provide.

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?

States a specific verb and resource — 'Write a workbook of price lists, one row per environment' — and enumerates the four sheets produced. The agent knows exactly what artifact this creates without opening the schema, and the publish_quote cross-reference distinguishes it from read_price_list.

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

Usage Guidelines3/5

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

Explains the draft_id condition ('a list saved by publish_quote finds its decisions by itself; draft_id is for any other'), which is real usage guidance. However, it never states when to choose this export over sibling readers like read_price_list, nor any prerequisite or exclusion beyond the input format.

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