Enjoy this cheat sheet at its fullest within Dash, the macOS documentation browser.

Meta Commands

.backup ?DB? FILE

Backup DB (default "­mai­n") to FILE

.bail ON|OFF

Stop after hitting an error. Default OFF


List names and files of attached databases

.dump ?TABLE? ...

Dump the database in an SQL text format.

.echo ON|OFF

Turn command echo on or off


Exit this program

.explain ?ON|OFF?

Turn output mode suitable for EXPLAIN on or off.

.header(s) ON|OFF

Turn display of headers on or off


Shows this inform­ation.

.import FILE TABLE

Import data from FILE into TABLE

.indices ?TABLE?

Show names of all indices

.load FILE ?ENTRY?

Load an extension library

.log FILE|off

Turn logging on or off. FILE can be stderr­/stdout

.mode MODE ?TABLE?

Set output mode where MODE is one of: csv, column, html, insert, line, list, tabs, tcl

.nullvalue STRING

Print STRING in place of NULL values

.output FILENAME

Send output to FILENAME

.output stdout

Send output to the screen


Replace the standard prompts


Exit this program



.restore ?DB? FILE

Restore content of DB (default "­mai­n") from FILE

.schema ?TABLE?

Show the CREATE statements

.separator STRING

Change separator used by output mode and .import


Show the current values for various settings

.stats ON|OFF

Turn stats on or off

.tables ?TABLE?

List names of tables

.timeout MS

Try opening locked tables for MS millis­econds

.width NUM1 NUM2 ...

Set column widths for "­col­umn­" mode

.timer ON|OFF

Turn the CPU timer measur­ement on or off


-init file

Read and execute commands from file , which can contain a mix of SQL statements and meta-c­omm­ands.


Print commands before execution.


Turn headers on or off.


Stop after hitting an error.


Force intera­ctive I/O .


Force batch I/O .


Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output.


Set output mode to CSV (comma separated values).


Query results will be output as simple HTML tables.


Query results will be displayed with one value per line, rows separated by a blank line. Designed to be easily parsed by scripts or other programs


Query results will be displayed with the separator (|, by default) character between each field value. The default.

-separator separator

Set output field separator. Default is "|".


Print memory stats before each finalize.

-nullvalue string

Set string used to represent NULL values. Default is (empty string).


Show SQLite version.

-vfs name

Use name as the default VFS .


Show help on options and exit.