Skip to main content
Glama

import_excel_to_import_set

Upload and parse one .xlsx worksheet, create an Import Set, insert its staging rows, and optionally request a Transform Map run (transform start is not verified). Requires WRITE_ENABLED=true.

Instructions

Upload and parse one .xlsx worksheet, create an Import Set, insert its staging rows, and optionally request a Transform Map run (transform start is not verified). Requires WRITE_ENABLED=true. The original workbook is attached to the Import Set for auditability; formulas and sys_* columns are rejected.

Input Schema

NameRequiredDescriptionDefault
file_nameYesOriginal .xlsx file name
sheet_nameNoOptional worksheet name (default: first worksheet)
staging_tableYesExisting Import Set staging table (must extend sys_import_set_row) to receive parsed rows
column_mappingNoOptional mapping of Excel header to staging-table column, e.g. { "CVE": "u_cve" }
content_base64YesBase64-encoded .xlsx content (maximum 10 MiB compressed; ZIP expansion limits apply)
import_set_labelNoOptional Import Set label
transform_map_sys_idNoOptional Transform Map sys_id; a run is requested after rows are inserted (transform start is not verified)

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv1.15.1

TDQS

A4.1/5.0
Behavior5/5

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

Goes well beyond the annotations (readOnly=false, openWorld=true, idempotent=false): discloses that the original workbook is retained for auditability, that formulas and sys_* columns are rejected, that transform start is not verified, and the WRITE_ENABLED gate. These are exactly the side-effect and constraint details an agent needs.

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?

Dense and front-loaded, leading with the multi-step action and following with constraints. Every sentence carries meaning, though the run of caveats is packed tightly.

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?

For a 7-param, nested-object write tool with no output schema, it covers prerequisites, side effects, and validation restrictions well. It doesn't describe the returned Import Set handle/result, which would help the agent chain follow-up calls, but overall it's sufficient to invoke correctly.

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 description coverage is 100%, so the baseline is 3. The description reinforces the 'transform start is not verified' caveat and the .xlsx restriction but adds little parameter-level detail beyond what the schema already documents (sheet_name default, column_mapping example, 10 MiB limit).

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 specific verbs and resources (upload/parse .xlsx, create Import Set, insert staging rows, optionally request Transform Map run), and this compound workflow is clearly distinguishable from siblings like import_cmdb_data, create_import_set_row, and run_transform_map.

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?

Provides the key prerequisite 'Requires WRITE_ENABLED=true' and clarifies transform start is unverified, but it never states when to use this versus import_cmdb_data or create_import_set_row, nor any exclusions. Usage is implied rather than explicit.

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

Deploy Server

Other Tools