JSON to SQL Converter - Generate CREATE TABLE & INSERT

What is JSON to SQL?

JSON to SQL is a tool that automatically generates SQL CREATE TABLE and INSERT statements from JSON data. It maps JSON object keys to column names and maps value types to SQL types (VARCHAR, INTEGER, BOOLEAN, FLOAT, etc.). Use it for test data insertion, database design template creation, and data migration preparation. All processing happens entirely in your browser, so JSON containing sensitive data can be used safely.

See also: JSON Formatter · JSON ⇔ CSV · JSON to XML

How to Use

1. Paste JSON into the left area (array or object)
2. Optionally change the table name
3. Click 'Convert to SQL' button

Usage Examples

Input:
[{"id":1,"name":"John Smith","age":30,"active":true}]

SQL output:
CREATE TABLE users (
  id INTEGER,
  name VARCHAR(255),
  age INTEGER,
  active BOOLEAN
);

INSERT INTO users (id, name, age, active)
VALUES (1, 'John Smith', 30, true);

Practical use: Auto-generate DB table definitions and INSERT statements from mock data JSON to reduce development environment setup time

FAQ

Does it work with JSON arrays?

Yes. Each array element is generated as an INSERT statement.

How are SQL types inferred?

Strings map to VARCHAR(255), integers to INTEGER, decimals to FLOAT, booleans to BOOLEAN, and nulls to NULLABLE.

How are NULL values handled?

Columns containing NULL are defined as nullable (DEFAULT NULL). NULL is output as-is in INSERT statements.

Where can I change the table name?

You can change it in the 'Table name' input field at the top of the tool. The default is 'data'.

Is my data sent to a server?

No. All conversion processing happens entirely in your browser. Sensitive data is safe.

Related Tools