Is my JSON data sent to a server?

No. All conversion happens entirely in your browser using JavaScript. Your JSON never leaves your device — nothing is uploaded, logged, or stored anywhere.

How are nested objects and arrays handled?

Nested objects and arrays are not flattened into separate columns. Instead, they are stored as a serialized JSON string in a single column using the appropriate JSON storage type for each dialect: JSONB (PostgreSQL), JSON (MySQL), CLOB (Oracle), or NVARCHAR(MAX) (MSSQL).

Why does Oracle use a different batch INSERT syntax?

Oracle does not support the standard multi-row VALUES syntax used by MySQL, PostgreSQL, and MSSQL (INSERT INTO t VALUES (...), (...)). Instead, Oracle uses INSERT ALL with multiple INTO clauses followed by SELECT * FROM dual, which is the Oracle-standard way to insert multiple rows in a single statement.

JSON to SQL Converter

Processed entirely in your browser — JSON never leaves your device.

JSON Input

SQL Dialect

Table Name *

Output Mode

Batch multiple rows into one INSERT statement

About This Tool

Convert JSON objects or arrays into SQL INSERT statements — supports MySQL, PostgreSQL, Oracle, and MSSQL. Generates CREATE TABLE and batch INSERTs with dialect-correct quoting and type inference. All processing happens in your browser; nothing is sent to any server.

The converter applies dialect-correct identifier quoting — backticks for MySQL/MariaDB, double quotes for PostgreSQL and Oracle, and square brackets for MSSQL. Booleans are rendered as TRUE/FALSE for MySQL and PostgreSQL, and as 1/0 for Oracle and MSSQL. Nested objects and arrays are stored as serialized JSON strings in the appropriate JSON column type (JSONB, JSON, CLOB, or NVARCHAR(MAX)).

How To Use

Paste your JSON — enter a single object or an array of objects into the input field.
Select your SQL dialect — choose MySQL, PostgreSQL, Oracle, or MSSQL to match your database.
Enter a table name — provide the target table name for the generated SQL.
Choose an output mode — INSERT only, CREATE TABLE + INSERT, or CREATE TABLE only.
Click Convert — copy the generated SQL and use it directly in your database client.

Example

Input JSON

[
  { "id": 1, "name": "Alice", "active": true },
  { "id": 2, "name": "Bob",   "active": false }
]

PostgreSQL output (INSERT only)

INSERT INTO "users" ("id", "name", "active") VALUES (1, 'Alice', TRUE);
INSERT INTO "users" ("id", "name", "active") VALUES (2, 'Bob', FALSE);

Selecting Oracle dialect with batching enabled generates INSERT ALL … SELECT * FROM dual syntax instead.

Frequently Asked Questions

Is my JSON data sent to a server?: No. All conversion happens entirely in your browser using JavaScript. Your JSON never leaves your device — nothing is uploaded, logged, or stored anywhere.
How are nested objects and arrays handled?: Nested objects and arrays are not flattened into separate columns. Instead, they are stored as a serialized JSON string in a single column using the appropriate JSON storage type for each dialect: JSONB (PostgreSQL), JSON (MySQL), CLOB (Oracle), or NVARCHAR(MAX) (MSSQL).
Why does Oracle use a different batch INSERT syntax?: Oracle does not support the standard multi-row VALUES syntax used by MySQL, PostgreSQL, and MSSQL (INSERT INTO t VALUES (...), (...)). Instead, Oracle uses INSERT ALL with multiple INTO clauses followed by SELECT * FROM dual, which is the Oracle-standard way to insert multiple rows in a single statement.

Related Tools

JSON Formatter & Validator

Instantly format, pretty-print, or minify JSON. Catches syntax errors and highlights the exact line — no login, no uploads, all in your browser.