Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/List shell commands

Display available dot-commands.

Back to sheetBrowse commands
Sign in to save
Section: Open and inspect databases

List shell commands

text
text
.help
Explanation

Useful when working on a new machine or less-familiar sqlite3 version.

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 Open and inspect databases
Open a database file
Start the sqlite3 shell with a file-backed database.
OpenIn sheetbashsame section
Open an in-memory database
Start a temporary database that lives only for the session.
OpenIn sheetbashsame section
List attached databases
Show the main database and any attached files.
OpenIn sheettextsame section
List tables
Show table names in the current database.
OpenIn sheettextsame section
Show full schema
Print CREATE statements for the whole database.
OpenIn sheettextsame section
Show schema for one table
Print the CREATE statement for a specific object.
OpenIn sheettextsame section