Skip to content
LovTools
EN

JSON to SQL INSERT

Convert JSON objects into SQL INSERT statements and a CREATE TABLE.

Processed locally on your device — nothing is uploaded.

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

  1. Paste JSON and name the table.
  2. Choose the dialect and options.
  3. 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