Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Open a database file

Start the sqlite3 shell with a file-backed database.

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

Open a database file

bash
bash
sqlite3 app.db
Explanation

Creates the file if it does not exist and opens an interactive shell session.

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 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
Show schema plus sqlite_stat tables
Include internal objects useful for advanced debugging.
OpenIn sheettextsame section