JSON to SQL INSERT Generator

Paste a JSON array of flat objects and get ready-to-run INSERT statements for Postgres, MySQL, SQLite, or MSSQL. Nested values are serialised to JSON strings automatically. All processing happens in your browser.

Input JSON (array of objects)

Table name Dialect Batch size (0 = one per row) Indent

Quote identifiers UPPERCASE keywords ON CONFLICT / IGNORE Include CREATE TABLE

JSON to SQL INSERT Generator

Input JSON (array of objects)

Output SQL