Schema checks
Define the input and output contracts. Catch mismatches before they become surprises.
TECHNICAL APIs FOR BUILDERS
Practical APIs for the work between systems. Start with schema-driven JSON transformations, powered by SQL.
JSON in. Useful data out.
LESS GLUE CODE
Move from the data you have to the data your next system expects.
Define the input and output contracts. Catch mismatches before they become surprises.
Use familiar queries to filter, reshape, and aggregate. Each step reads the previous result.
Return a complete, validated response. Keep partial transformations out of the workflow.
THE ENDPOINT COLLECTION
Schema-driven JSON transformations, powered by SQL. One useful endpoint for the shape-shifting work.
A proposed endpoint for checking payloads against a clear contract before they enter your workflow.
A proposed endpoint for converting between useful data formats without another custom adapter.
FOUR STEPS. ONE REQUEST.
Start with the payload your system already has.
Set the input and output schemas for the request.
Build a sequence of queries that does the useful work.
Get the final, validated JSON ready for the next system.
MADE FOR DEVELOPERS
A straightforward HTTP request. Familiar SQL. Explicit schemas. A result you can build on.
View the request contract ↗{
"data": [
{
"price": 12.5,
"quantity": 2
},
{
"price": 5,
"quantity": 3
}
],
"config": {
"input_schema": [
{
"name": "price",
"dtype": {
"type": "Float64"
},
"nullable": false
},
{
"name": "quantity",
"dtype": {
"type": "Int64"
},
"nullable": false
}
],
"instructions": "SELECT price * quantity AS total FROM data; SELECT SUM(total) AS revenue FROM data;",
"output_schema": [
{
"name": "revenue",
"dtype": {
"type": "Float64"
},
"nullable": false
}
]
}
}PURPOSE-BUILT, ENDPOINT BY ENDPOINT
Send data and config to POST /transform. The configuration declares input_schema, SQL instructions, and output_schema.
Invalid input, SQL, or output returns a structured HTTP 422 error with a stage, code, and message. A statement number or field path is included when available. The API returns the final result only after validation.
Default pricing is 0.001 USDC per request, plus 0.0000001 USDC per started KiB of input and 0.0001 USDC per SQL statement. A KiB is 1,024 bytes. The total is rounded up once to the nearest 0.000001 USDC. The API confirms the exact quote before payment.
YOUR DATA, EXPLAINED
Know what leaves your device, why it is processed, and when temporary files are deleted.
CSV preview stays on your device until import. The browser demo processes records locally; API mode sends input and generated SQL to the server.
Unused uploads are normally deleted within 15 minutes. Input files are removed after processing; results are kept briefly for download.
The API sends payment authorizations to the payment provider. Your JSON records are not included in the payment transaction.
GET TO THE USEFUL PART
Make your next transformation a single request.