Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Dump the full database as SQL

Export schema and data as executable SQL.

Back to sheetBrowse commands
Sign in to save
Section: Output, import, and export

Dump the full database as SQL

text
text
.dump
Explanation

Helpful for backups, migrations, and reproducible fixtures.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Output, import, and export
Show column headers
Enable headers in tabular output.
OpenIn sheettextsame section
Use aligned column output
Render query results in a readable table.
OpenIn sheettextsame section
Export rows as CSV
Switch output mode to CSV.
OpenIn sheettextsame section
Import a CSV file into a table
Load rows from CSV using the shell importer.
OpenIn sheettextsame section
Execute SQL from a file
Run a script inside the shell.
OpenIn sheettextsame section
Write the next query result to a file
Send one result set to a file without changing subsequent output.
OpenIn sheettextsame section