Dataset Cleaner & Exporter

io.github.Nero-EnginePublished by GitHub account Nero-Enginev0.1.0Updated Oct 25, 2026

Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.

VerifiedStreamable HTTPWeb executableFiles & StorageData & Analytics

Overview

AI-generated overview

A remote MCP server that deduplicates, flattens and cleans messy JSON rows into spreadsheet-ready JSON or CSV in one call.

What you can do
Inspect the exact cleaning rules, dedup modes, keep strategies, step order and row limits before processing anything, without sending data.
When to use it
Use it when an assistant has a small batch of messy rows from a scraper, CRM export or API and needs them deduplicated, flattened and normalized before saving or analysis. It suits quick, deterministic cleanup of up to 150 rows per call rather than large datasets or file-based imports.
Requirements
A remote MCP endpoint connected by URL; no install, API key or signup is declared. Rows are passed inline as JSON, and network access to the hosted endpoint is needed.
Before you install
Rows are sent to a third-party hosted service; the README says they are processed in memory and not stored, while each call logs tool name, row counts, success, client name, country and a hashed caller ID. Cleaning rewrites values such as emails, phones and URLs, so review output before relying on it. Free only during early access.

Installation

In SourceWeft

  1. Open Dataset Cleaner & Exporter in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/io.github.Nero-Engine%2Fdataset-cleaner-exporter/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "dataset-cleaner-exporter": {
      "type": "http",
      "url": "https://dataset-cleaner-exporter.nerolabs.workers.dev/mcp"
    }
  }
}

README

Dataset Cleaner & Exporter (Remote MCP Server)

Deduplicate, flatten and clean messy JSON rows in a single tool call. Hand it a list of rows from a scraper, a CRM export or an API, and it hands back clean, spreadsheet-ready rows (or CSV text) plus an exact account of what was merged and why.

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

https://dataset-cleaner-exporter.nerolabs.workers.dev/mcp

Free to use while in early access.

What it does

One call runs a fixed pipeline, in this order:

  1. Expand (optional) one array field, such as offers or variants, into one row per entry, repeating the other fields.
  2. Flatten nested objects into columns: address.city becomes address_city. Arrays stay as one JSON-text cell.
  3. Clean every value: trim text, lowercase valid emails, reduce phone numbers to digits (keeping a leading +), lowercase URL hosts and drop the trailing slash, and optionally strip HTML and turn "42" and "true" into real numbers and booleans. Blank text becomes null.
  4. Keep, remove or rename columns.
  5. Deduplicate on the fields you name, or the whole row: exact, normalized (ignores case and whitespace, the default) or fuzzy (near-duplicates). The most complete row survives.

Deterministic, no AI in the loop, nothing guessed. A value it cannot confidently read, such as "not-an-email" in an email column, is left exactly as it was. The summary tells you how many rows came in, how many duplicates were removed, how many rows went out, how full every column is, and warns you when something needs a look, for example rows with an empty dedup key, which are kept as they are rather than merged with each other.

Tools

ToolWhat it does
list_capabilitiesLists the exact cleaning rules, dedup modes, keep strategies, step order and limits. Processes no data.
clean_rowsRuns the pipeline on the rows you pass and returns the clean rows (or CSV text) plus a summary.

Connect

Claude Code

bash
claude mcp add --transport http dataset-cleaner-exporter https://dataset-cleaner-exporter.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

json
{  "mcpServers": {    "dataset-cleaner-exporter": {      "url": "https://dataset-cleaner-exporter.nerolabs.workers.dev/mcp"    }  }}

Example

Five messy lead rows go in, two of them duplicates with different casing and whitespace:

json
{  "rows": [    {"company": "  Acme Corp  ", "email": "[email protected]", "phone": "+1 (555) 123-4567", "website": "HTTPS://Acme.com/", "address": {"city": "Austin", "state": "TX"}},    {"company": "Acme Corp", "email": "[email protected] ", "phone": "555.123.4567", "website": "https://acme.com", "address": {"city": "Austin", "state": ""}},    {"company": "Globex Inc", "email": " [email protected]", "phone": "+1 555 987 6543", "website": "https://globex.io/", "address": {"city": "Denver", "state": "CO"}, "notes": "<b>Hot</b> lead &amp; ready"},    {"company": "globex inc", "email": "[email protected]", "phone": "", "website": "", "address": {"city": "Denver", "state": "CO"}},    {"company": "Initech", "email": "[email protected]", "phone": "(555) 010-0199", "website": "http://www.INITECH.com/about/", "address": {"city": "Dallas", "state": "TX"}}  ],  "dedupKeys": ["email"],  "stripHtml": true}

Three clean rows come out. Each duplicate pair kept its more complete row:

json
{  "rows": [    {"company": "Acme Corp", "email": "[email protected]", "phone": "+15551234567", "website": "https://acme.com", "address_city": "Austin", "address_state": "TX"},    {"company": "Globex Inc", "email": "[email protected]", "phone": "+15559876543", "website": "https://globex.io", "address_city": "Denver", "address_state": "CO", "notes": "Hot lead & ready"},    {"company": "Initech", "email": "[email protected]", "phone": "5550100199", "website": "http://www.initech.com/about", "address_city": "Dallas", "address_state": "TX"}  ],  "summary": {    "inputRowCount": 5,    "rowsAddedByExpansion": 0,    "duplicatesRemoved": 2,    "droppedByMaxItems": 0,    "outputRowCount": 3,    "dedupModeUsed": "normalized",    "columns": ["company", "email", "phone", "website", "address_city", "address_state", "notes"],    "fillRates": {"company": 1, "email": 1, "phone": 1, "website": 1, "address_city": 1, "address_state": 1, "notes": 0.333},    "warnings": []  }}

Add "outputFormat": "csv" to get the same result back as CSV text, ready to save as a file.

Limits

  • Up to 150 rows per call, counted after any array expansion. For bigger lists, split them across several calls. Anything larger returns a clear message rather than failing silently.
  • Fuzzy deduplication compares every pair of rows, so it runs on up to 100 rows with at most 1,000 characters of key text in total. Name a short field in dedupKeys, such as a company name. Beyond that it falls back to normalized matching and says so in the warnings.
  • Rows are passed inline as JSON. Output is JSON rows or CSV text; there is no Excel file.

Privacy

Your rows are processed in memory and never stored. To see which tools get used, each call records the tool name, row counts, whether it succeeded, the client name your app reports, the country and a one-way hashed caller ID. Your data, your arguments and your IP address are never kept in that log.

Also available

The same engine runs on the Apify Store as Dataset Cleaner & Exporter, which also reads Apify datasets, CSV, Excel and JSON files by URL and Google Sheets, handles up to 100,000 records per run, exports real downloadable CSV and Excel files, appends to a named dataset that accumulates across scheduled runs, and pushes the result to a webhook when a run finishes.

Built by Nero Labs.

Source: README.md at commit 91cfd85

Tools

2

list_capabilities

Returns the exact cleaning rules (how emails, phone numbers and URLs are detected and normalized), the dedup modes and keep strategies, the order the steps run in, and the maximum rows per call. Call this first if you are unsure how a field will be treated. Free, processes no data.

Takes no parameters.

clean_rows

Deduplicates, flattens and cleans a list of JSON rows in one call and returns spreadsheet-ready rows (or CSV text) plus a summary with exact counts: rows in, rows added by expansion, duplicates removed, rows dropped by maxItems, rows out, the final column list, per-column fill rates and warnings. Steps, in order: optionally explode one array field into one row per entry; flatten nested objects into columns (address.city becomes address_city); trim text; lowercase valid emails; reduce phone numbers to digits with any leading +; lowercase URL hosts and drop the trailing slash; optionally strip HTML and turn numeric or true/false text into numbers and booleans; blank text becomes null; keep, remove or rename columns; then remove duplicates (normalized by default, comparing the whole row unless dedupKeys is set) keeping the most complete row. Deterministic, no AI, nothing guessed. Use it on scraped leads, CRM exports or API results before loading them anywhere. There is a row limit per call (see list_capabilities); split bigger lists across several calls.

ParametersrowsrequiredflattenmaxItemsdedupKeysdedupModestripHtmlcleanFieldscoerceTypesemptyToNullkeepStrategyoutputFormatcolumnsToKeep+6 more

Version history

1
  1. v0.1.0LatestSep 16, 2026

Score

90% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listedRequired15 pts
  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts

    Declare a license in the repository or the registry entry.