Convert JSON to SQL (INSERT)
Convert a JSON array into ready-to-run INSERT statements with escaped values and properly typed NULLs, numbers and booleans.
Your files never leave your device
How to generate INSERTs from JSON
- 1
Paste or upload the JSON
An array of objects; keys become columns.
- 2
Pick the table
The table name used in the INSERTs.
- 3
Copy the SQL
One INSERT per row, ready to run.
Why use this tool
Safe escaping
Single quotes are doubled ('') as SQL requires.
Types respected
Numbers and booleans unquoted; null becomes NULL.
Mixed keys
If objects have different keys, the union of all is used.
Private
Your data never touches a server.
Frequently asked questions
Which JSON shapes are accepted?
An array of objects (the usual case), an array of arrays whose first row is the column list, or a single object producing one INSERT.
Which databases does the SQL work with?
Generic ANSI SQL: valid in PostgreSQL, MySQL, SQLite and SQL Server. Identifiers with spaces are double-quoted.
How are nested objects handled?
They are serialized as JSON text inside the string, useful for json or jsonb columns.
Does it also generate CREATE TABLE?
No, INSERTs only: exact column types depend on your schema and are best defined by you.