JSON to SQL Converter

Paste a JSON object or array of objects and get CREATE TABLE + INSERT statements — runs entirely in your browser, nothing is uploaded.

Table nameDialect

JSON input

2 row(s) · 4 column(s) detected

CREATE TABLE

CREATE TABLE "my_table" (
  "id" BIGINT NOT NULL,
  "name" TEXT NOT NULL,
  "active" BOOLEAN NOT NULL,
  "score" DOUBLE PRECISION NOT NULL
);

INSERT

INSERT INTO "my_table" ("id", "name", "active", "score") VALUES
  (1, 'Ada Lovelace', TRUE, 98.5),
  (2, 'Alan Turing', FALSE, 91);