JSON to SQL

Turn a JSON array of objects into INSERT statements for SQLite, PostgreSQL, MySQL, or SQL Server.

JSON stays in this browser.

Flat objects only — nested values are rejected. Strings are single-quoted and doubled for escaping; numbers, booleans, and null are emitted unquoted. Missing keys become NULL.

How to use

  1. Paste a JSON array of objects.
  2. Set the table name and dialect.
  3. Generate and copy the INSERT statements.

What it supports

Flat objects only — nested values become JSON text. NULLs, numbers, booleans, and strings are typed per dialect; strings are single-quote escaped. Not a schema generator.

Related tools

Related guides