# DataClean

> DataClean is a freemium MCP server for files and documents. Deterministic MCP server that profiles, cleans and validates CSV and Excel tables. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** API, CLI
- **Website:** https://mcp.keyflint.dev
- **Repository:** https://github.com/arceedev/dataclean-mcp
- **MCP Registry name:** io.github.ArceeDev/dataclean-mcp
- **Categories:** files and documents, analytics and data
- **Listing updated:** 2026-11-14

## About

DataClean exists because language models misread messy tables: they swap day and month, misparse `1.250,50 €`, and drop leading zeros. It applies fixed rules instead, and an ambiguous value is kept as it was and flagged, converted only when the rest of its column or a parameter you pass settles the meaning.

It reads CSV in UTF-8, UTF-16 or Windows-1252 with auto-detected delimiters, plus xlsx, JSON and JSONL. Clean output can be CSV, TSV, JSON, JSONL or typed xlsx, with dates in ISO 8601, phones in E.164 and IBANs compacted. Cells starting with formula characters are prefixed so spreadsheets do not execute them.

Use costs credits per call: the four working tools cost 1 credit each, while `pricing` and `credits_balance` are free. Invalid input is refused before charging and later failures are refunded. Limits default to 20 MB input and 200,000 rows. A KeyFlint license is required; the site offers 25 free credits without a card.

## Features

- **Table profiling:** Reports encoding, delimiter, column types, locale, duplicates and a suggested schema.
- **Typed cleaning:** Returns a cleaned copy in CSV, TSV, JSON, JSONL or typed xlsx.
- **Schema validation:** Checks rows against type, required, unique, range, enum and pattern rules.
- **Never guesses:** Flags ambiguous numbers and dates rather than converting them.
- **Safe output:** Neutralises formula-like cells and refuses ReDoS-prone regexes.
- **Pay per call:** Credits are charged per call and refunded on failure.

## Good for

- Clean a European-format export before analysis
- Check a CSV against a schema and list bad rows
- Find duplicate rows and mixed date orders
- Convert messy xlsx data to typed output

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http dataclean-mcp https://mcp.keyflint.dev/dataclean/mcp
```

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

```sh
https://mcp.keyflint.dev/dataclean/mcp
```

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

```json
{
  "mcpServers": {
    "dataclean-mcp": {
      "url": "https://mcp.keyflint.dev/dataclean/mcp"
    }
  }
}
```

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

```json
{
  "servers": {
    "dataclean-mcp": {
      "type": "http",
      "url": "https://mcp.keyflint.dev/dataclean/mcp"
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "dataclean-mcp": {
      "serverUrl": "https://mcp.keyflint.dev/dataclean/mcp"
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "dataclean-mcp": {
      "type": "http",
      "url": "https://mcp.keyflint.dev/dataclean/mcp"
    }
  }
}
```

## Tools

- `profile_table`: Profile a table's encoding, columns and problems
- `clean_table`: Return a clean, typed copy of a table
- `validate_schema`: Check rows against a schema
- `normalize_values`: Normalise a list of values
- `pricing`: Show credit prices
- `credits_balance`: Show remaining credits

## FAQ

### How does it handle 03/04/2026?

It converts it only when other values in the column or the date_order parameter settle the order; otherwise it is flagged.

### What does it cost?

profile_table, clean_table, validate_schema and normalize_values cost 1 credit each; the helpers are free.

### What are the size limits?

Defaults are 20 MB input, 200,000 rows and 15 MB output, adjustable by environment variables.

### Is a license needed?

Yes, a KeyFlint license (LIC-...) is required, and the site offers 25 free credits.

### Is DataClean free?

DataClean has a free plan, with paid plans for more usage or features.

### How do I add DataClean to Claude Code?

Run this command in your terminal: claude mcp add --transport http dataclean-mcp https://mcp.keyflint.dev/dataclean/mcp

### What are the best alternatives to DataClean?

The closest alternatives to DataClean are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, World Monitor and CompanyData.

## Alternatives

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ASTra](https://ai-powered.com/mcp/astra): ASTra is a freemium MCP server for files and documents.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.
- [Quantivex Research](https://ai-powered.com/mcp/quantivex-research): Quantivex Research is a free MCP server for finance and payments.

---
Source: https://ai-powered.com/mcp/dataclean
