Turn a JSON array into a CREATE TABLE statement and one INSERT per object, for PostgreSQL, MySQL, SQLite or SQL Server. Column types are inferred from your data, strings are escaped, and nothing leaves your browser.
JSON input
[
{ "id": 1, "name": "Alice", "active": true, "score": 98.5 },
{ "id": 2, "name": "O'Brien", "active": false, "score": 71.25 }
]SQL output
CREATE TABLE "users" (
"id" BIGINT,
"name" VARCHAR(255),
"active" BOOLEAN,
"score" DOUBLE PRECISION
);
INSERT INTO "users" ("id", "name", "active", "score") VALUES (1, 'Alice', TRUE, 98.5);
INSERT INTO "users" ("id", "name", "active", "score") VALUES (2, 'O''Brien', FALSE, 71.25);| JSON value | PostgreSQL | MySQL | SQLite | SQL Server |
|---|---|---|---|---|
| whole number | BIGINT | BIGINT | INTEGER | BIGINT |
| decimal number | DOUBLE PRECISION | DOUBLE | REAL | FLOAT |
| boolean | BOOLEAN | TINYINT(1) | INTEGER | BIT |
| short string (up to 255) | VARCHAR(255) | VARCHAR(255) | TEXT | NVARCHAR(255) |
| long string | TEXT | TEXT | TEXT | NVARCHAR(MAX) |
| nested object or array | JSONB | JSON | TEXT | NVARCHAR(MAX) |
N'' prefix. null becomes NULL.NULL.Tidy the output with the SQL formatter, flatten nested JSON first with JSON Flatten, convert to CSV, or generate typed code with JSON to Go and JSON to Java.
Paste a JSON array of objects, choose your database and table name, and copy the output. The tool creates a CREATE TABLE statement with inferred column types, then one INSERT per object.
MySQL, PostgreSQL, SQLite and SQL Server. Identifiers are quoted the right way for each (backticks, double quotes or brackets), and types map accordingly — for example BOOLEAN in PostgreSQL, TINYINT(1) in MySQL and BIT in SQL Server.
Nested values are stored as JSON text in a JSONB/JSON column (or TEXT/NVARCHAR(MAX) where JSON types don't exist). Single quotes in strings are escaped. Everything runs in your browser — your JSON is never uploaded to a server.