About the JSON to SQL INSERT
Load JSON data into a database without writing a script. Paste a JSON object or an array of objects, name the table and choose the SQL dialect: PostgreSQL, MySQL/MariaDB, SQLite or SQL Server. Column names are quoted the right way for each database, strings are escaped, booleans and NULL are written correctly, and nested objects are stored as JSON text.
Optionally generate a CREATE TABLE statement with column types guessed from the data, and choose one multi-row INSERT or one statement per row. Review the guessed types before running it.
How to use the JSON to SQL INSERT
- Paste JSON and name the table.
- Choose the dialect and options.
- Copy or download the .sql file.
Features
- Four SQL dialects
- Escaped values
- Optional CREATE TABLE
- Multi-row or single inserts
Supported formats
- Plain text
Frequently asked questions
What if objects have different keys?
All keys become columns, and missing values are inserted as NULL.
Is my text sent anywhere?
No. Everything runs in your browser, so nothing you paste is uploaded or stored.
Added · Last reviewed · Maintained by Sohail Khax · How we test tools