Convert JSON data to SQL INSERT statements with automatic CREATE TABLE generation. Perfect for importing JSON API data into MySQL, PostgreSQL, or SQLite databases. All processing is browser-based and private.
Paste a JSON array of objects, or drag and drop a .json file. Each object becomes a row. The first object determines the column names and types.
The tool auto-detects data types (INTEGER, REAL, BOOLEAN, TEXT) and generates a CREATE TABLE statement followed by INSERT statements for each row.
The output uses standard SQL compatible with MySQL, PostgreSQL, SQLite, and MariaDB. String values are properly escaped for safe SQL usage.
The default table name is "my_table". Edit the output directly to change it, or customize column types manually after generation.