Loading…
Convert JSON data to SQL INSERT statements with CREATE TABLE support. Review the result before reusing it in another workflow.
CREATE TABLE `users` (
`id` INT NOT NULL,
`name` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`age` INT NOT NULL,
`active` TINYINT(1) NOT NULL,
`created_at` DATE NOT NULL
);
INSERT INTO `users` (`id`, `name`, `email`, `age`, `active`, `created_at`)
VALUES
(1, 'John Doe', 'john@example.com', 30, 1, '2024-01-15'),
(2, 'Jane Smith', 'jane@example.com', 25, 1, '2024-01-16'),
(3, 'Bob Wilson', 'bob@example.com', 35, 0, '2024-01-17');Integer
Whole numbers → INT
Float
Decimal numbers → FLOAT/DECIMAL
Boolean
true/false → BOOLEAN/TINYINT
String
Text → VARCHAR
Date
YYYY-MM-DD → DATE
DateTime
ISO 8601 → DATETIME/TIMESTAMP
Null
null → NULL
Array/Object
→ JSON/TEXT (serialized)