English

JSON to SQL Converter

Convert JSON arrays into SQL INSERT statements or a CREATE TABLE schema. Free JSON to SQL converter that infers column types from your data.

JSON input

Paste an array of objects.

SQL output

Ready to run.

Table name

SQL dialect

Rows per INSERT

Include CREATE TABLE Flatten nested objects

Records

Columns

Statements

Shape

—

JSON to SQL Converter

Convert a JSON array of records into SQL INSERT statements, with an optional CREATE TABLE. Nested objects are flattened into dot-separated column names so nothing is silently dropped.

How to Use

Paste a JSON array of objects — a typical API response — and the converter builds the union of all keys across every record. Missing values become NULL, nested objects are flattened, and arrays are stored as JSON text.

Accepts an array, a single object, or a wrapper object
Union of keys across all records
Nested objects flattened to parent.child columns
Column types inferred from the values
MySQL, PostgreSQL, SQLite and SQL Server output

Related Developer Tools

Browse all Developer Tools →

You might also need

Tools from other categories that people pair with the JSON to SQL:

Browse the full tool directory →