Show the main database and any attached files.
Section: Open and inspect databases
List attached databases
text
text
.databasesExplanation
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.
Open an in-memory database
Start a temporary database that lives only for the session.
Show schema for one table
Print the CREATE statement for a specific object.
Show schema plus sqlite_stat tables
Include internal objects useful for advanced debugging.