# 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. Merge JSON row sets, drop duplicates and get stable-order JSON and CSV, per batch. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Paid
- **Platforms:** API
- **Website:** https://apify.com/hermeskd/dataset-json-cleaner
- **MCP Registry name:** io.github.kriton-dev/dataset-json-cleaner
- **Categories:** files and documents, analytics and data, developer tools
- **Listing updated:** 2026-11-15

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://mcp.apify.com/?tools=hermeskd/dataset-json-cleaner
```

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## Tools

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

## 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

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.

---
Source: https://ai-powered.com/mcp/merge-json-datasets-deduplicate-rows-and-export-stable-csv
