SQLite CLI and Shell Cheatsheet/List attached databases

Show the main database and any attached files.

Section: Open and inspect databases

List attached databases

text
text
.databases
Explanation

Displays the database aliases and file paths known to the current connection.

Learn the surrounding workflow

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

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 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