Skip to main content
Glama

excel_native_batch

Destructive

Execute an ordered batch of operations through native Microsoft Excel to automate editing, formatting, calculation, and export across active or closed workbooks.

Instructions

Execute an ordered batch through real Microsoft Excel. Supports active or closed workbooks; exact ranges; structural row, column, and sheet edits; native calculation; formatting; tables; charts; pivots; Goal Seek; filtering; validation; protection; print setup; PDF export; and save/save-as.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
targetYes
overwriteNo
operationsYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.10.2

TDQS

B3.4/5.0
Behavior3/5

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

Annotations already declare destructiveHint=true, idempotentHint=false, readOnlyHint=false, so the safety profile is covered. The description adds that execution is 'ordered' (order-dependent, consistent with non-idempotent) and that it drives 'real Microsoft Excel' over active or closed workbooks, which hints at a native-app dependency. It still omits what gets destroyed, session/permission requirements, and whether saving is implicit.

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?

Purpose is front-loaded in the first clause, followed by a dense but scannable capability list. It is a run-on sentence with a long enumeration, but every listed item corresponds to real supported behavior, so little is wasted.

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?

For a tool exposing 40+ discriminated union operations with a nested target object and no output schema, the description gives a good capability map but no guidance on batch failure semantics, ordering constraints between ops, or how target/overwrite behave. Annotations cover the destructive profile, but a batch executor of this complexity needs more.

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?

The three top-level parameters (target, overwrite, operations) have no descriptions in the schema (coverage reported 0%), and the description never explains them or their interplay. It partially compensates for the operations array by enumerating capability areas (tables, charts, pivots, Goal Seek, filtering, validation, protection, print setup, PDF export) that map onto the op enum values, but 'overwrite' and the target/workbook selection remain unexplained.

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 scope ('Execute an ordered batch through real Microsoft Excel') and the 'batch' framing distinguishes it in spirit from the single-op excel_* siblings. However, it never names an alternative like excel_write_range or excel_set_formulas, so the agent must infer the boundary between batch and single-op tools.

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

Usage Guidelines3/5

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

Context is only implied: 'ordered batch' plus 'active or closed workbooks' signals multi-step, native-app scenarios, but there is no explicit when-to-use, when-not-to-use, or named alternative among the many excel_* siblings. Adequate but leaves routing to inference.

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