DataClean

io.github.ArceeDev由 GitHub 账号 ArceeDev 发布v0.2.0更新于 Nov 7, 2026

Profile, clean and validate CSV/Excel data: schemas, dates, numbers, duplicates. Never guesses.

发布方自己的服务：Clean

已验证Streamable HTTP可网页运行文件与存储数据与分析

服务详情

标识符: io.github.ArceeDev/dataclean-mcp
传输: Streamable HTTP
运行时: Web executable
信任: Verified
发布于: Nov 7, 2026

安全提示

MCP 服务会接收对话中的工具调用请求，并可能执行外部操作。启用前请先了解该服务能做什么，并只授予它所需的权限。

注册中心已验证此条目所属的 GitHub 账号 ArceeDev。这并不表明该账号就是产品方。

SourceWeft 的检查只涵盖条目是否完整、端点是否响应；不审查服务器的代码，也不审查其工具的行为。

在 README 中添加徽章

向读者展示该 MCP 服务已收录于 SourceWeft，徽章链接到本页。

[![Listed on SourceWeft](https://sourceweft.com/badge/mcp/io.github.ArceeDev%2Fdataclean-mcp.svg)](https://sourceweft.com/mcp/io.github.ArceeDev%2Fdataclean-mcp?utm_source=readme&utm_medium=badge)

概览

AI 生成的概览

DataClean 以确定性规则对 CSV/Excel 表格做剖析、清洗、规范化和校验，遇到歧义值只标记而不猜测。

可以做什么: 剖析表格：识别编码、分隔符、表头行、各列真实类型、数字区域格式、日期顺序、空值、重复行，并给出建议 schema
清洗表格：修剪并修复文本，转换数字、ISO 日期、E.164 电话和 IBAN，去重行，输出 CSV、TSV、JSON、JSONL 或带类型的 xlsx
按 schema 校验每行数据，检查类型、必填、唯一、范围、长度、枚举和正则，并返回带行号的错误
规范化最多 10,000 个零散值，如金额、日期、电话或邮箱
用免费辅助工具查询积分余额和价格
适用场景: 当助手需要处理杂乱的电子表格或 CSV 导出，并希望按规则而非猜测来转换数值时使用。适合分析前的数据准备、对来件做 schema 校验，以及规范化文档中的金额、日期或标识符。
运行要求: 需要 KeyFlint 许可证密钥：本地 stdio 安装（uvx 或 Claude Desktop 捆绑包）通过环境变量 KEYFLINT_LICENSE 提供，托管 HTTP 模式则通过 Authorization 请求头以 Bearer 方式提供。付费工具需购买积分。可用环境变量设置大小与行数上限及价格覆盖。

安装前请注意

付费工具每次调用消耗积分，会产生费用；无法读取的输入在扣费前即被拒绝，扣费后失败会退款。许可证密钥属于机密，不应写入共享配置。清洗结果会写入文件或返回客户端；CSV 输出中以公式字符开头的文本单元格会被加前缀，以防表格软件执行公式。

安装

在 SourceWeft 中

打开控制台中的 DataClean，将其添加到工作区。
连接所需的凭据。它们会被私密存储，绝不会在公开页面上展示。
为需要使用其工具的对话启用该服务。

Web executable，通过 Streamable HTTP。远程服务在工作区中配置后即可从网页运行时运行。

交给智能体安装

把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体，或 SourceWeft 对话中。智能体会读取该服务器的安装指南，先向你展示发布者、端点和登录方式，经你同意后再把它添加到你的客户端。密钥不会写进任何命令。

阅读 https://sourceweft.com/mcp/io.github.ArceeDev%2Fdataclean-mcp/install.md，并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前，先告诉我它的发布者、端点和登录方式，等我确认。不要把 API 密钥写进命令或我会提交的文件；问我密钥应从哪里获取。

查看智能体所依据的安装指南

其他 MCP 客户端

把它添加到你客户端的 mcpServers 配置中。客户端会在首次连接时完成 OAuth 登录。

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

README

dataclean-mcp

An MCP server that cleans tables deterministically before an AI agent reasons over them. LLMs misread 1.250,50 €, swap day and month in 03/04/2026, choke on NUL bytes and mojibake (CafÃ©), and silently drop leading zeros. DataClean fixes these with rules, and it never guesses: an ambiguous value is kept as it was and flagged, and it is converted only when the rest of its column (or a parameter you pass) settles its meaning.

Tool	Credits	What it does
`profile_table`	1	Encoding, delimiter, header row, and for each column: real type (integer, decimal, date, datetime, boolean, email, url, phone, iban, text), number locale, date order, currency, nulls, distinct values, min/max, examples and problems. Also reports duplicate rows and a suggested schema.
`clean_table`	1	Returns a clean, typed copy as CSV, TSV, JSON, JSONL or typed .xlsx: text trimmed and repaired, numbers as plain decimals, dates in ISO 8601, phones in E.164, IBANs compacted, rows deduplicated, headers made unique or snake_case. Every value left unconverted is listed with its source row.
`validate_schema`	1	Checks every row against a schema (type, required, unique, min/max, min_length/max_length, enum, pattern) and returns errors with their row numbers.
`normalize_values`	1	Normalizes a list of up to 10,000 values (amounts, dates, phones, emails…) taken from a document or another tool.
`pricing`, `credits_balance`	0	Free helpers.

Charging works like this:

Unreadable input or invalid parameters are refused before any credits are charged.
A failure after charging is refunded.

What it fixes

Numbers: 1.250,50 €, $1,250.50, 1 234,5, 1'234.50, (45.30), SAP-style 1.250,50-, 12,5 %, EUR 12. The column decides whether a value like 1,250 uses a thousands or a decimal separator. If nothing in the column decides it, number_locale does, and without either the value is flagged ambiguous_number.
Dates: ISO, 13/04/2026 (day-first), 04/13/2026 (month-first), 5 de marzo de 2026, March 5, 2026, 5-Mar-26, 3. März 2026, and times with am/pm. 03/04/2026 is converted only when another value in the column, or date_order, settles the order. Dates in the minority order are flagged date_order_conflict.
Text: removes NUL, control and zero-width characters, turns NBSP into a normal space, repairs mojibake, applies Unicode NFC, and collapses and trims spaces. Null markers (NULL, N/A, #N/A, -, nan…) become empty.
IDs: digit strings with leading zeros or more than 15 digits (zip codes, card numbers, references) stay text and are never turned into numbers.
Files: CSV in UTF-8, UTF-16 or Windows-1252, delimiter detected automatically (, ; tab |), title rows above the header skipped, ragged rows padded, duplicate or empty headers renamed. Also reads .xlsx (via base64) and JSON/JSONL.
Safety: in CSV output, text cells starting with = + - @ get a ' prefix so spreadsheets do not run them as formulas. In .xlsx output they are stored as strings. Schema regexes with nested quantifiers are refused (ReDoS).

Install

Buy credits at https://mcp.keyflint.dev to get a license (LIC-...).
Add the server to your client:

json

{  "mcpServers": {    "dataclean": {      "command": "uvx",      "args": ["dataclean-mcp"],      "env": { "KEYFLINT_LICENSE": "LIC-..." }    }  }}

{  "mcpServers": {    "dataclean": {      "command": "uvx",      "args": ["dataclean-mcp"],      "env": { "KEYFLINT_LICENSE": "LIC-..." }    }  }}

Claude Desktop also installs the .mcpb bundle attached to each GitHub release. Hosted mode runs dataclean-mcp --http (or uses the Dockerfile) and reads the license from each request's Authorization: Bearer LIC-... header.

Limits (set by environment variables): DATACLEAN_MAX_BYTES (20 MB), DATACLEAN_MAX_ROWS (200,000), DATACLEAN_MAX_OUTPUT (15 MB). Credit prices can be overridden with DATACLEAN_PRICES=clean_table=2,....

Visual cards (MCP Apps)

In Claude, ChatGPT, VS Code and Goose every paid tool and credits_balance renders as an interactive card in the chat: credit balance with a refill bar and a buy button, or a result summary (key figures, issues, table preview and credits charged). It is the ui://dataclean/card.html resource, self-contained with no network access. Other clients keep getting the same JSON as before.