rog0x avatar

Json

rog0x/mcp-json-tools

Plugs JSON, YAML, and CSV manipulation directly into Claude through stdio. You get seven tools: schema validation with detailed error paths, structural diffs showing what changed where, transformations like pick/rename/flatten, and bidirectional conversion between all three formats with configurable delimiters and type casting. Useful when you're building workflows that need to validate API payloads against schemas, compare configuration files, reshape data structures without writing throwaway scripts, or convert between formats during data pipeline work. Install via npm, point Claude Desktop or Claude Code at the built index.js, and the tools appear in your agent's toolkit.

tools
6
transport
STDIO
last updated
Mar 22, 2026

Tools

6 tools

Public tool metadata for what this MCP can expose to an agent.

json_formatPretty-print or minify JSON. Specify indent level (default 2) or set minify=true to compact JSON into a single line.3 params

Pretty-print or minify JSON. Specify indent level (default 2) or set minify=true to compact JSON into a single line.

Parameters* required
indentinteger
Indentation spaces (1-8, default 2)default: 2
jsonstring
The JSON string to format
minifyboolean
If true, output compact single-line JSON (overrides indent)default: false
json_validateValidate a JSON string. Returns valid=true with type info on success, or valid=false with line, column, error message, and a suggestion for fixing common mistakes.1 params

Validate a JSON string. Returns valid=true with type info on success, or valid=false with line, column, error message, and a suggestion for fixing common mistakes.

Parameters* required
jsonstring
The JSON string to validate
json_diffCompare two JSON values and return a structured diff showing added paths, removed paths, and changed values. Supports nested objects and arrays.2 params

Compare two JSON values and return a structured diff showing added paths, removed paths, and changed values. Supports nested objects and arrays.

Parameters* required
json_astring
The original JSON (before state)
json_bstring
The new JSON (after state)
json_queryQuery JSON data using JSONPath-like syntax. Supports: root ($), dot notation ($.a.b), bracket notation ($["key"]), array index ($[0]), wildcard (*), deep scan (..), slice ([1:3]), filter ([?(@.age>18)]), and union ([0,1]).2 params

Query JSON data using JSONPath-like syntax. Supports: root ($), dot notation ($.a.b), bracket notation ($["key"]), array index ($[0]), wildcard (*), deep scan (..), slice ([1:3]), filter ([?(@.age>18)]), and union ([0,1]).

Parameters* required
jsonstring
The JSON string to query
querystring
JSONPath expression (e.g. "$.users[0].name", "$.items[*].price", "$..[?(@.active==true)]")
json_transformTransform JSON data. Operations: "flatten" (nested→flat with dot keys), "unflatten" (flat→nested), "pick" (keep only specified keys), "omit" (remove specified keys), "rename" (rename keys via a map). Use options.deep=true for recursive key operations.3 params

Transform JSON data. Operations: "flatten" (nested→flat with dot keys), "unflatten" (flat→nested), "pick" (keep only specified keys), "omit" (remove specified keys), "rename" (rename keys via a map). Use options.deep=true for recursive key operations.

Parameters* required
jsonstring
The JSON string to transform
operationstring
The transformation operationone of flatten · unflatten · pick · omit · rename
optionsobject
Operation-specific options
json_schema_generateGenerate a JSON Schema (draft-07 compatible) from a sample JSON object. Infers types, required fields, formats (date-time, email, uri, uuid), and nested structure. Ideal for API documentation or validation setup.2 params

Generate a JSON Schema (draft-07 compatible) from a sample JSON object. Infers types, required fields, formats (date-time, email, uri, uuid), and nested structure. Ideal for API documentation or validation setup.

Parameters* required
jsonstring
Sample JSON to generate schema from
titlestring
Schema title (default "GeneratedSchema")default: GeneratedSchema

Sponsors

Readme

mcp-json-tools

An MCP (Model Context Protocol) server that provides JSON and data manipulation tools for AI agents. Designed for use with Claude Code, Claude Desktop, and any MCP-compatible client.

Tools

ToolDescription
json_validateValidate JSON data against a JSON Schema, returning detailed errors with paths
json_diffCompare two JSON objects, showing additions, removals, and changes with paths
json_transformTransform JSON with pick, rename, flatten, and unflatten operations
csv_to_jsonConvert CSV text to a JSON array with configurable headers, delimiters, and type casting
json_to_csvConvert a JSON array of objects to CSV text
yaml_to_jsonConvert YAML text to JSON
json_to_yamlConvert JSON text to YAML

Installation

npm install
npm run build

Usage with Claude Code

claude mcp add json-tools -- node D:/products/mcp-servers/mcp-json-tools/dist/index.js

Usage with Claude Desktop

Add the following to your Claude Desktop configuration file:


View the full README on GitHub

Details

Repository
github.com/rog0x/mcp-json-tools
Category
Data & Analytics
Package
@rog0x/mcp-json-tools
Transport
STDIO
Registry
MCP registry, active

More from rog0x

Related Data & Analytics MCP servers

View all
1stucchi avatarGoogle Analytics 4stucchi/mcp-google-analyticsManage GA4 properties, data streams, conversions, and run reports via Admin & Data APIs.0stars
2us-all avatarDbtus-all/dbt-mcp-serverdbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)0stars
3safe-mcp avatarGoogle Analytics (unofficial)com.safe-mcp/google-analytics-unofficialConnect Google Analytics to ChatGPT. Query GA4 data in plain English and get instant insights.0stars
4dbsectrainer avatarMcp Data Pipeline Connectordbsectrainer/mcp-data-pipeline-connectorUniversal data connector for CSV, Postgres, and REST APIs via DuckDB0stars
5furqan-khan07 avatarpandas-doctorfurqan-khan07/pandas-doctorFinds slow pandas code, checks rewrites give identical results on your data, measures speedups.0stars
6lazymac2x avatarSmart Data Extractorlazymac2x/smart-data-extractor-workersmart-data-extractor MCP server on Cloudflare Workers · REST + MCP JSON-RPC · free tier0stars