TOOL · 91 · Convert

JSON to SQL

Turn a JSON array into CREATE TABLE + INSERT statements — types are auto-inferred per column.

In short
JSON to SQL turns a JSON array (or a single object) into CREATE TABLE plus INSERT INTO statements. Column types are auto-inferred (INTEGER, REAL, BOOLEAN, DATE, TEXT) from the actual values.

Processed 100% in your browser — your files never leave your device.

Table name

JSON inSQL out

CREATE TABLE my_table (
  id INTEGER,
  name TEXT,
  email TEXT,
  active BOOLEAN,
  score REAL
);

INSERT INTO my_table (id, name, email, active, score) VALUES (1, 'Ada Lovelace', 'ada@example.com', TRUE, 98.5);
INSERT INTO my_table (id, name, email, active, score) VALUES (2, 'Alan Turing', 'alan@example.com', TRUE, 99.9);
INSERT INTO my_table (id, name, email, active, score) VALUES (3, 'Grace Hopper', 'grace@example.com', FALSE, 97.1);

How it works

Step · 01
Paste a JSON array (or single object) on the left. Types are auto-detected per column.
Step · 02
Set the target table name — the tool emits CREATE TABLE + INSERT statements.
Step · 03
Copy or download the .sql file — SQLite / MySQL / Postgres-friendly.

Related tools

Frequently asked questions

Which SQL dialect does it output?: Standard SQL that runs unchanged on SQLite, PostgreSQL and MySQL for typical types. Adjust BOOLEAN or DATE to your dialect if strict compatibility is needed.
How are nested objects handled?: Nested objects and arrays are inserted as their JSON string form. Flatten your data beforehand if you want proper columns.
Are my files uploaded to a server?: No. Files are processed directly in your browser using JavaScript and WebAssembly. Nothing is uploaded to our servers, so your documents never leave your device.
Does it work on mobile?: Yes. The tools run in any modern browser on desktop, tablet, or mobile (Chrome, Edge, Safari, Firefox). Very large files may be slower on low-end phones.

International

This tool is also indexed for French, German and Arabic keywords.

Français

Convertir JSON en SQL — CREATE TABLE + INSERT

Convertir JSON en SQL gratuit : produit des instructions CREATE TABLE et INSERT INTO depuis un tableau JSON avec inférence de types automatique.

Deutsch

JSON in SQL umwandeln — CREATE TABLE + INSERT

JSON in SQL umwandeln kostenlos: Erzeugt CREATE TABLE und INSERT INTO Anweisungen aus einem JSON-Array mit automatischer Typerkennung.

العربية

تحويل JSON إلى SQL — CREATE TABLE و INSERT

تحويل JSON إلى SQL مجاناً: يُنتج عبارات CREATE TABLE و INSERT INTO من مصفوفة JSON مع اكتشاف الأنواع تلقائياً.