Back to Free Tools
FREE TOOLS
SQLite CREATE TABLE Generator
Infer a conservative nullable SQLite CREATE TABLE statement from CSV or flat JSON records.
Pasted CSV or flat JSON array, One UTF-8 file
create-table.sql, schema-inference-report.json
Browser only
Runs locally in your browser. Your files, pasted content and generated output are not uploaded. Reset clears this tool’s working data.
This tool needs JavaScript. If it does not load, refresh the page and try again.
How to use this tool
- Enter the input and explicit options shown. A selected UTF-8 file wins its corresponding pasted text.
- Select Generate CREATE TABLE and inspect the complete stated conventions.
- Download create-table.sql, schema-inference-report.json.
Examples
CSV id values1,2 infer INTEGER; JSON string values"1","2" infer TEXT.
Limitations
- At most1 MiB UTF-8,10000 records,100 columns,100000 cells including headers,JSON depth40/200000 values,200 UTF-16 table-name units,20 MiB combined output and30 seconds. CSV needs a data row; JSON needs a nonempty flat-object array and union column.
- CSV signed64 integer tokens infer INTEGER; otherwise strict numeric finite/non-underflowing tokens infer REAL. JSON mathematical integer tokens can infer INTEGER; actual strings/booleans remain TEXT. Null/missing and exact-empty CSV cells do not vote.
- All columns are nullable; no inferred constraints, INSERT or connection. Identifiers reject NUL and ASCII case-fold collisions; later database affinity/constraints apply and REAL does not guarantee source precision.
Related tools
No items found.