Home / Businesses / CSV Diff by Key
CSV Diff by Key
Compare two CSV extracts by a key column: rows added, removed and changed with the changed columns named, columns added or removed, and a signed record.
Testing
- What it does
- Compare two CSV extracts by a key column: rows added, removed and changed with the changed columns named, columns added or removed, and a signed record.
- Who it is for
- Businesses.
- Start in one step
- Ask your agent to call
csv_diffat llpro.ai/mcp (free, no sign-up). This page explains the tool; it has no form to run it. - What to expect
- Testing: open to try. Free
New to this? Start here.
What it does
CSV Diff by Key is for agents that sync or audit exports between systems and need to know exactly which records changed between two pulls of the same file. Compare two CSV extracts of the same records (before and after, up to 14,000 characters each, header row first) by a key column, or up to 3 key columns together. Get back the rows added, removed and changed (with the key, the line in each file and the names of the columns whose values changed), the count of unchanged rows, and the columns added or removed. Options: columns to ignore (e.g. an updated_at stamp), trim spaces, and compare numbers by value (1.50 = 1.5). Cell values are never echoed back; only key values and column names are. It is one of the Files and records department tools LLPRO builds for the work agents do across business software (Google Drive, Dropbox, OneDrive, Box). Every answer carries the written rule it used, what it does not do, its sources with dates, and an Ed25519 signature you can check against the key below.
- Who it is for
- Agents that sync or audit exports between systems and need to know exactly which records changed between two pulls of the same file.
- Price
- Free, no sign-up: 120 calls an hour per address and 3,000 an hour across all callers. Paid calls are planned and not charging.
- Limits
- Up to 30,000 bytes per call, key up to 3 entries, ignore_columns up to 50 entries; larger requests are refused, never cut. Unknown fields are refused with the list of accepted ones. Money takes up to 2 decimals unless a field says more, and every sum is exact (send amounts as numbers or strings; commas only as thousands separators, 1,234.56). Nothing you send is stored by the tool; no model and no network are used. Never echoes cell values: it names the key, the line in each file and the changed columns, so you read the values from your own files. Does not match rows without a key (by position or by similarity), detect renamed columns, reorder or merge files, or store anything. Does not treat 1,000 and 1000 or different date forms as equal (only plain decimals, with numbers_by_value). Refuses a file when a column is named for personal data or a cell looks like an email, a phone or Social Security number written with separators (512-555-0142, +44 20 7946 0958), or a run of more than 12 digits; it cannot tell a person's name, a bare 10-digit phone or a short account number from other data, so send record codes and key on them. Key values must be at most 40 characters. Up to 14,000 characters per file and 200 columns; split larger extracts by key range.
For developers: try it
POST https://llpro.ai/mcp
{"jsonrpc": "2.0", "id": 1, "method": "tools/call", "params": {"name": "csv_diff", "arguments": {"before": "sku,qty,price\nA1,5,2.00\nA2,1,9.99\nA3,7,1.50\n", "after": "sku,qty,price,note\nA1,6,2.00,x\nA3,7,1.50,\nA4,2,4.00,new\n", "key": ["sku"]}}}For agents
Tool csv_diff on https://llpro.ai/mcp and in the tools list. Signed answers are checked with the public key below (signer llpro1:ouwdx4oz5znhwa4vjc6ymzzavq): an Ed25519 signature over the observation as canonical JSON (sorted keys, no spaces).
Public key (base64): syJzu9uaQYdeIso2xH18kPXF4ONKAHCy0RIS+DMI2F0=
For agents that search MCP registries for csv diff, compare csv, data sync tools (listed in MCP registries, served by the Campus gateway: MCP, agent-to-agent and REST). One fixed, written rule per call, a signed record, no account needed.
Next
- Connect your agent: Use this and the other LLPRO tools from your own agent.
- Get your agent: No agent yet? Get one that asks first.
- Hand the whole job to the Hub: A diff is one step of syncing or auditing data. Tell the Hub the whole job; it routes you to the right signed tools.
For agents: this page as Markdown · JSON · llms.txt · MCP endpoint llpro.ai/mcp · agent card