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.