JSON to SQL INSERT Converter

JSON textTable name

Output modeOne multi-row INSERTOne INSERT per row

INSERT INTO my_table (id, name, email, active) VALUES
  (1, 'Ada', 'ada@example.com', TRUE),
  (2, 'Grace', 'grace@example.com', FALSE);

Converted locally in your browser. Your JSON stays only on this page.

Turn JSON into SQL INSERT statements

Paste an API response, seed file, or fixture array and get INSERT statements ready to seed a local or test database. An array of objects becomes one row each, and a single object is treated as a one-row array. Columns are the union of keys across every row in first-seen order, and a row missing a key emits NULL. Strings are single-quoted with embedded quotes doubled (O'Brien becomes O''Brien), numbers are emitted as-is, booleans become TRUE/FALSE, null and missing keys become NULL, and nested objects or arrays are JSON-stringified and quoted. Choose one multi-row INSERT ... VALUES (...),(...); or one statement per row. The table name is used verbatim — dialect-specific identifier quoting is out of scope, so emit standard SQL and quote identifiers yourself if your database needs it.