Convert to Parquet
convert_to_parquetConvert a messy data file into clean, typed, zstd-compressed Parquet.
Use this first for any CSV/TSV, JSON/NDJSON, Excel, SPSS, Stata or SAS file, or a digital PDF with tables. It detects the format, encoding and delimiter; skips title rows; repairs broken JSON; pulls tables out of PDFs (merging tables that continue across pages); infers int/float/bool/date/timestamp columns (including 1.234,56 and $1,234 formats) while keeping IDs with leading zeros as text; normalizes column names to snake_case; keeps SPSS/Stata/SAS variable and value labels; and can validate against an expected_schema.
Returns an artifact_id (pass it to inspect_parquet / preview_parquet / query_parquet), a download link, and a per-column report: type, null count, values that did not fit the chosen type, and warnings. Price: $0.02 USDC per successful call, paid via x402.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "convert_to_parquet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | Public http(s) URL of the input file. Preferred for anything over ~3 MB. | |
| options | No | ||
| filename | No | Original filename, e.g. 'survey.sav'. The extension helps format detection. | |
| artifact_id | No | artifact_id returned by an earlier convert_to_parquet call: converts that stored Parquet file again, with these options (an expected_schema, say). | |
| content_base64 | No | The file's raw bytes, base64-encoded (standard or URL-safe alphabet, '=' padding optional). Small files only (under ~3 MB). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| hint | No | Pointer to premium features (local mode only). | |
| report | Yes | ||
| artifact | Yes |