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

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.