Skip to main content
Glama

files_flatten_table

Destructive

Flattens a data table back into plain cell values (the inverse of files_convert_to_table): the table's values are written into the grid and the table wrapper is removed; hidden columns go right of the shown ones, so those cells must be empty. cell: any cell inside the table (e.g. its top-left anchor 'A5'). Works on code-output tables too (bakes the computed values). Requires edit permission. Signature: files_flatten_table(file_uuid, cell, sheet?).

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "file_uuid": "<file_uuid>",
      "cell": "<cell>"
    },
    "name": "files_flatten_table"
  }
}

Input Schema

NameRequiredDescriptionDefault
cellYesAny cell inside the table, e.g. its anchor 'A5'.
sheetNoSheet name (defaults to the first sheet).
file_uuidYes

Output Schema

NameRequiredDescriptionDefault
cellYes
file_uuidYes
sequence_numberYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4/5.0
Behavior4/5

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

Annotations already flag destructiveHint=true and idempotentHint=false, so the safety profile is covered; the description still earns credit by disclosing what is destroyed (the table wrapper), how hidden columns are relocated, and that code-output tables get their computed values baked in. It stops short of stating irreversibility or failure behavior, which keeps it off 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.

Conciseness4/5

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

The core definition is front-loaded in the first clause, then constraints and permissions follow in a sensible order with no filler. The signature tail is slightly redundant given the schema but is short and harmless.

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?

With an output schema present, return values needn't be described, and the mutation/precondition story is well covered. However, edge cases an agent would need before invoking a destructive flatten – failure when hidden columns have data, or effect on formulas – are left unstated.

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 coverage is 67% with cell and sheet already documented in the schema; the description's 'any cell inside the table (e.g. its top-left anchor A5)' largely restates the schema text. file_uuid remains undocumented in both places, and the signature line adds only arity, not meaning.

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 ('Flattens a data table back into plain cell values') and immediately anchors it against the sibling files_convert_to_table as its inverse. The effect (values written into grid, table wrapper removed) is concrete enough that an agent can distinguish it from files_table_delete and files_convert_to_table without opening either schema.

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 inverse relationship to files_convert_to_table gives a clear selection rule, and it names a precondition (hidden columns go right of the shown ones, so those cells must be empty) plus a permission requirement. It does not cover when-not to use it or what to do if the precondition fails, so it falls short of the explicit exclusion pattern.

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