Skip to main content
Glama

Transform range

transform_range
Destructive

Clean Excel ranges by removing duplicate rows, splitting text into columns, and filling cells down, right, or as a series.

Instructions

Remove duplicate rows, split text into columns, or fill down, right or as a series, like Excel's Data and Fill commands.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
pathYes
rangeYes
sheetYes
transformYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv2.0.0

TDQS

C2.7/5.0
Behavior2/5

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

Annotations already declare destructiveHint=true, readOnlyHint=false, and idempotentHint=false, so the safety profile is carried by structured data. The description adds no behavioral context beyond a bare feature list: it never states that operations mutate cells in place, that duplicates are discarded or filled values overwrite existing content, or that the change is not idempotent.

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?

A single front-loaded sentence that lists the operations first and the analogy last; no filler or redundancy. It is terse rather than padded, though the terseness leaves gaps the other dimensions penalize.

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

Completeness2/5

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

For a four-required-parameter, nested-object mutation tool with no output schema, the description is too thin: it omits how the file/sheet/range are target-selected and never warns that the operation overwrites or removes data in place. The Excel analogy conveys intent but not the operational detail needed to invoke it safely.

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?

The context reports 0% top-level schema description coverage for path, sheet, range, and transform, so the description is expected to compensate and largely does not. It names the three operations but gives no meaning for the path/sheet/range targeting, and the substantive per-operation detail (columns, delimiters, fixed_widths_chars, series) lives only in the nested $defs, which the description merely gestures at.

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?

The description names three concrete operation families (remove duplicates, split text into columns, fill down/right/series) and anchors them to a familiar Excel metaphor, so an agent can tell it apart from sort_range, format_range, or replace_cells. It does not name the target resource (cells in a file/sheet/range) explicitly, relying on the title, so it stops just short of the top mark.

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 when-to-use, when-not-to-use, or alternative guidance. The 'like Excel's Data and Fill commands' line is an analogy that aids intuition, not a selection rule, and it doesn't tell the agent when this beats sort_range or replace_cells.

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