Dataset Filter & Transform MCP

{
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

{
  "type": "object",
  "required": [
    "rows"
  ],
  "properties": {
    "rows": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "The rows to process. Each row is a JSON object. Keys may differ between rows."
    },
    "limit": {
      "type": "integer",
      "description": "Return at most this many rows."
    },
    "offset": {
      "type": "integer",
      "description": "Skip this many rows after filtering and sorting."
    },
    "sortBy": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "Sort the kept rows, for example [{\"field\":\"price\",\"direction\":\"desc\"}]."
    },
    "filters": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "Conditions a row must satisfy to be kept, for example {\"field\":\"country\",\"operator\":\"equals\",\"value\":\"UK\"} or {\"field\":\"price\",\"operator\":\"greaterThan\",\"value\":100}. Dot paths like \"address.city\" work. Call list_capabilities for all 25 operators."
    },
    "distinctBy": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Keep only the first row for each combination of these fields. Applied after sorting, so sorting first lets you keep the newest row per key."
    },
    "transforms": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "Transform steps applied to every row, in order. Each step is an object with an \"op\" key, for example {\"op\":\"cast\",\"field\":\"price\",\"to\":\"number\"} or {\"op\":\"compute\",\"field\":\"total\",\"expression\":\"price * qty\"} or {\"op\":\"rename\",\"from\":\"e_mail\",\"to\":\"email\"}. Call list_capabilities for all 26 operations."
    },
    "lenientNumbers": {
      "type": "boolean",
      "description": "On by default: values like \"$1,234.50\", \"49 USD\" and \"12%\" are read as numbers. Set false to require real numeric values."
    },
    "filterCombineMode": {
      "enum": [
        "AND",
        "OR"
      ],
      "type": "string",
      "description": "Whether a row must match every filter (AND, the default) or any one of them (OR)."
    },
    "caseSensitiveFilters": {
      "type": "boolean",
      "description": "Text comparisons are case-insensitive by default. Set true to make them exact."
    }
  },
  "additionalProperties": false
}