JSON to SQL
Paste a JSON array and get a CREATE TABLE plus batched INSERT statements back — column types inferred, strings escaped. It all runs in your browser.
CREATE TABLE + INSERT statements appear here.
Runs in your browser. Your input is not uploaded to PayloadIQ.
JSON to SQL turns a JSON array into seed SQL you can paste into a migration or a psql/sqlite shell. It emits a CREATE TABLE IF NOT EXISTS with a column per key — types inferred as INTEGER, REAL, BOOLEAN or TEXT — followed by a single batched INSERT … VALUES with one row per object. String values are single-quoted and escaped, booleans become TRUE/FALSE, and nulls become NULL. Everything runs locally in your browser, so a real data export never leaves your machine.
From an export to seed data
Paste an array of objects for many rows, or a single object for one. Set the table name with the Table-name field. The keys of the first records define the columns, so use representative records — and review the inferred column types before running the SQL (money is usually better as NUMERIC, large ids as BIGINT).
Portable, reviewable SQL
The output uses portable syntax (quoted identifiers, TRUE/FALSE, NULL) that works across PostgreSQL, SQLite and MySQL for typical seed data. It is meant for SQL you review and run yourself — not for executing untrusted input. Need CSV instead, or types in another language? Try JSON to CSV or the PayloadIQ playground.