SQLite to SQL Dump - Export Database as SQL Statements

Export SQLite database as SQL dump file with CREATE and INSERT statements. Perfect for backups and migrations. Browser-based.

Load Database

Drop SQLite file here or click to browse

Load a database to generate SQL dump

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

CREATE TABLE statements, INSERT statements for all data, indexes, and optionally views and triggers.

The output uses standard SQL. Minor adjustments may be needed for MySQL, PostgreSQL, or other databases.

Yes. Toggle 'Include data' off to export only CREATE statements without INSERT statements.

Binary data is encoded as hex literals (X'...'). This is SQLite-compatible for reimport.

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

Yes. After loading, choose which tables to include in the dump.

Tables are ordered to respect foreign key dependencies when possible. PRAGMA foreign_keys is included.

Yes. The SQL dump can be imported into other SQLite tools, and adapted for other databases.

Browser memory limits apply. The dump file can be much larger than the database due to SQL verbosity.

Yes. Comments indicate table names and row counts for easier navigation.