Merge JSON Datasets — Deduplicate Rows & Export Stable CSV
Merge JSON row sets, drop duplicates and get stable-order JSON and CSV, per batch
- 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-cleanerAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"dataset-json-cleaner": {
"url": "https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner"
}
}
}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

REA
MCP serverCLI and MCP server that lets coding agents reverse engineer apps and binaries
Runs locally- Open source
- 464K GitHub stars
- Developer tools

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

GitHub
MCP serverOfficial MCP server connecting AI assistants to GitHub repos, issues and workflows
Not checked yet- Remote
- Open source
- 34.5K GitHub stars
- Developer tools

Serena MCP: the IDE for your agent
MCP serverMCP toolkit giving coding agents symbol-level code retrieval and editing
Runs locally- Open source
- 31.5K GitHub stars
- Developer tools

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Agent-Native Analytics
MCP serverOpen-source analytics app where an AI agent builds charts and dashboards from your data
- Remote
- Open source
- 7.7K GitHub stars
- Analytics and data