Netcafe Tables

Reliability

Latest check failed 23 h ago: initialize returned HTTP 530

Status and outage history · Atom feed · Watch with other listings

How to connect

Add it to any MCP client that supports remote servers.

{
  "mcpServers": {
    "netcafe-tables": {
      "type": "http",
      "url": "https://ainetcafe.com/mcp/table?s=registry"
    }
  }
}

15 tools

• what_can_you_do

  Describe a task in plain language (any language) and get back exactly which tools on this server do it, with ready-to-run example calls — instead of reading the whole catalogue and guessing. Also returns multi-step recipes when a task needs several tools chained (invoices to a…

• csv_to_qbo

  Convert a transaction CSV into a .qbo / OFX bank-feed file that QuickBooks and similar accounting software import directly. Needs date, description and amount columns (or debit + credit). Pairs with extract_statement: statement PDF in, importable bank feed out.

• diff_tables

  Matches rows across two CSVs on a key column and reports three things: keys only in A, keys only in B, and keys in both whose other columns disagree — naming the exact column and both values. Unlike reconcile_ledger this needs no amount column, so it also fits name lists…

• clean_table

  Tidies a spreadsheet export: removes duplicate rows, trims whitespace (half-width and full-width — Chinese exports are full of 　), unifies the half-dozen ways a cell can say "empty" (NA / null / - / 无), drops empty rows and columns, and can split one column into several. Returns…

• merge_tables

  Combines up to 20 CSVs into a single table. Headers do not have to match: columns are unioned and a file missing a column contributes blanks for it, so rows never shift silently — the failure mode that makes hand-merged spreadsheets untrustworthy. Reports each source file row…

• reconcile_ledger

  Reconciles two sets of records — your books against a bank, platform, or supplier statement. Matches rows on a key column, compares an amount column, and returns three lists: only in A, only in B, and same key but different amount. Amounts are compared in integer cents, so 0.1 +…

• fix_csv_encoding

  Detect the real encoding of a CSV (GB18030, Shift-JIS, Windows-1252…), repair mojibake (UTF-8 that was read as Latin-1, e.g. "é"), and re-emit UTF-8 with a BOM so Excel opens it correctly.

• read_xlsx

  Read an Excel .xlsx workbook (by URL) into rows — every sheet, or one you name. Returns cell values (not formula text), dates as YYYY-MM-DD instead of Excel serial numbers, and keeps leading zeros so ID/postcode columns are not silently mangled. Says plainly which sheet it used…

• write_xlsx

  Build an Excel .xlsx file from rows (CSV text or JSON arrays), optionally several sheets at once. Numbers are written as real numbers so they sum in Excel, while values with leading zeros stay text so IDs and postcodes survive the round trip.

• match_transactions

  Match bank statement lines to ledger/invoice entries when there is NO shared key — by amount, date window, reference numbers found inside free-text descriptions, and fuzzy counterparty names ("北京XX科技" vs "XX科技(北京)"). Handles split payments (one invoice paid in instalments, 1:N)…

• dedupe_entities

  Find records in a supplier/customer/store list that are probably the SAME entity under different names — "北京星辰科技有限公司" vs "星辰科技(北京)" — by cross-checking name similarity against hard identifiers: tax ID (统一社会信用代码, checksum-verified), phone, domain, bank account, address. It never…

• csv_to_md_table

  CSV (text or URL) → GitHub-flavoured Markdown table.

• csv_to_chart

  CSV (first column = labels, second = values) → chart PNG in one call.

• csv_to_json

  CSV (text or URL) → JSON array of objects (first row = keys). Returns a .json file.

• json_to_csv

  JSON array of objects → CSV file. Flattens keys, quotes fields containing commas.

Security scan

Recent checks