Language
English

JSON to SQL

Generate INSERT statements from JSON data

MySQL
Create
Bulk
Quote
JSON Data
Paste JSON data here... e.g.: [{"id": 1, "name": "test"}]
SQL Statement
Conversion result will appear here...

togotools.top technical reference

Technical reference

Convert JSON arrays to SQL CREATE TABLE and INSERT statements locally in your browser. Supports MySQL, PostgreSQL, SQLite, and SQL Server dialects with configurable table names and identifier quoting.

Core features

  • Infers column names and types from JSON arrays to generate CREATE TABLE statements.
  • Generates INSERT statements with batch or row-by-row modes.
  • Supports MySQL, PostgreSQL, SQLite, and SQL Server dialects.
  • Configurable table name, identifier quoting, and CREATE TABLE generation.
  • Syntax-highlighted code editor with real-time JSON validation.

Example: before and after

Column types are inferred from JSON values: strings map to VARCHAR, numbers to INT or FLOAT, booleans to BOOLEAN. Identifier quoting adapts to each dialect automatically.

sql
[{"name":"Ada","age":30}]

CREATE TABLE users (
  name VARCHAR(255),
  age INT
);
INSERT INTO users (name, age) VALUES ('Ada', 30);

Limits

  • Input must be a JSON array of objects. Nested arrays and scalar arrays are not supported.
  • Type inference is based on the first element; mixed-type columns may be inferred inaccurately.
  • NULL values output as SQL NULL; empty strings output as empty strings.

Frequently asked questions

Which SQL dialects are supported?

MySQL, PostgreSQL, SQLite, and SQL Server. Identifier quoting symbols and type mappings adapt automatically to the selected dialect.

How are column types inferred?

Based on the first array element value type: strings map to VARCHAR(255), integers to INT, floats to FLOAT, booleans to BOOLEAN.