# Data Cleaner

> Data Cleaner is an MCP server for analytics and data. Remote MCP server that turns messy CSV, Excel, JSON or XML files into clean tables for AI. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Platforms:** API, Web
- **Website:** https://data-cleaner.com/mcp/
- **MCP Registry name:** com.data-cleaner/data-cleaner
- **Categories:** analytics and data
- **Listing updated:** 2026-11-18

## About

The server takes a file or a URL and returns a cleaned, typed table that an assistant can page through, filter and query with SQL. The site says it runs remotely over streamable HTTP, so there is nothing to install on your machine; you add its address to a client such as Claude or any other MCP-compatible app.

For files on your own computer, the assistant requests an upload link, and the file is sent from your browser directly to the server. Results can be exported as CSV, Excel, JSON or Parquet through a download link.

The page says each table is private, reachable only through its table_id, and deleted after 90 days. An API key is optional and is passed as a bearer token from clients that can set headers. It suits analysts and developers who want an assistant to work with messy tabular data without writing parsing code first.

## Features

- **Remote MCP endpoint:** Runs as a streamable HTTP server, so clients connect by URL without a local install.
- **Multi-format ingestion:** Accepts CSV, Excel, JSON and XML files as well as files reached by URL.
- **Browser-based file upload:** Local files go from the browser straight to the server through a generated upload link.
- **SQL querying:** Lets the assistant run SQL against the cleaned table.
- **Paged table access:** Tools let an assistant describe, page through and filter rows.
- **Export formats:** Download results as CSV, Excel, JSON or Parquet.

## Good for

- Cleaning a messy sales export before analysis in an AI chat
- Querying a CSV or spreadsheet at a public URL with SQL through an assistant
- Converting XML or JSON feeds into a typed table for review
- Exporting a cleaned dataset as Parquet or Excel for downstream tools

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http data-cleaner https://mcp.data-cleaner.com/mcp
```

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

```sh
https://mcp.data-cleaner.com/mcp
```

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

```json
{
  "mcpServers": {
    "data-cleaner": {
      "url": "https://mcp.data-cleaner.com/mcp"
    }
  }
}
```

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

```json
{
  "servers": {
    "data-cleaner": {
      "type": "http",
      "url": "https://mcp.data-cleaner.com/mcp"
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "data-cleaner": {
      "serverUrl": "https://mcp.data-cleaner.com/mcp"
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "data-cleaner": {
      "type": "http",
      "url": "https://mcp.data-cleaner.com/mcp"
    }
  }
}
```

## Tools

- `fetch`: Fetches a URL into a table.
- `upload_request`: Requests an upload link for a local file.
- `upload_confirm`: Confirms an uploaded file.
- `describe`: Describes a table.
- `rows`: Returns rows from a table.
- `wrangle`: Cleans and transforms a table.
- `sql_query`: Runs a SQL query on a table.
- `export`: Produces a download link as CSV, Excel, JSON or Parquet.

## FAQ

### Do I need to install anything?

The site says it is a remote MCP server and nothing needs to be installed. You add the server URL to your MCP client.

### Is a API key required?

No key is needed according to the site. With a key, it is sent as a bearer token from a client that can set headers.

### How long is my data kept?

The site says every table is private and is deleted after 90 days.

### Can I upload a file from my computer?

Yes. The assistant requests an upload link, opens an upload page, and the file goes from your browser straight to the server.

### How do I add Data Cleaner to Claude Code?

Run this command in your terminal: claude mcp add --transport http data-cleaner https://mcp.data-cleaner.com/mcp

### What are the best alternatives to Data Cleaner?

The closest alternatives to Data Cleaner are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, World Monitor and DataArcus for Power BI.

## Where this comes from

- Description: written from the project's website and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.

## 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.
- [DataArcus for Power BI](https://ai-powered.com/mcp/dataarcus-for-power-bi): DataArcus for Power BI is a free MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ImportYeti Scraper (Apify) - US import records and bills of lading](https://ai-powered.com/mcp/importyeti-scraper-apify-us-import-records-and-bills-of-ladi): ImportYeti Scraper (Apify) - US import records and bills of lading is a paid MCP server for web search and scraping.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.

---
Source: https://ai-powered.com/mcp/data-cleaner
