SQL Insert Generator
Turn JSON or CSV rows into SQL INSERT statements for MySQL, PostgreSQL, SQLite or SQL Server.
SQL Insert Generator
Output
Learn
History for this tool
The most recent data you entered in this tool, stored only in this browser.
Save what you type here, in this browser? Your work would go into this browser's local storage, so a refresh or a trip to another tool does not wipe it. You also get a short list of previous entries under the form, each one restorable with a click. Nothing is ever uploaded, and there is no account.
Being straight about the trade-off: anything kept there can be read by anyone who can use this browser profile, and by any script that later runs on this site. A tool page can hold a private key, a password or a signed token. Saving is convenient; it is not private.
Saved on this device
Your inputs and history are stored locally.
Not saved
This page forgets your work when you leave it.
About this tool
Paste a JSON array of objects or simple CSV and get SQL INSERT statements. Column names are collected from the rows, values are quoted per dialect, and you can emit one statement per row or a single multi-row INSERT.Questions
- How are objects and arrays stored?
- They are serialized to JSON text and enclosed in an SQL string literal. Check your target database’s escaping and column types before executing; this tool does not make application input safe to concatenate into SQL. Use parameterized queries for that.