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.

← Back to all tools

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 مع اكتشاف الأنواع تلقائياً.