How does SQLite mode differ from PostgreSQL?

Booleans become 1 and 0, and identifiers use double quotes. String escaping is the same in both.

Can I load the output with the sqlite3 CLI?

Yes. Save the file and run it with .read path/to/file.sql in the sqlite3 shell.

Does it support BLOB data?

Values are treated as text or numeric based on the column. Binary BLOBs are out of scope for this release.

Is there a per-statement size limit?

SQLite favors smaller batches; 100 or 500 rows per statement is a safe default.

SQLite INSERT statement generator

SQLite mode writes booleans as 1 and 0 and quotes identifiers with double quotes, matching SQLite's SQL dialect. It is handy for seeding a local .db file or a mobile app's bundled database.

As with every page here, the data is read and converted on your device and never transmitted.

SQL INSERT

Drop a file to generate INSERT statements

Processing stays in this browser. Guests can process up to 500 rows per file.

How to use this tool

1Drop your file onto the panel.
2Set Dialect to SQLite.
3Adjust the batch size if your tool prefers smaller chunks.
4Copy the INSERT statements.

Frequently asked questions

How does SQLite mode differ from PostgreSQL?: Booleans become 1 and 0, and identifiers use double quotes. String escaping is the same in both.
Can I load the output with the sqlite3 CLI?: Yes. Save the file and run it with .read path/to/file.sql in the sqlite3 shell.
Does it support BLOB data?: Values are treated as text or numeric based on the column. Binary BLOBs are out of scope for this release.
Is there a per-statement size limit?: SQLite favors smaller batches; 100 or 500 rows per statement is a safe default.

Private by design

This tool runs entirely in your browser. Files, tables, and results are never uploaded to a server — you can even disconnect your network and keep working. See the Privacy Policy.