Table nameDialect

CREATE TABLE

One INSERT per row

JSON input (object or array of objects)

[
  { "id": 1, "name": "Ada O'Hara", "email": "ada@example.com", "active": true, "score": 9.5, "tags": ["admin", "dev"], "note": null },
  { "id": 2, "name": "Grace Hopper", "email": "grace@example.com", "active": false, "score": 8.0, "tags": [] },
  { "id": 3, "name": "Alan Turing", "email": null, "active": true, "score": 7.25 }
]

SQL output

CREATE TABLE users (
  id INTEGER NOT NULL,
  name TEXT NOT NULL,
  email TEXT,
  active BOOLEAN NOT NULL,
  score DOUBLE PRECISION NOT NULL,
  tags NVARCHAR(MAX),
  note TEXT
);

INSERT INTO users (id, name, email, active, score, tags, note) VALUES
  (1, 'Ada O''Hara', 'ada@example.com', TRUE, 9.5, '["admin","dev"]', NULL),
  (2, 'Grace Hopper', 'grace@example.com', FALSE, 8, '[]', NULL),
  (3, 'Alan Turing', NULL, TRUE, 7.25, NULL, NULL);

About JSON to SQL Converter

Paste a JSON array (or CSV with a header row) and get ready-to-run INSERT INTO statements plus an optional CREATE TABLE with column types inferred from the data — INTEGER, DOUBLE, BOOLEAN, JSON for nested values, NULL handling included. Pick a dialect: Standard SQL, MySQL/MariaDB, PostgreSQL, SQLite, SQL Server or Oracle (INSERT ALL for multi-row loads).

Works in reverse too: paste INSERT statements and get the rows back as JSON — multi-row VALUES, quoted identifiers and escaped strings are all parsed. Everything runs locally in your browser.