Desenvolvimento

JSON to SQL Converter

Convert JSON arrays of objects to SQL INSERT statements — choose your database dialect and table name

Confiado por mais de 10 mil desenvolvedores

Table Name

Dialect

JSON Input (array of objects)

SQL Output

CREATE TABLE `users` (
  `id` INT,
  `name` VARCHAR(255),
  `email` VARCHAR(255),
  `active` TINYINT(1),
  `score` DECIMAL(10,2)
);

INSERT INTO `users` (`id`, `name`, `email`, `active`, `score`) VALUES
(1, 'Alice', 'alice@example.com', 1, 9.5),
(2, 'Bob', 'bob@example.com', 0, 7);

Type Inference Rules

JSON Type	MySQL	PostgreSQL	SQLite	SQL Server
integer	INT	INT	INT	INT
float	DECIMAL(10,2)	DECIMAL(10,2)	DECIMAL(10,2)	DECIMAL(10,2)
string	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
boolean	TINYINT(1)	BOOLEAN	BOOLEAN	BIT
null	NULL	NULL	NULL	NULL