Skip to main content
Glama
nometalalchemist

io.github.nometalalchemist/kitchensink4xl

set_cells

Batch-write individual Excel cells atomically. All cell addresses validate before any write; one invalid entry aborts the whole batch, preserving original data.

Instructions

Write many individually addressed cells as ONE atomic batch, the scatter complement to write_range. cells is a list of {cell, value} items (cell is an A1 string or a location object resolving to one cell; 1,000-cell ceiling); every address is resolved BEFORE anything is written, so one bad item refuses the whole batch untouched. '=' strings become formulas, normalized. A hazardous workbook refuses unless allow_loss is true. Auto-backup to .ks4xl-backups; atomic verified save. Refuses while open in Excel.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
pathYes
cellsYes
sheetNo
backupNo
allow_lossNo
verify_comNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. First observedv1.0.0

TDQS

A4.6/5.0
Behavior5/5

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

With no annotations, the description carries the full burden and does so impressively. It discloses atomic batch semantics, pre-resolution of all addresses, all-or-nothing failure on a bad item, formula normalization, hazardous-workbook refusal with allow_loss escape, auto-backup, atomic verified save, and refusal while the workbook is open in Excel.

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?

The description is dense but every clause earns its place. It front-loads the core purpose, then layers the critical behavioral details in a logical order without wasted words.

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

Completeness4/5

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

The description covers the essential use case, failure modes, safety behavior, and key constraints. An output schema exists, so return-value documentation is not the description's responsibility. The main completeness gap is the undocumented 'verify_com' parameter, which the description does not illuminate.

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?

Schema description coverage is 0%, so the description must compensate. It adds strong semantic detail for 'cells' (item shape, cell addressing, 1,000-cell ceiling), 'allow_loss' (hazardous workbook escape), and backup behavior. However, it leaves 'sheet', 'path', and especially 'verify_com' unexplained, so the compensation is not complete.

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 opens with a specific verb and resource: 'Write many individually addressed cells as ONE atomic batch'. It also identifies itself as 'the scatter complement to write_range', making the distinction from the sibling tool explicit and eliminating ambiguity.

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 names write_range as the complementary alternative and implies this tool is for individually addressed cells rather than contiguous ranges. However, it does not explicitly state when *not* to use it, such as for a single cell via set_cell or a rectangular range via write_range.

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

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/nometalalchemist/KitchenSink4XL'

If you have feedback or need assistance with the MCP directory API, please join our Discord server