Skip to content
IEDE Data processing & engineering
Request a quote
Quick tools JSON formatterJSON ↔ CSV converterJSON ↔ YAML converterJSON to SQLJSON to TypeScriptXML formatterData size calculatorBase64 encoder/decoder
IEDE
Get in touch
  1. Home
  2. Tools
  3. JSON to SQL
Runs in your browserData

JSON to SQL converter

Paste a JSON array of objects; the SQL is generated in your browser.

Runs locally — nothing is uploaded
Result
Nothing yet — enter data or press Example.

How to use

  1. 1Paste a JSON array of objects (or an object holding one such array).
  2. 2Set the table name and choose the dialect.
  3. 3Choose how many rows go into each INSERT.
  4. 4Check the inferred types, then copy the SQL.

From all rows: integers → INTEGER or BIGINT, decimals → DOUBLE/REAL (NUMERIC or DECIMAL beyond 15 digits), true/false → BOOLEAN, ISO dates and timestamps → DATE/TIMESTAMP, objects and arrays → JSON, mixed values → text.

A column named id whose values are present and unique in every row.

Single quotes are doubled, and for MySQL backslashes are escaped too. Identifiers that are reserved words or contain special characters are quoted.

No, the SQL is generated in your browser.

Related tools

JSON formatterValidate, pretty-print or minify JSON JSON ↔ CSV converterFlatten JSON to CSV, or turn CSV into JSON JSON ↔ YAML converterConvert configs between JSON and YAML JSON to TypeScriptInfer TypeScript interfaces from JSON XML formatterValidate, indent or minify XML Data size calculatorConvert data sizes and estimate download time

Messy data?

Send a sample — we reply within one business day with an approach and a quote.

Get in touchServices