Dataset Join & Merge MCP server

Dataset Join & Merge (Remote MCP Server)

Join two lists of JSON rows on a shared key, like a SQL join or a spreadsheet VLOOKUP, in a single tool call. Hand it a main list and a lookup list, name the key, pick a join type, and it hands back one combined list plus an exact account of how many rows matched on each side and why the rest did not.

Built for AI agents. No install, no API key, no signup. Connect by URL and call it.

https://dataset-join-merge.nerolabs.workers.dev/mcp

Free to use while in early access.

What it does

• Seven join types. left keeps every left row and adds the matching right fields (the VLOOKUP and enrichment case, and the default). inner keeps only the overlap. right keeps every right row. full keeps everything from both sides. leftAnti returns left rows with no match on the right ("which of these leads are not in the CRM yet?"). rightAnti is the reverse. union stacks both lists, no key needed.
• Keys that match the way real data looks. By default keys match case-insensitively with surrounding and repeated spaces ignored, and 123 matches "123", so " Ana@Example.com" from a scraper finds "ana@example.com" in a billing export. Set keyMatching to exact for strict matching.
• Different key names on each side. email on the left, contact_email on the right. Composite keys work too: ["firstName", "lastName"].
• Control over what comes across. Copy only chosen right fields, and decide what happens when both sides have a field with the same name: keep both (the right one becomes right_status), keep the left value, or overwrite with the right value.
• SQL or VLOOKUP behaviour for duplicate keys. multipleMatches: "all" returns one row per matching pair; "first" uses only the first matching right row, so each left row appears once.

It is honest about what it could not match. Every row is tagged joinStatus (matched, leftonly, rightonly) and matchCount, and the summary reports match rates plus warnings for rows missing the key, duplicate keys on the right and key fields that exist on no row at all (usually a typo).

Tools

Connect

Claude Code

claude mcp add --transport http dataset-join-merge https://dataset-join-merge.nerolabs.workers.dev/mcp

Claude Desktop / claude.ai: Settings, Connectors, Add custom connector, paste the URL above.

Cursor, Windsurf, VS Code and other MCP clients

{
  "mcpServers": {
    "dataset-join-merge": {
      "url": "https://dataset-join-merge.nerolabs.workers.dev/mcp"
    }
  }
}

Example

Four scraped leads on the left, three billing records on the right. The emails differ in case and spacing, and the key has a different name on each side:

{
  "leftRows": [
    {"email": "Ana@Example.com ", "name": "Ana Silva", "status": "lead"},
    {"email": "ben@example.com", "name": "Ben Okafor", "status": "lead"},
    {"email": "cara@example.com", "name": "Cara Lind", "status": "lead"},
    {"email": "dev@example.com", "name": "Dev Patel", "status": "lead"}
  ],
  "rightRows": [
    {"contact_email": "ana@example.com", "plan": "Pro", "mrr": 49, "status": "active"},
    {"contact_email": "BEN@EXAMPLE.COM  ", "plan": "Starter", "mrr": 19, "status": "trial"},
    {"contact_email": "erin@example.com", "plan": "Enterprise", "mrr": 499, "status": "active"}
  ],
  "leftKeyFields": ["email"],
  "rightKeyFields": ["contact_email"],
  "joinType": "left"
}

Every lead comes back, the two customers enriched with their plan, and both status fields kept:

Shortened. The full README is on GitHub.