Import and export SQLite data
Export SQLite tables and results; use paste into the grid for input instead of a visual import or dump workflow.
SQLite over SSH has been requested in other tools since 2023, with 45 votes.
SQLite has an export workflow for local tables and query results. The shared export dialog receives the relation, current filters, sort order and selected scope before starting the writer.
Export a local source
- Open a table or query result.
- Choose the rows to export: all, filtered, selected or loaded rows.
- Choose CSV, JSON, JSON Lines, SQL, Markdown or XLSX.
- Review the preview and destination before starting the job.
SQLite SQL export does not add PostgreSQL-only features. There is no schema qualification, sequence handling or CASCADE option because those concepts do not belong to the SQLite writer. The output reflects the SQLite relation and the storage classes carried by the result.
Remote sources
For Turso / libSQL and Server over SSH, the form shows no export to file and no File panel. Grid, editing and console work; local files use the local export workflow.
Input and schema changes
SQLite uses paste into the grid for input: place the values in the table surface, review the staged changes and save them with Ctrl+S. SQLite has no dump/restore workflow in this surface.
Use Ctrl+Z and Ctrl+Y for staged edits. SQL remains the route for DDL, pragmas and migrations.