Skip to main content
Glama

Messy CSV → tidy CSV, with a report of every change

clean_table
Read-onlyIdempotent

Tidies a spreadsheet export: removes duplicate rows, trims whitespace (half-width and full-width — Chinese exports are full of  ), unifies the half-dozen ways a cell can say "empty" (NA / null / - / 无), drops empty rows and columns, and can split one column into several. Returns the cleaned CSV plus exactly what changed: rows in, rows out, duplicates removed, cells trimmed per column. It can also transpose rows/columns and unpivot a wide table into a long one. The row arithmetic is verified in code — if in − removed ≠ out, the response says so instead of handing back a table nobody can check. Use when a CSV came out of Excel or an export and needs cleaning before analysis.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
opsNoComma-separated, default "dedupe,trim,drop_empty,unify_blank". Also available: split_column, transpose (swap rows/columns), wide_to_long (unpivot a wide table into the long format analysis tools expect).
urlNoLink to the CSV. Provide this or text.
keepNoFor wide_to_long: comma-separated id columns to keep as-is. Defaults to the first column.
textNoThe CSV content itself. Provide this or url.
split_byNoSeparator to split on, default a single space.
split_columnNoColumn name to split (requires ops to include split_column).

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

TDQS

A4.6/5.0
Behavior5/5

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

The description goes well beyond the annotations by disclosing the return format ('Returns the cleaned CSV plus exactly what changed: rows in, rows out, duplicates removed, cells trimmed per column') and an important integrity check ('The row arithmetic is verified in code — if in − removed ≠ out, the response says so'). It also adds contextual details about handling Chinese full-width whitespace and various empty-value representations, which are not present in the annotations.

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 slightly longer than strictly necessary but every sentence adds value. It front-loads the main purpose, then details operations, return behavior, and a use case. The structure is logical and readable, though it could be tightened without losing critical information.

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

Completeness5/5

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

For a tool with 6 parameters, an output schema, and read-only/idempotent annotations, the description is highly complete. It explains what operations are available, what the output reports, and even the self-verification mechanism. The presence of an output schema means it doesn't need to detail return values, but it does anyway, adding a layer of confidence for the agent.

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?

With 100% schema description coverage, the schema already documents each parameter. The description adds extra meaning by illustrating the 'unify_blank' operation with examples (NA / null / - / 无) and by explaining the split_column and wide_to_long operations in a user-oriented way. This enriches the ops parameter beyond the schema's brief listing.

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 purpose with a specific verb and resource ('Tidies a spreadsheet export') and enumerates concrete operations (removes duplicate rows, trims whitespace, unifies blank values, drops empty rows/columns, splits columns). This distinguishes it from sibling tools like diff_tables or merge_tables, which focus on comparison or combining rather than cleaning and reshaping.

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 provides a clear use case: 'Use when a CSV came out of Excel or an export and needs cleaning before analysis.' This is explicit and contextual. However, it does not explicitly mention alternatives or when not to use the tool, so it falls just short of the 5-point threshold.

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

A3.9/5.0
Disambiguation5/5

Every tool has a clearly distinct purpose with detailed descriptions that explicitly differentiate even close pairs like diff_tables vs reconcile_ledger and list_models vs model_costs. No two tools appear to do the same thing, and the what_can_you_do tool further resolves any confusion.

Naming Consistency3/5

The majority of tools follow a verb_noun snake_case pattern (build_app, fetch_page, list_tasks), but several notable deviations exist: ai_visibility, china_reachability, model_costs, json_yaml, pdf_to_markdown, what_can_you_do, recall, remember, and jwt_decode. This mixed convention, while still readable, is not fully consistent.

Tool Count3/5

With 34 tools, the count is high and exceeds the typical comfortable range for an MCP server. However, the server is a broad AI utility platform covering web, data, LLM, conversion, and scheduling tasks, and each tool appears to serve a distinct purpose with little redundancy, making the large but organized set borderline appropriate for its scope.

Completeness3/5

The tool surface covers a wide array of common workflows (search, fetch, table operations, PDF extraction, model comparisons, task scheduling, memory). However, check_job references deep_research, translate_pdf, and make_slides which are not present in the tool list, and there is no update tool for tasks/apps or a way to delete memories, leaving some user journeys incomplete.

Resources