json_filter

json_filter

Filter JSON array data using flexible conditions. Apply comparison operators (equals, contains, etc.) and combine with AND/OR logic. Specify a JSON file path and conditions to extract matching objects efficiently.

Instructions

Filter JSON array data using flexible conditions. Supports various comparison operators (equals, greater than, contains, etc.) and can combine multiple conditions with AND/OR logic. Requires maxBytes parameter (default 10KB). Perfect for filtering collections of objects based on their properties. The path must be within allowed directories.

Input Schema

Name	Required	Description	Default
`arrayPath`	No	Optional JSONPath expression to locate the target array (e.g., "$.items" or "$.data.records")
`conditions`	Yes	Array of filter conditions
`match`	No	How to combine multiple conditions - "all" for AND, "any" for OR	all
`maxBytes`	Yes	Maximum bytes to read from the file. Must be a positive integer. Handler default: 10KB.
`path`	Yes	Path to the JSON file to filter

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "arrayPath": {
      "description": "Optional JSONPath expression to locate the target array (e.g., \"$.items\" or \"$.data.records\")",
      "type": "string"
    },
    "conditions": {
      "description": "Array of filter conditions",
      "items": {
        "additionalProperties": false,
        "properties": {
          "field": {
            "description": "Path to the field to check (e.g., \"address.city\" or \"tags[0]\")",
            "type": "string"
          },
          "operator": {
            "description": "Comparison operator",
            "enum": [
              "eq",
              "neq",
              "gt",
              "gte",
              "lt",
              "lte",
              "contains",
              "startsWith",
              "endsWith",
              "exists",
              "type"
            ],
            "type": "string"
          },
          "value": {
            "description": "Value to compare against"
          }
        },
        "required": [
          "field",
          "operator"
        ],
        "type": "object"
      },
      "minItems": 1,
      "type": "array"
    },
    "match": {
      "default": "all",
      "description": "How to combine multiple conditions - \"all\" for AND, \"any\" for OR",
      "enum": [
        "all",
        "any"
      ],
      "type": "string"
    },
    "maxBytes": {
      "description": "Maximum bytes to read from the file. Must be a positive integer. Handler default: 10KB.",
      "exclusiveMinimum": 0,
      "type": "integer"
    },
    "path": {
      "description": "Path to the JSON file to filter",
      "type": "string"
    }
  },
  "required": [
    "path",
    "conditions",
    "maxBytes"
  ],
  "type": "object"
}

Filesystem MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Filesystem MCP Server

Related Tools

MCP directory API