JSON to SQL Converter

Turn a JSON array of objects into SQL INSERT statements, with optional CREATE TABLE. Runs entirely in your browser.

📖 Read the guide: How to Convert JSON to SQL →

JSON (array of objects)
SQL 

      

      

    
    

      
How it works

      
1
Paste your JSON
Provide a JSON array of objects — each object becomes a row.
2
Set the table & dialect
Enter the target table name and pick MySQL or PostgreSQL quoting.
3
Convert
Get one INSERT per row, with values quoted and escaped correctly.
4
Optional CREATE TABLE
Tick the box to also generate a CREATE TABLE with inferred column types.

    

    

      
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.