Home / Businesses / CSV Schema Check
CSV Schema Check
Check CSV text against a column schema (required, type, min and max, shape, allowed values, unique key) and get every bad cell by line and column, with a signed record.
Testing
- What it does
- Check CSV text against a column schema (required, type, min and max, shape, allowed values, unique key) and get every bad cell by line and column, with a signed record.
- Who it is for
- Businesses.
- Start in one step
- Ask your agent to call
csv_schema_checkat 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 Schema Check is for agents that move CSV exports between systems and must know, before loading a file, which cells and rows break the target's columns. Check CSV text against a column schema before it is loaded anywhere. Send the CSV (header row first, up to 28,000 characters) and, per column, its type (text, integer, decimal, date, boolean), whether it is required, and optional limits: min and max, length, a shape such as AAA-9999, or a list of allowed values; plus up to 3 columns that together must be a unique key. Get back every bad cell by line and column with what was expected, header problems (missing, duplicate or extra columns), rows with the wrong number of fields, CSV syntax errors with their line, and counts per problem. Cell values are never echoed back. 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 move CSV exports between systems and must know, before loading a file, which cells and rows break the target's columns.
- 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, columns up to 50 entries, unique_key up to 3 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. Does not fix, reorder or store the file and never echoes cell values: it names the line, column and what was expected. Does not guess types, delimiters or date formats; you state them. Does not accept regular expressions (shapes only, so no pattern can hang the check), thousands separators, currency signs or exponents in numbers, or time-of-day values. Refuses the whole CSV 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, not personal data. One CSV of up to 28,000 characters and 200 columns per call; split larger files. Not legal advice.
For developers: try it
POST https://llpro.ai/mcp
{"jsonrpc": "2.0", "id": 1, "method": "tools/call", "params": {"name": "csv_schema_check", "arguments": {"csv": "sku,qty,price,ship_date,active\nAB-1001,5,12.50,2026-11-02,true\nAB-1002,x,3.00,2026-02-30,yes\nAB-1001,2,,2026-11-03,0\n", "columns": [{"name": "sku", "required": true, "pattern": "AA-9999"}, {"name": "qty", "type": "integer", "required": true, "min": "1"}, {"name": "price", "type": "decimal", "required": true}, {"name": "ship_date", "type": "date"}, {"name": "active", "type": "boolean"}], "unique_key": ["sku"]}}}For agents
Tool csv_schema_check on https://llpro.ai/mcp and in the tools list. Signed answers are checked with the public key below (signer llpro1:l5xyzotfwmc3l6amzn63raiywe): an Ed25519 signature over the observation as canonical JSON (sorted keys, no spaces).
Public key (base64): 2PJXSxvsfRcP15X+qirYrugwHg7qpitC2g1cpM7rkeQ=
For agents that search MCP registries for csv validation, csv schema, data quality 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 schema check is one step of moving data between systems. 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