json_transform

json_transform

Modify JSON data by applying sequential operations such as mapping, grouping, sorting, flattening, and field selection. Requires specified file path, operations, and size limit for secure processing.

Instructions

Transform JSON data using a sequence of operations. Supports operations like mapping array elements, grouping by fields, sorting, flattening nested arrays, and picking/omitting fields. Requires maxBytes parameter (default 10KB). Operations are applied in sequence to transform the data structure. The path must be within allowed directories.

Input Schema

Name	Required	Description
`maxBytes`	Yes	Maximum bytes to read from the file. Must be a positive integer. Handler default: 10KB.
`operations`	Yes	Array of transformation operations to apply in sequence
`path`	Yes	Path to the JSON file to transform

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "maxBytes": {
      "description": "Maximum bytes to read from the file. Must be a positive integer. Handler default: 10KB.",
      "exclusiveMinimum": 0,
      "type": "integer"
    },
    "operations": {
      "description": "Array of transformation operations to apply in sequence",
      "items": {
        "additionalProperties": false,
        "properties": {
          "field": {
            "description": "Field to operate on (if applicable)",
            "type": "string"
          },
          "fields": {
            "description": "Fields to pick/omit (if applicable)",
            "items": {
              "type": "string"
            },
            "type": "array"
          },
          "order": {
            "description": "Sort order (if applicable)",
            "enum": [
              "asc",
              "desc"
            ],
            "type": "string"
          },
          "type": {
            "description": "Type of transformation operation",
            "enum": [
              "map",
              "groupBy",
              "sort",
              "flatten",
              "pick",
              "omit"
            ],
            "type": "string"
          }
        },
        "required": [
          "type"
        ],
        "type": "object"
      },
      "minItems": 1,
      "type": "array"
    },
    "path": {
      "description": "Path to the JSON file to transform",
      "type": "string"
    }
  },
  "required": [
    "path",
    "operations",
    "maxBytes"
  ],
  "type": "object"
}

Filesystem MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Filesystem MCP Server

Related Tools

MCP directory API