Dataset Join & Merge MCP

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

{
  "type": "object",
  "required": [
    "leftRows",
    "rightRows"
  ],
  "properties": {
    "joinType": {
      "enum": [
        "left",
        "inner",
        "right",
        "full",
        "leftAnti",
        "rightAnti",
        "union"
      ],
      "type": "string",
      "description": "Which rows to keep. left (default): every left row, enriched where a match exists. inner: matched rows only. right: every right row. full: everything from both sides. leftAnti: left rows with no match on the right. rightAnti: right rows with no match on the left. union: stack both lists, no key needed."
    },
    "leftRows": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "The LEFT table: the main rows you want to keep or enrich. Each row is a JSON object; keys may differ between rows."
    },
    "rightRows": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "The RIGHT table: the lookup rows to pull matching fields from. Each row is a JSON object."
    },
    "keyMatching": {
      "enum": [
        "normalized",
        "exact"
      ],
      "type": "string",
      "description": "normalized (default): case-insensitive, trimmed, repeated spaces collapsed, 123 matches \"123\". exact: values must be identical."
    },
    "rightFields": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Only copy these fields from the matching right row, like choosing VLOOKUP return columns. Leave out to copy every right field."
    },
    "leftKeyFields": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "The field name(s) on the left rows to match on, for example [\"email\"], or [\"firstName\",\"lastName\"] for a composite key. Required for every joinType except union."
    },
    "rightKeyFields": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "The matching field name(s) on the right rows, in the same order as leftKeyFields, for example [\"contact_email\"]. Leave out when the right rows use the same names as the left."
    },
    "includeJoinInfo": {
      "type": "boolean",
      "description": "On by default: every row gets _joinStatus (\"matched\", \"left_only\", \"right_only\") and _matchCount. Set false for rows with only your own fields."
    },
    "multipleMatches": {
      "enum": [
        "all",
        "first"
      ],
      "type": "string",
      "description": "When one key matches several right rows. all (default): one output row per matching pair, like SQL. first: only the first matching right row, like VLOOKUP, so each left row appears once."
    },
    "onFieldConflict": {
      "enum": [
        "prefixRight",
        "keepLeft",
        "keepRight"
      ],
      "type": "string",
      "description": "When a right field has the same name as a left field. prefixRight (default): keep both, the right one renamed with rightFieldPrefix. keepLeft: ignore the right value. keepRight: overwrite the left value."
    },
    "rightFieldPrefix": {
      "type": "string",
      "description": "Prefix for conflicting right fields when onFieldConflict is prefixRight. Default \"right_\", so price becomes right_price."
    }
  },
  "additionalProperties": false
}