MCP Radar
Servidor MCP

netcafe-tables

com.ainetcafe/netcafe-tables
Datos y analítica Finanzas e inversión Público y accesible MCP 2026-07-28

Qué hace este MCP

Cleans, converts, merges, compares, reconciles, and validates CSV, JSON, Excel, chart, and accounting bank-feed data.

Capacidades

Herramientas

15 herramientas
clean_table
Messy CSV → tidy CSV, with a report of every change
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 the cleaned CSV plus exactly what changed: rows in, rows out, duplicates removed, cells trimmed per column. It can also transpose rows/columns and unpivot a wide table into a long one. The row arithmetic is verified in code — if in − removed ≠ out, the response says so instead of handing back a table nobody can check. Use when a CSV came out of Excel or an export and needs cleaning before analysis.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'properties': {'ops': {'type': 'string', 'description': 'Comma-separated, default "dedupe,trim,drop_empty,unify_blank". Also available: split_column, transpose (swap rows/columns), wide_to_long (unpivot a wide table into the long format analysis tools expect).'}, 'url': {'type': 'string', 'description': 'Link to the CSV. Provide this or text.'}, 'keep': {'type': 'string', 'description': 'For wide_to_long: comma-separated id columns to keep as-is. Defaults to the first column.'}, 'text': {'type': 'string', 'description': 'The CSV content itself. Provide this or url.'}, 'split_by': {'type': 'string', 'description': 'Separator to split on, default a single space.'}, 'split_column': {'type': 'string', 'description': 'Column name to split (requires ops to include split_column).'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
csv_to_chart
csv to chart
CSV (first column = labels, second = values) → chart PNG in one call.
Esquema de entrada 
{'type': 'object', 'properties': {'csv': {}, 'url': {}, 'type': {}}, 'additionalProperties': True}
csv_to_json
csv to json
CSV (text or URL) → JSON array of objects (first row = keys). Returns a .json file.
Esquema de entrada 
{'type': 'object', 'properties': {'csv': {}, 'url': {}}, 'additionalProperties': True}
csv_to_md_table
csv to md table
CSV (text or URL) → GitHub-flavoured Markdown table.
Esquema de entrada 
{'type': 'object', 'properties': {'csv': {}, 'url': {}}, 'additionalProperties': True}
csv_to_qbo
Transaction CSV → QuickBooks .qbo bank feed file
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.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'required': [], 'properties': {'csv': {'type': 'string', 'description': 'CSV content with a header row.'}, 'url': {'type': 'string', 'description': 'Or a link to the CSV.'}, 'bank_id': {'type': 'string', 'description': 'Routing / bank identifier, if your import asks for one.'}, 'currency': {'type': 'string', 'description': 'Three-letter currency code, default USD.'}, 'account_id': {'type': 'string', 'description': 'Your account number as the accounting software expects it.'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
dedupe_entities
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 merges anything: it returns candidate groups with the evidence for each link, pairs that need human review, and — just as
Esquema de entrada 
{'type': 'object', 'properties': {'url': {}, 'bank': {}, 'name': {}, 'text': {}, 'phone': {}, 'sheet': {}, 'domain': {}, 'tax_id': {}, 'address': {}, 'name_threshold': {}}, 'additionalProperties': True}
diff_tables
Two tables → what differs (the VLOOKUP job, no amounts needed)
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, inventory counts, permission tables, and any "these two exports should match" check.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'required': ['key'], 'properties': {'key': {'type': 'string', 'description': 'Column that identifies a row, e.g. id.'}, 'url_a': {'type': 'string', 'description': 'Link to the first CSV.'}, 'url_b': {'type': 'string', 'description': 'Link to the second CSV.'}, 'text_a': {'type': 'string', 'description': 'Or the first CSV content directly.'}, 'text_b': {'type': 'string', 'description': 'Or the second CSV content directly.'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
fix_csv_encoding
Fix a CSV that opens garbled in Excel
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.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'required': [], 'properties': {'url': {'type': 'string', 'description': 'Public URL of the CSV.'}, 'text': {'type': 'string', 'description': 'Or paste the CSV content directly.'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
json_to_csv
json to csv
JSON array of objects → CSV file. Flattens keys, quotes fields containing commas.
Esquema de entrada 
{'type': 'object', 'properties': {'json': {}}, 'additionalProperties': True}
match_transactions
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) and combined payments (one transfer covering several invoices, N:1). Its rule is: never guess — a pair is only auto-match
Esquema de entrada 
{'type': 'object', 'properties': {'url_a': {}, 'url_b': {}, 'text_a': {}, 'text_b': {}, 'sheet_a': {}, 'sheet_b': {}, 'fee_tolerance': {}, 'max_group_size': {}, 'date_window_days': {}}, 'additionalProperties': True}
merge_tables
Several CSVs → one, columns unioned, row counts proven
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 count and checks in code that they sum to the merged total. Use for monthly exports, per-store sheets, or any set of files with the same subject but drifting headers.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'properties': {'urls': {'type': 'string', 'description': 'Comma-separated CSV links, at least two.'}, 'texts': {'type': 'array', 'items': {'type': 'string'}, 'description': 'Or pass the CSV contents directly as an array.'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
read_xlsx
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, which sheets are hidden, and where merged cells left blanks, instead of guessing for you.
Esquema de entrada 
{'type': 'object', 'properties': {'url': {}, 'sheet': {}, 'inline': {}, 'max_rows': {}, 'preview_rows': {'type': 'number'}, 'keep_formulas': {}}, 'additionalProperties': True}
reconcile_ledger
Two tables → what does not match (the VLOOKUP job), with the arithmetic proof
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 + 0.2 never invents a phantom difference for someone to chase. The response also proves the result: the listed differences are re-added and must equal the gap between the two totals, checked in code. Use for month-end close, platform payouts vs orders, or any "these two numbers should agree and do not" problem. This is the job people do by hand with VLOOKUP or a groupby and then cannot prove they got right.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'required': ['key', 'amount'], 'properties': {'key': {'type': 'string', 'description': 'Column name to match rows on, e.g. order_id.'}, 'url_a': {'type': 'string', 'description': 'Link to side A (e.g. your books).'}, 'url_b': {'type': 'string', 'description': 'Link to side B (e.g. the statement).'}, 'amount': {'type': 'string', 'description': 'Numeric column to compare, e.g. amount.'}, 'text_a': {'type': 'string', 'description': 'Or the CSV content of side A directly.'}, 'text_b': {'type': 'string', 'description': 'Or the CSV content of side B directly.'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
what_can_you_do
Find the right tool for a task
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 ledger, a bank statement reconciled, a messy CSV turned into a deliverable). Deterministic and free: it calls no model, costs nothing, and never runs out of quota. Call this FIRST when you are not sure what this server offers.
Solo lectura Idempotente
Esquema de entrada 
{'type': 'object', 'required': ['task'], 'properties': {'task': {'type': 'string', 'description': 'What you are trying to do, e.g. "reconcile a bank statement against my books" or "把一堆发票整理成能入账的表格"'}}}
Esquema de salida 
{'type': 'object', 'additionalProperties': True}
write_xlsx
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.
Esquema de entrada 
{'type': 'object', 'properties': {'url': {}, 'text': {}, 'sheets': {}, 'sheet_name': {}}, 'additionalProperties': True}
Historial

Cambios recientes en herramientas

Añadido
json_to_csv
17 de September de 2026 a las 12:33
Añadido
csv_to_json
17 de September de 2026 a las 12:33
Añadido
csv_to_chart
17 de September de 2026 a las 12:33
Añadido
csv_to_md_table
17 de September de 2026 a las 12:33
Añadido
dedupe_entities
17 de September de 2026 a las 12:33
Añadido
match_transactions
17 de September de 2026 a las 12:33
Añadido
write_xlsx
17 de September de 2026 a las 12:33
Añadido
read_xlsx
17 de September de 2026 a las 12:33
Añadido
fix_csv_encoding
17 de September de 2026 a las 12:33
Añadido
reconcile_ledger
17 de September de 2026 a las 12:33
Añadido
merge_tables
17 de September de 2026 a las 12:33
Añadido
clean_table
17 de September de 2026 a las 12:33
Añadido
diff_tables
17 de September de 2026 a las 12:33
Añadido
csv_to_qbo
17 de September de 2026 a las 12:33
Añadido
what_can_you_do
17 de September de 2026 a las 12:33
Descubrir

Servidores MCP similares

AlpineDataWorks Intelligence Server

com.alpinedataworks/adw-intelligence-server

Provides economic, market, supply-chain, real-estate, energy, consumer, labor, and other scored intelligence indices with histori…

Stratalize Finance

com.stratalize/finance

Provides financial, macroeconomic, banking, credit, commodities, M&A, ESG, labor, and regulatory benchmarks for analysis and plan…

Valuein — SEC EDGAR Fundamentals & Smart-Money Data

io.github.valuein/mcp-sec-edgar

Provides point-in-time SEC EDGAR fundamentals, filings, ownership signals, financial analysis, valuation models, research reports…

equibles

io.github.daniel3303/equibles

Provides equity and market research tools covering SEC filings, company financials, portfolios, prices, options, macroeconomic da…

DFX Real Estate Intelligence

io.github.Capital-W-Holdings/us-property-parcel-real-estate-debt

Provides US commercial real estate, parcel, debt maturity, bank CRE exposure, private capital, investor, ownership, occupancy, an…

simplefunctions

io.github.spfunctions/simplefunctions

Provides prediction-market data, thesis analysis, market signals, portfolio tracking, and automated intent-based trading workflow…

EventTrader MCP

com.cymetica/event-trader-mcp

Provides prediction-market research and trading capabilities, including real-time event-market data, CLOB execution paths, fund i…

Signal8

ai.signal8/mcp

Provides SEC filings, dilution data, insider and institutional ownership, and political-trade data.