Skip to content
MCP server

Merge JSON Datasets — Deduplicate Rows & Export Stable CSV

Merge JSON row sets, drop duplicates and get stable-order JSON and CSV, per batch

Install
Pricing
Paid
Platforms
API
Runs
Remotely
Version
1.0.5
Listing updated
2 days ago

About Merge JSON Datasets — Deduplicate Rows & Export Stable CSV

Merge JSON Datasets — Deduplicate Rows & Export Stable CSV is a paid MCP server for files and documents. It runs as a hosted remote server, so there is nothing to install locally.

The work is deliberately narrow: you hand it batches of object rows as JSON strings and it combines them, removes duplicates and returns the rows in first-seen order. Duplicates can be judged on chosen top-level key fields or on full-row equality, and a CSV copy comes back alongside the JSON.

A bundled example merges two small arrays with SKU and quantity and reports input rows, output rows and duplicates removed. CSV output follows RFC 4180 and prefixes spreadsheet formula cells with a quote, which matters when the file is opened in Excel.

It is an Apify Actor by hermeskd exposed through Apify's MCP server. Nothing is fetched from the network: no storage IDs, URLs, credentials, scripts or joins are accepted, only caller-supplied arrays. Each batch can hold up to 1,000 rows and 1 MB.

Install

Run in a terminal

claude mcp add --transport http dataset-json-cleaner 'https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner'

Add to Settings → Connectors → Add custom connector

https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "dataset-json-cleaner": {
      "url": "https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "dataset-json-cleaner": {
      "type": "http",
      "url": "https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "dataset-json-cleaner": {
      "serverUrl": "https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner"
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "dataset-json-cleaner": {
      "type": "http",
      "url": "https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner"
    }
  }
}

Tools this server provides (2)

Taken from the project documentation; the running server may differ.

call-actor
Runs the hermeskd/dataset-json-cleaner Actor on supplied batches
get-dataset-items
Reads the cleaned rows from the run's dataset

What it does

Multi-batch merge
Takes 1 to 20 batches per run.
Key-based dedupe
Deduplicates on comma-separated key fields, or on whole rows.
Stable row order
Keeps rows in first-seen order.
Safe CSV export
RFC 4180 output with formula cells quoted.
Run statistics
Reports input rows, output rows and duplicates removed.
Pay per batch
Charged per successful batch, not per row.

Good for

  • Combine exports from several systems into one table
  • Remove repeated records before loading a database
  • Produce a CSV for a spreadsheet from JSON rows
  • Let an agent clean a dataset it already holds in memory

Pricing

Paid

Pay per event: $0.0012 per batch of up to 1,000 rows, plus a start fee

Prices change. Check apify.com before you buy.

Merge JSON Datasets — Deduplicate Rows & Export Stable CSV FAQ

What are the limits?

Up to 20 batches per run, 1,000 object rows and 1 MB per batch.

What does it cost?

$0.0012 per successful batch at list price, plus an Apify start fee; failures are not charged.

Can it join datasets or fetch URLs?

No. It only merges and deduplicates arrays you supply.

Which key fields can I use?

Top-level fields only, given as a comma-separated list; empty means full-row equality.

Is Merge JSON Datasets — Deduplicate Rows & Export Stable CSV free?

No. Merge JSON Datasets — Deduplicate Rows & Export Stable CSV is a paid product.

How do I add Merge JSON Datasets — Deduplicate Rows & Export Stable CSV to Claude Code?

Run this command in your terminal: claude mcp add --transport http dataset-json-cleaner 'https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner'

What are the best alternatives to Merge JSON Datasets — Deduplicate Rows & Export Stable CSV?

The closest alternatives to Merge JSON Datasets — Deduplicate Rows & Export Stable CSV are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

Alternatives to Merge JSON Datasets — Deduplicate Rows & Export Stable CSV

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data