JSON to SQLite Converter - Import JSON to Database

Convert JSON arrays to SQLite database tables. Import multiple JSON files, auto-detect schema. Browser-based, no uploads.

Import JSON Files

Choose JSON Files

or drag and drop JSON files here

Add auto-increment ID column

Import JSON files to preview the database

Security: Only process files from sources you trust. All processing happens locally in your browser.

JSON arrays of objects like [{"name": "John", "age": 30}, ...]. Each object becomes a row, keys become columns.

Types are inferred from values: numbers become INTEGER or REAL, booleans become INTEGER (0/1), strings become TEXT, null remains NULL.

Yes. Each JSON file creates a separate table. Table names are derived from filenames.

Nested objects and arrays are stored as JSON text strings. SQLite 3.38+ supports JSON functions to query them.

No. All processing happens locally using SQL.js. Your JSON data never leaves your browser.

Enable 'Add auto-increment ID' to create an id column as the primary key for each table.

All unique keys across objects are used as columns. Missing keys in any object become NULL values.

Depends on browser memory. Files under 50MB typically work well. Very large files may cause slowdowns.

Yes. After import, you can browse tables and run queries before downloading the database file.

Standard SQLite database file (.sqlite) compatible with all SQLite tools and libraries.