JSON to SQL Converter

An array of records turned into a ready SQL script: a table and INSERT statements for your database.

Files never leave your device — everything runs in your browser

Data from an API or an export needs to go into a database, and writing INSERT statements by hand is slow and error-prone. The converter takes an array of objects and generates an SQL script: CREATE TABLE with inferred column types and INSERT statements in batches.

Types are worked out from the values: whole numbers become INTEGER or BIGINT, fractions DOUBLE or REAL, true and false BOOLEAN, dates in 2026-10-23 form DATE, timestamps TIMESTAMP, and everything else text. Each database gets its own dialect: identifier quoting, types and string escaping for PostgreSQL, MySQL, SQLite and SQL Server.

Nested objects unfold into columns such as customer_name. Set the table name, the batch size — SQL Server allows at most 1,000 rows per INSERT — and whether to add CREATE TABLE. Large IDs are written in full without rounding.

Nothing is uploaded: parsing and conversion run inside your browser, so API responses, CRM exports and files with personal data stay on your device.

What goes into the script

How to convert JSON to SQL in 3 steps

  1. 1

    Load the JSON

    An array of records, a file or the Sample.

  2. 2

    Pick the database

    PostgreSQL, MySQL, SQLite or SQL Server; table name and batch size.

  3. 3

    Download the SQL

    Run the script in your database client or migration.

Frequently asked questions

Load an array of records, pick the database and download the .sql file.
PostgreSQL, MySQL and MariaDB, SQLite and Microsoft SQL Server.
They unfold into indexed columns such as tags[0] and tags[1]. To split them into separate tables, use JSON to Excel with child sheets.
Yes, turn it off if the table already exists — you get only INSERT statements.

Related tools