JSON to SQL
Paste a JSON array of objects — get a CREATE TABLE with inferred column types, and batched INSERT statements.
CREATE TABLE
CREATE TABLE "users" ( "id" INTEGER, "name" TEXT, "active" BOOLEAN, "score" DOUBLE PRECISION );
INSERT (1 statement)
INSERT INTO "users" ("id", "name", "active", "score") VALUES
(1, 'Ada Lovelace', TRUE, 9.5),
(2, 'Alan Turing', FALSE, 10);Runs in your browser. Nothing you type is sent anywhere.
How this works
- Column types are inferred per field: BOOLEAN, INTEGER, FLOAT or TEXT — a mixed or all-null column falls back to TEXT.
- Column order follows the union of keys across all objects, in the order first seen.
- Identifiers and string values are quoted correctly for the chosen dialect, and INSERTs are split at your batch size.
Do this against your live database in Tablyne.
PostgreSQL GUI →FAQ
What if objects have different keys? +
The table gets every key seen across all objects; a row missing a key gets NULL for that column.
How does type inference handle a column with both numbers and text? +
It falls back to TEXT — the safe choice when values don't agree on a single type.
Why split into multiple INSERT statements? +
Very large arrays produce very large statements; the batch size option keeps each one to a manageable, pasteable size.