Query CSV with SQL and Generate TypeScript
Import CSV as JSON, query it with SQLite in your browser, and generate TypeScript types from the result. Save the workflow and rerun it on new data.
Saving keeps input, steps and results in this browser. Automatic workflow history is off unless you enable it in Saved tasks. Share links and exported files contain input; give them only to people who may read it.
A fresh local table is created for this step. The final SELECT becomes JSON for the next step. Results over 5,000 rows stop the workflow.
When to use this workflow
Use SQL to filter and aggregate an export before generating application types. CSV becomes JSON, SQLite loads it into the records table, and the final SELECT supplies the data for TypeScript generation. Edit the query or switch the final step to CSV or Zod. SQLite uses signed 64-bit integers and floating-point arithmetic; SQL calculations follow SQLite semantics. Large numbers preserved as strings by CSV conversion remain text in the query table.
Inspect, adjust and repeat
Start with the working example or paste your own input. Run the steps, select any result to inspect it, and download intermediate files. Change a step’s settings to clear old results before running again. Save the task locally to keep its input and results, or export the workflow to move its input and recipe to another browser.
Limits and privacy
Processing stays in your browser, with no database connection or server conversion. Workflows accept up to 1 million input characters and 10 connected steps; each step has a 15-second time limit and 2 million output characters. Saving is explicit. Anyone receiving a workflow file or share link can read its input.
View local saved tasks · Set up offline tools · Read the privacy policy
2 steps · Local processing
CSV to JSON to TypeScript Workflow
Convert CSV into JSON and generate TypeScript types in one local workflow. Inspect every result, switch to Zod, and save the steps for reuse.
CSV to JSON → Generate TypeScript
2 steps · Local processing
Filter JSON with jq and Export CSV
Filter a JSON array with jq and export the result as CSV in your browser. Review intermediate data and save the workflow to run on the next export.
Filter with jq → JSON to CSV
2 steps · Local processing
JSON to SQL and Formatting Workflow
Generate SQL CREATE TABLE and INSERT statements from JSON, then format the SQL. Choose a database dialect and inspect or download each local step.
JSON to SQL → Format SQL
3 steps · Local processing
Query CSV with SQL and Generate TypeScript
Import CSV as JSON, query it with SQLite in your browser, and generate TypeScript types from the result. Save the workflow and rerun it on new data.
CSV to JSON → Query JSON with SQLite → Generate TypeScript
4 steps · Local processing
CSV to TypeScript, Zod and JSON Schema Workflow
Convert CSV once, then branch its JSON into TypeScript types, Zod validators and JSON Schema. Inspect every output and reuse the local canvas workflow.
CSV → JSON → TypeScript + Zod + JSON Schema