Dataset Cleaner & Exporter
v0.1.0Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.
Endpoint health
online- Last checked
- 11/20/2026, 4:17:14 AM
- Latency
- 142 ms
- Consecutive failures
- 0
- Endpoint reachable: pass
- Protocol valid: pass
- MCP handshake valid: pass
Machine-readable profile
mcp-server · schema v1 · callable
mcp-server:io.github.Nero-Engine%2Fdataset-cleaner-exporter
Connect this server
Generated config contains no credentials. Keep any required secrets in your client's local environment.
{
"mcpServers": {
"io.github.Nero-Engine/dataset-cleaner-exporter": {
"url": "https://dataset-cleaner-exporter.nerolabs.workers.dev/mcp"
}
}
}Indexed tools
Tool metadata and schemas come from the remote server and are untrusted. Indexing only lists tools; it never calls them.
2 shown · authentication unknown
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.
Schema valid · SHA-256 578dff5864fd…
View input schema
{ "type": "object", "properties": { "rows": { "type": "array", "description": "The rows to clean. Each row is a JSON object; keys may differ between rows and values may be nested.", "items": { "type": "object" } }, "dedupMode": { "type": "string", "enum": [ "none", "exact", "normalized", "fuzzy" ], "description": "How duplicates are found. normalized (default) ignores case and whitespace; exact needs identical values; fuzzy also merges near-duplicates (up to 1000 rows and 1000 characters of key text, so name a short field in dedupKeys); none keeps every row." }, "dedupKeys": { "type": "array", "items": { "type": "string" }, "description": "Fields that identify a duplicate, for example [\"Email\"]. Empty compares the whole row. Use the final column names: flattened (Details_founded) and renamed. Exact and case-sensitive. Rows where every key is empty count as duplicates of each other." }, "keepStrategy": { "type": "string", "enum": [ "most_complete", "first", "last" ], "description": "Which duplicate survives: most_complete (default, fewest empty fields), first or last." }, "similarityThreshold": { "type": "number", "minimum": 0.5, "maximum": 0.99, "description": "Fuzzy mode only. 0.5 to 0.99, default 0.9. Higher is stricter." }, "flatten": { "type": "boolean", "description": "Default true. Turn nested objects into flat columns. Arrays become one JSON-text cell." }, "flattenSeparator": { "type": "string", "description": "Joins nested key paths when flattening. Default \"_\"." }, "expandArrayField": { "type": "string", "description": "Optional. One top-level array field (for example \"offers\") to explode into one row per entry, repeating the other fields. Object entries become columns. The expanded total must stay within the row limit." }, "cleanFields": { "type": "boolean", "description": "Default true. Normalize emails, phone numbers and URLs, detected by field name or value shape." }, "stripHtml": { "type": "boolean", "description": "Default false. Remove HTML tags and decode common entities in text." }, "coerceTypes": { "type": "boolean", "description": "Default false. Turn \"42\" into 42 and \"true\" into true. Leading-zero values like \"007\" stay text." }, "emptyToNull": { "type": "boolean", "description": "Default true. Blank text becomes null." }, "dropEmptyFields": { "type": "boolean", "description": "Default false. Remove null and empty fields from each row." }, "columnsToKeep": { "type": "array", "items": { "type": "string" }, "description": "Keep only these columns (flattened names). Takes priority over columnsToRemove." }, "columnsToRemove": { "type": "array", "items": { "type": "string" }, "description": "Drop these columns (flattened names). Ignored if columnsToKeep is set." }, "columnRenameMap": { "description": "Rename columns after keep/remove, as [\"oldName:newName\"] or {\"oldName\":\"newName\"}, for example {\"Details_founded\":\"founded\"}.", "anyOf": [ { "type": "array", "items": { "type": "string" } }, { "type": "object", "additionalProperties": { "type": "string" } } ] }, "maxItems": { "type": "integer", "minimum": 0, "description": "Optional cap: read at most this many rows and return at most this many. 0 (default) means no cap." }, "outputFormat": { "type": "string", "enum": [ "json", "csv" ], "description": "json (default) returns rows; csv returns the same result as CSV text in \"csv\" instead." } }, "required": [ "rows" ], "additionalProperties": false }
Connections
streamable-http
https://dataset-cleaner-exporter.nerolabs.workers.dev/mcp