JSON → SQL

Generate SQL CREATE TABLE from JSON

JSON input

SQL CREATE TABLE output

CREATE TABLE IF NOT EXISTS addresss (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  street TEXT,
  city TEXT
);

CREATE TABLE IF NOT EXISTS orders (
  id INTEGER PRIMARY KEY,
  total REAL,
  shipped BOOLEAN
);

CREATE TABLE IF NOT EXISTS roots (
  id INTEGER PRIMARY KEY,
  name TEXT,
  email TEXT,
  isActive BOOLEAN,
  score REAL
);

Loading tool…