Dataset Join & Merge
v0.1.0Join two lists of JSON rows on a key, like SQL or VLOOKUP: left, inner, full, anti joins, union.
Endpoint health
online- Last checked
- 11/20/2026, 4:17:13 AM
- Latency
- 66 ms
- Consecutive failures
- 0
- Endpoint reachable: pass
- Protocol valid: pass
- MCP handshake valid: pass
Machine-readable profile
mcp-server · schema v1 · callable
mcp-server:io.github.Nero-Engine%2Fdataset-join-merge
Connect this server
Generated config contains no credentials. Keep any required secrets in your client's local environment.
{
"mcpServers": {
"io.github.Nero-Engine/dataset-join-merge": {
"url": "https://dataset-join-merge.nerolabs.workers.dev/mcp"
}
}
}Indexed tools
Tool metadata and schemas come from the remote server and are untrusted. Indexing only lists tools; it never calls them.
2 shown · authentication unknown
join_rows
Joins two lists of JSON rows on a shared key, like a SQL join or a spreadsheet VLOOKUP, and returns the combined rows plus a summary: how many rows matched on each side, match rates, and warnings for duplicate keys, rows missing the key and key fields that exist on no row. Use it to enrich a list with fields from a lookup table (left join), keep only the overlap (inner), combine two sources into one table (full), find rows in one list that are missing from the other (leftAnti or rightAnti), or stack two same-shape lists (union). Keys match case-insensitively with whitespace trimmed by default, and the key can have a different name on each side (email on the left, contact_email on the right). Input and output rows are capped per call; a many-to-many join that would exceed the output cap is refused with the predicted row count, never truncated. Call list_capabilities for the exact limits.
Schema valid · SHA-256 486689caa99c…
View input schema
{ "type": "object", "properties": { "leftRows": { "type": "array", "description": "The LEFT table: the main rows you want to keep or enrich. Each row is a JSON object; keys may differ between rows.", "items": { "type": "object" } }, "rightRows": { "type": "array", "description": "The RIGHT table: the lookup rows to pull matching fields from. Each row is a JSON object.", "items": { "type": "object" } }, "leftKeyFields": { "type": "array", "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.", "items": { "type": "string" } }, "rightKeyFields": { "type": "array", "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.", "items": { "type": "string" } }, "joinType": { "type": "string", "enum": [ "left", "inner", "right", "full", "leftAnti", "rightAnti", "union" ], "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." }, "keyMatching": { "type": "string", "enum": [ "normalized", "exact" ], "description": "normalized (default): case-insensitive, trimmed, repeated spaces collapsed, 123 matches \"123\". exact: values must be identical." }, "rightFields": { "type": "array", "description": "Only copy these fields from the matching right row, like choosing VLOOKUP return columns. Leave out to copy every right field.", "items": { "type": "string" } }, "onFieldConflict": { "type": "string", "enum": [ "prefixRight", "keepLeft", "keepRight" ], "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." }, "multipleMatches": { "type": "string", "enum": [ "all", "first" ], "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." }, "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." } }, "required": [ "leftRows", "rightRows" ], "additionalProperties": false }
Connections
streamable-http
https://dataset-join-merge.nerolabs.workers.dev/mcp