JSON to SQL

Paste a JSON array of objects and get a ready CREATE TABLE plus INSERT statements for MySQL, PostgreSQL or SQLite. Column types are inferred and string values are escaped. Nothing is uploaded.

Your JSON

Table name

SQL dialect

Options One multi-row INSERT (instead of one per row) Add DROP TABLE IF EXISTS

Generated SQL

Everything runs in your browser. No upload, no sign-up.

How it works

STEP 1

Paste your JSON

Drop in an array of objects — for example an API response or a database export. It is parsed right in your browser; nothing leaves your device.

STEP 2

Name the table and pick a dialect

Choose MySQL, PostgreSQL or SQLite. Column types are inferred from the values and string values are safely escaped.

STEP 3

Copy the SQL

Copy the generated CREATE TABLE and INSERT statements with one click and run them in your database.