SQLite to SQL Dump Online
Export ordinary SQLite tables, data, indexes, views and triggers as a SQL dump without uploading your database. No account or installation required. Your original file stays unchanged.
How to convert
- Open an unencrypted .db, .sqlite or .sqlite3 file in the workspace.
- Select a table to browse it, or write a query. Filters and sorting apply across the database.
- Choose Export data, select SQL, and save the complete export.
What the download contains
Open your database and choose Export data → SQL dump. The dump includes ordinary table definitions, inserted rows, indexes, views, triggers and AUTOINCREMENT sequences. Restore it into an empty database using the SQLite CLI. Virtual and shadow tables are rejected; use Export database for those. Hidden rowids and database-specific settings are not preserved by this logical dump.
-- Output includes schema and data:
CREATE TABLE example (id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO example (id, name) VALUES (1, 'Sample');Complete export, bounded preview
The grid displays a bounded preview. CSV, JSON, Excel and PDF export runs one read-only SELECT again against the current database; it respects any LIMIT in your query. It does not rerun writes or export cached results. To export a whole table, select Current table with applied filters and sorting. Export one table per download.
File size and browser support
Rows are processed in chunks with progress and cancellation. Browsers with direct file saving write to disk; other browsers use a download limited to 64 MiB. Exceeding that limit fails explicitly instead of downloading a partial result. Large individual values and query execution limits still apply. Saved SQLite imports use browser storage; temporary database imports are limited to 100 MiB.
Keep a database backup
Use Export database for a complete SQLite snapshot, including full BLOBs. CSV and JSON are data formats, not schema-preserving backups. SQL dumps contain transaction commands that the workspace deliberately rejects; restore them in an external SQLite client.
Read the export guide · SQLite viewer · Convert CSV to SQLite