JSON to SQL
Turn a JSON object or an array of objects into a CREATE TABLE schema plus INSERT statements. Column types are inferred from your data. Pick your database dialect below.
Frequently asked questions
Can I insert many rows at once?
Yes — paste an array of objects and you get one INSERT per row plus a single CREATE TABLE based on the union of all keys.
How are nested objects handled?
Nested objects and arrays are stored as JSON strings in a text column. Flatten your data first if you want separate columns.