JSON to SQL Converter

Load JSON data into a SQL database

When you need test data in a relational database, or you are migrating records exported from an API, writing INSERT statements by hand is tedious. This converter scans every record to work out each column: its type, and whether it can be NULL (a column becomes nullable if any record has null or is missing the key). It then writes a CREATE TABLE statement and one INSERT per record — or a single multi-row insert if you prefer.

Strings are quoted safely (single quotes are doubled, so O'Reilly becomes 'O''Reilly'), identifiers are quoted with backticks for MySQL and double quotes for PostgreSQL/SQLite, and nested objects or arrays are stored as JSON text (JSON in MySQL, JSONB in PostgreSQL).

Type inference

How to use it

1. Paste a JSON array of objects (a single object also works).
2. Set the table name and SQL dialect.
3. Review the generated column types — add primary keys, indexes or tighter VARCHAR lengths as needed — then copy or download the .sql file.

Example

[{"id": 1, "name": "O'Neil", "active": true}]

CREATE TABLE IF NOT EXISTS "users" (
  "id" INT NOT NULL,
  "name" VARCHAR(255) NOT NULL,
  "active" BOOLEAN NOT NULL
);

INSERT INTO "users" ("id", "name", "active") VALUES (1, 'O''Neil', TRUE);