Live page: https://aamirtechs.github.io/sql-insert-forge/
Convert a CSV or JSON file into dialect-correct CREATE TABLE and batched INSERT statements. It runs entirely in the browser so catalogues, files and text you paste stay on your device. Built for busy operators who need a correct answer and a downloadable file, not another account.
- CSV, TSV and JSON array input with header detection
- Type inference for int, decimal, boolean, date and text with override support
- Dialects: Postgres, MySQL, SQLite and SQL Server with correct quoting
- Batch size control, CREATE and DROP toggles, and upsert mode
- Download .sql plus a warnings list for mixed-type columns
Paste or upload your input, choose the options, and run the tool. Processing happens locally in src/logic.js and the page wiring. You can review the results on screen and download the output file.
Runs 100% in your browser. Your files never leave this device, nothing is uploaded, and there is no tracking.
Core logic lives in src/logic.js and is shared by the page and the tests.
Run the tests with npm test.
MIT, Copyright 2026 Amir Hussain.