Skip to content
MCP server

data-cleanup: fix a messy CSV before you load it

Clean a messy CSV in one call: trim, ISO dates, tidy emails and phones, merge dupes

Install
Pricing
Paid
Platforms
API, Web
Runs
Remotely
Version
1.0.1
Listing updated
2 days ago

About data-cleanup: fix a messy CSV before you load it

data-cleanup: fix a messy CSV before you load it is a paid MCP server for files and documents. It runs as a hosted remote server, so there is nothing to install locally.

Processing is deterministic and uses no AI. Input is an https link to a CSV or inline text, up to 1 MB or 20,000 rows. The response is the cleaned CSV plus a JSON change report counting rows in and out, exact and fuzzy duplicates and cells changed.

Most behaviour is set through parameters. key_columns picks the columns used to detect duplicates, dedupe chooses merge, flag or none, and fuzzy matching defaults to a 0.92 similarity threshold. Dates become ISO 8601, with date_order set to mdy or dmy for ambiguous values. Phones are reduced to digits or E.164, emails are lowercased, and case_rules can force lower, upper or title case per column.

A call costs $0.005 in USDC on Base through x402 and is settled only on success. The tool is also exposed as data-cleanup over streamable HTTP MCP. The operator says nothing is stored and provides it as is.

Install

Run in a terminal

claude mcp add --transport http data-cleanup https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp

Add to Settings → Connectors → Add custom connector

https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "data-cleanup": {
      "url": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "data-cleanup": {
      "type": "http",
      "url": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}

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

{
  "mcpServers": {
    "data-cleanup": {
      "serverUrl": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}

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

{
  "mcpServers": {
    "data-cleanup": {
      "type": "http",
      "url": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}

Tools this server provides (1)

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

data-cleanup
Cleans a CSV and returns the cleaned file with a JSON change report.

What it does

Duplicate merge or flag
Finds exact and fuzzy duplicate rows on chosen key columns and merges or flags them.
ISO 8601 dates
Converts date columns, with a choice of month-first or day-first for ambiguous values.
Email and phone tidying
Lowercases emails and normalises phones to digits or E.164.
Per-column case rules
Applies lower, upper or title case to named columns.
JSON change report
Reports rows in and out, duplicate counts and cells changed.
Deterministic processing
The operator says it uses no AI and stores nothing.

Good for

  • Prepare a spreadsheet export before a CRM import
  • Deduplicate a mailing list by email
  • Standardise dates before loading a database
  • Clean a CSV before charting it

Pricing

Paid

$0.005 per call in USDC via x402

Prices change. Check well-016-datacleanup.rainmaker-wells.workers.dev before you buy.

data-cleanup: fix a messy CSV before you load it FAQ

What size of file can it handle?

Up to 1 MB or 20,000 rows, supplied as inline text or a public https URL.

Does it use AI?

No. The operator describes it as deterministic.

What does it cost?

$0.005 per call in USDC on Base via x402, settled only on success.

Can it catch near-duplicates?

Yes. Fuzzy matching is on by default with a 0.92 similarity threshold you can change between 0.5 and 1.

Is data-cleanup: fix a messy CSV before you load it free?

No. data-cleanup: fix a messy CSV before you load it is a paid product.

How do I add data-cleanup: fix a messy CSV before you load it to Claude Code?

Run this command in your terminal: claude mcp add --transport http data-cleanup https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp

What are the best alternatives to data-cleanup: fix a messy CSV before you load it?

The closest alternatives to data-cleanup: fix a messy CSV before you load it are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, World Monitor and CompanyData.

Alternatives to data-cleanup: fix a messy CSV before you load it

  1. 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
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  5. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data
  6. ASTra

    MCP server

    Let agents read, edit, validate and undo Word .docx files with exact operations

    Runs locally
    • 5 tools
    • Freemium
    • Files and documents