LLPROBeta

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_check at 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

For agents: this page as Markdown · JSON · llms.txt · MCP endpoint llpro.ai/mcp · agent card