Convert JSON data to SQL INSERT statements
Enter JSON data to convert to SQL
Your converted data will appear here
Arrays of objects work best as each object becomes a table row. Single objects are converted to single INSERT statements. Nested objects are serialized as JSON strings.
Strings are quoted and escaped, numbers remain as-is, booleans become TRUE/FALSE, null becomes NULL, and complex objects/arrays are JSON-encoded as strings.
Yes! You can set custom table names, include CREATE TABLE statements with TEXT columns, and control which part of your JSON to convert.
If your JSON objects have a '_table' field, that value will be used as the table name for that specific record, allowing multi-table INSERT generation.