Skip to main content
Glama

Plumb Data Exchange

deduplicate

Remove duplicate rows by exact key, keeping the first or last, and report conflicting columns per group. Costs $0.05 USDC (x402).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
keepYesWhich duplicate to keep
tableYesA string table: at most 1000 rows x 32 columns, 65536 characters total
keyColumnsYesColumns that together identify a row (exact string match)

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A3.5/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 behavioral burden, and it delivers real context: exact-string key matching semantics, the first/last keep policy, conflict-column reporting, and — notably — a paid-call cost of $0.05 USDC via x402, which an agent must know before invoking. It still omits whether the operation is pure/non-destructive and whether the cost is per-call or per-row, so it falls short of a 5.

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

Conciseness5/5

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

Two short sentences with zero filler. The functional behavior is front-loaded and the pricing caveat is separated cleanly at the end where it belongs.

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

Completeness3/5

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

Input schema is fully documented and there is no output schema, so return-shape explanation is not strictly required. However, for a transformation tool the description only alludes to one output artifact ('conflicting columns per group') and says nothing about the deduplicated table or row counts, leaving the result contract thin.

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

Parameters3/5

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

Schema description coverage is 100%, so all three parameters (table, keyColumns, keep) are already documented in the schema. The description reinforces the 'exact key' and 'first or last' semantics but adds no format, sizing, or constraint detail beyond what the schema states; baseline 3 applies.

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

Purpose4/5

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

States a specific verb and resource ('Remove duplicate rows') plus the operative policy ('by exact key, keeping the first or last') and an output side-effect ('report conflicting columns per group'). It does not distinguish itself from the sibling 'reconcile', which an agent could plausibly confuse with a dedup/conflict-reporting operation.

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

Usage Guidelines2/5

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

There is no statement of when to use this versus convert_to_csv, reconcile, or get_job, and no prerequisites or exclusions. The reader must infer applicability entirely from the one-line purpose.

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