JSON to SQL Converter
Turn a JSON array of objects into SQL INSERT statements, with optional CREATE TABLE. Runs entirely in your browser.
How it works
Frequently Asked Questions
A JSON array of objects. The union of all keys becomes the columns, so rows with missing keys insert NULL.
Strings are single-quoted with quotes doubled, numbers and booleans are written natively, and null becomes NULL.
No — the SQL is generated in your browser and never uploaded.
Convert JSON to SQL online for free. Paste a JSON array of objects and generate ready-to-run INSERT statements for MySQL or PostgreSQL, with identifiers quoted per dialect and values escaped correctly. Optionally generate a CREATE TABLE with column types inferred from the data. It is ideal for seeding a database, building fixtures or migrating data, and it runs entirely in your browser so nothing is uploaded.