Skip to main content
Glama

Convert CSV and JSON

convert_csv_json
Read-onlyIdempotent

Convert CSV to JSON or JSON to CSV. Supports comma, tab, semicolon, and pipe delimiters, an optional header, type inference, and dotted flattening. Inferred numbers that do not fit in a JavaScript number keep their digits.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
textYes
headerNo
flattenNoUsed when converting JSON to CSV. Nested keys become dotted columns.
delimiterNoComma, tab, semicolon, pipe, or auto. Auto is a comma when writing CSV.auto
directionNocsv-to-json
inferTypesNoUsed when converting CSV to JSON.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
okYes
rowsYes
errorYes
outputYes
columnsYes
warningYes
delimiterYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A3.7/5.0
Behavior4/5

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

Annotations already declare readOnly/openWorld/idempotent, so the bar for adding context is lower. The description clears it by disclosing real behavioral traits beyond the annotations: supported delimiters, type inference, dotted flattening, and notably that inferred numbers too large for a JavaScript number retain their digits (precision handling). Missing edge-case detail on malformed input is a minor gap.

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?

Three tight sentences, front-loaded with the primary action, then supported options, then a precision caveat. No wasted words; each sentence earns its place.

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?

With an output schema present, return values need not be explained, and annotations carry the safety profile. The description is nearly complete for calling correctly, though it omits the schema's note that 'auto' delimiter resolves to comma when writing CSV and gives no guidance versus the convertible sibling tool.

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 coverage is only 50%, but the description compensates by naming delimiters, optional header, type inference, and dotted flattening, which map onto the delimiter/header/inferTypes/flatten parameters and effectively cover most fields. The direction parameter is implied by 'CSV to JSON or JSON to CSV'. It adds meaning beyond the schema for the un-covered fields.

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+resource (convert CSV↔JSON) and even disambiguates both directions, so the core purpose is unambiguous. It does not, however, differentiate itself from the overlapping sibling convert_data_format, which likely covers format conversion too.

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

Usage Guidelines2/5

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

No when-to-use, when-not-to-use, or alternative mentions. Notably the sibling convert_data_format is left unaddressed, so an agent has no guidance on which converter to pick. The description explains capabilities but not selection context.

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.