Skip to main content
Glama

Clean a table against a stated schema (paid, $0.02 USDC)

clean_table
Read-onlyIdempotent

Use when you have a CSV or delimited table and already know which source column should become which output field — it conforms a file to a schema you state, and does not infer the schema for you. Normalise a delimited table to the fields you name: dates to ISO, money to numbers, text collapsed, optional deduplication. Anything that cannot be read with certainty is returned as an exception with a reason, never guessed. Every delivered cell is re-checked against its source token before the response is built. Deterministic: the same input always gives the same output. PAID: $0.02 USDC on Base mainnet, settled by Circle Gateway via x402 v2; call without payment to receive the PaymentRequired terms.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
csvYesThe delimited table, including its header row (1–48000 bytes, at most 2000 data rows).
fieldsYesThe agreed schema: which source column becomes which output field, and of what type.
dateOrderNoYour system's date order. The file's own proof always wins over this.
dedupeKeyNoOutput field to deduplicate on. Omit for no deduplication.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.5/5.0
Behavior4/5

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

The description goes beyond annotations by disclosing deterministic behavior, the re-checking of cells against source tokens, and the never-guess policy with exceptions. While annotations indicate read-only and idempotent, the description adds valuable behavioral context about data validation and payment necessity. However, it doesn't fully detail edge cases like how it handles conflicting date formats, but the given information is already rich.

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 well-structured and front-loaded with the primary use case, followed by operational details and payment info. While it is slightly lengthy, every sentence carries necessary information (normalization operations, exception handling, determinism, payment) and avoids fluff. The structure is logical and easy to scan.

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 tool's moderate complexity and the fact that there is no output schema, the description covers all critical aspects: what the tool transforms, how it handles unreadable data, determinism, and payment requirements. It also clarifies the order of date interpretation. Remaining gaps include specifics of the exception format and exact response structure, but those aren't essential for initial invocation. It is complete enough for an agent to decide and execute correctly.

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

Parameters4/5

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

Schema description coverage is 100%, so the baseline is 3. The description adds semantics beyond the schema by explaining the overall purpose of parameters (e.g., 'fields' as the agreed schema with type conversions, 'dateOrder' with the file's proof override). This enriches the schema details with practical context on how parameters affect behavior, pushing the score to 4.

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 the tool's function: conforms a delimited table to a user-stated schema, with explicit detail on normalization operations (dates to ISO, money to numbers, text collapsed, optional dedup). It also clearly distinguishes itself from schema-inference tools by stating it does not infer the schema for you. This is a specific verb-resource pair with no ambiguity.

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 explicitly states when to use the tool: when you have a CSV and already know which source column becomes which output field. It also implies when not to use it (when you need schema inference) and mentions that the file's own date order proof wins over the provided dateOrder, guiding usage. The payment requirement is also a usage trigger.

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.

Resources