Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Open an in-memory database

Start a temporary database that lives only for the session.

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

Open an in-memory database

bash
bash
sqlite3 :memory:
Explanation

Useful for quick experiments, demos, and throwaway SQL tests.

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