Processed locally — your file never leaves your device
JSON to SQL INSERT
Turn a JSON array of objects into INSERT statements for MySQL, PostgreSQL, SQLite or standard SQL, entirely in your browser.
Drop a .json file hereor click to choose a file from your deviceNothing is uploaded — conversion happens entirely on your device.
How it works
- Select or drop a .json file containing an array of objects.
- Choose a table name and your SQL dialect.
- Copy or download the generated INSERT statements.
Frequently asked questions
- Is my JSON uploaded anywhere?
- No. The statements are built in your browser. That matters here because the JSON being loaded into a database is usually real data — an export, a seed file, a migration payload.
- What JSON shape does it expect?
- An array of objects, where each object is a row. The union of the object keys becomes the column list, and a key missing from a given object becomes NULL for that row.
- Is the output safe from SQL injection?
- Values and identifiers are escaped by doubling the delimiter, which is the standard SQL escape, so a string containing a quote can't terminate its literal and inject a statement. MySQL's backslash escaping is applied too when that dialect is selected.
- Does it connect to my database?
- No, and it never will. This tool only produces text — it has no database connection, no credentials and no way to execute anything. You review the statements and run them yourself.
- What happens to nested objects and arrays?
- A column holds one value, so nested structures are flattened into their text form rather than being expanded into extra columns. For deeply nested data, converting to CSV first and reviewing the columns usually gives a better result.