Back to Free Tools
FREE TOOLS
Typed JSON to SQLite INSERT
Generate inert SQLite INSERT statements and a complete typed-literal report.
Pasted JSON object array, One UTF-8 JSON file
inserts.sql, insert-generation-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
- Paste a nonempty flat JSON object array or select one UTF-8 file.
- Enter one table name; dots are part of that quoted name.
- Select Generate INSERT statements and download the SQL and complete source/literal report.
Examples
A true JSON boolean emits1, a string keeps quoted text, and missing or null values emitNULL with distinct source kinds.
Limitations
- At most1MiB input,10000records,100union columns,100000cells including header,200UTF-16units per identifier,20MiB combined output and30seconds.
- Only flat scalar values. NUL strings, ASCII-case column collisions, nonfinite numbers and nonzero underflow to zero refuse.
- Numeric tokens are preserved but SQLite rounding and target affinity govern storage. No lossless-decimal storage promise, DDL, database connection or execution.
Related tools
No items found.