Skip to main content
Glama
koble-mcp

koble-mcp

Official
by koblesystems

po_from_csv

Convert an approved MRP worksheet into read-only purchase-order drafts, one per vendor, validated against EBMS and ready to POST. It creates nothing, so review and confirm each draft before writing.

Instructions

Turn an approved MRP worksheet into purchase-order drafts, read-only. Reads the worksheet mrp_plan produced (its Excel workbook, or a CSV), after the planner approved BUY rows on its To order tab (and perhaps changed Qty or Vendor); checks every vendor and product against EBMS; and returns one draft per vendor with the exact body to POST to APINV with ebms_write. It creates nothing. A worksheet handed in twice cannot order twice: ebms_write refuses the duplicate EXTERNALID. Show the drafts and get a clear yes per purchase order before writing.

Input Schema

NameRequiredDescriptionDefault
csvNoThe worksheet's CSV text, exactly as the user attached or pasted it.
pathNoPath of the worksheet on this computer: the .xlsx workbook mrp_plan saved (after the user approved rows in it), or a CSV. Give this or csv.
companyYesRequired. Company, by ID or name. Must match the worksheet's company.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changedv0.1.0
    • changedInput schema / properties / path / description
      Previous value: -"Path of the worksheet CSV on this computer. Give this or csv."New value: +"Path of the worksheet on this computer: the .xlsx workbook mrp_plan saved (after the user approved rows in it), or a CSV. Give this or csv."
  2. First observedv0.1.0-rc.1

TDQS

A4.3/5.0
Behavior4/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 well: read-only ('It creates nothing'), validation of every vendor and product against EBMS, and idempotency guaranteed by ebms_write refusing duplicate EXTERNALID. It does not say what a draft looks like when a vendor or product fails validation, which is the one behavioral gap for a tool whose whole job is validation.

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?

Four dense sentences, front-loaded with the core action and read-only guarantee, then workflow, then safety rule. Slightly run-on with the exclamation-free but long third clause, yet each sentence contributes distinct information.

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?

No output schema exists, so the description must describe returns and it does: one draft per vendor with the exact body to POST to APINV. Combined with the idempotency note and approval gate, an agent has enough to act; only error/partial-failure behavior is 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 description coverage is 100%, so the schema already explains csv, path and company, including the either/or between csv and path and the company-match requirement. The description adds only indirect meaning (the worksheet may have edited Qty/Vendor) and does not clarify formats or precedence beyond the schema.

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 transformation (worksheet -> purchase-order drafts) plus the read-only constraint in the first clause. It also implicitly separates its role from mrp_plan (which produces the worksheet) and ebms_write (which posts the drafts), so an agent can place it in the pipeline without ambiguity.

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

Usage Guidelines5/5

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

Gives an explicit precondition (planner approved BUY rows on the To order tab, possibly editing Qty or Vendor) and names the downstream step (POST drafts via ebms_write). It also states a procedural rule: show the drafts and get a clear yes per purchase order before writing.

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