How to convert json to sqlite insert statements
- Step 1Prepare the JSON array — Each object in the array maps to one SQLite row. Keep the JSON flat — SQLite does not have a native JSON column type in older versions, so nested objects should be flattened first.
- Step 2Set the table name and check types — Enter the SQLite table name. Review the inferred type mapping: strings become TEXT, integers INTEGER, decimals REAL. Adjust if a numeric ID should be INTEGER PRIMARY KEY.
- Step 3Download the .sql file — Save the output as seed.sql or include in your app's database initialization bundle.
- Step 4Run with sqlite3 or initialize in code — For CLI: sqlite3 app.db < seed.sql. For Node.js: const db = new Database('app.db'); db.exec(fs.readFileSync('seed.sql', 'utf8')). For iOS, include the .sql in your app bundle and run it on first launch.
Frequently asked questions
Does SQLite support JSON column storage?+
SQLite 3.38.0+ includes built-in JSON functions (json_extract, json_object, etc.), and any TEXT column can store JSON strings. For modern SQLite versions, nested JSON objects in the input can be serialized as JSON strings for TEXT columns. Use json_extract() in queries to access nested values.
How do I handle auto-increment primary key columns?+
Omit the primary key column from the INSERT statement column list and the VALUES clause — SQLite's AUTOINCREMENT or INTEGER PRIMARY KEY will assign IDs automatically. Use the column filter option to exclude your id or _id key from the generated SQL.
Is the fixture data sent to JAD Apps?+
No. SQL generation runs entirely in your browser. Local app data, mobile fixture records, and any sensitive values are never transmitted to JAD Apps servers.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.