{ } How to use

Paste a JSON array of objects.
Set the table name.
Select Process to get one INSERT per row.

{ } How it works

JSON to SQL works on the text you provide. Adjust the options, then select Process ▸ and it runs entirely in your browser — nothing is uploaded to a server — then shows the result in the Output panel.

Inputs

JSON array — paste or type your input in the left panel (use Sample for an example)
Table name — a value (default: "my_table")

Output

SQL text — copy or download it from the Output panel.

{ } Common uses

Seed a database from a saved API response.
Turn a fixture into SQL for a migration or a test setup.
Move a handful of records between systems without an import tool.

{ } Limitations

Column names are the JSON keys written as-is, unquoted. A key with a space, a hyphen or a reserved word produces SQL that will not run — rename it first.
Strings are single-quoted with inner quotes doubled, numbers and booleans are written bare, and null becomes NULL. Nothing else is type-aware: a date stays a quoted string.
The columns are the union of every object’s keys, so a row missing a field gets NULL for it. There is no CREATE TABLE and no batching — one statement per row.

{ } FAQ

Is my data uploaded to a server?

No. Everything runs locally in your browser — your files never leave your device.

Can I process more than one file at once?

This tool works on one input at a time.

Is this tool free?

Yes — it’s completely free and needs no sign-up.

Is the escaping safe against injection?

Single quotes are doubled, which is the correct SQL escape, but this is a code generator and not a parameterised query. Read what it produces before running it, and never feed it untrusted input straight into a database.