How to open a SQLite file on a Mac
Your Mac can already do it. Open Terminal, type sqlite3 -readonly followed by the file's path, and then .tables to see what's inside. If you'd rather click than type, DB Browser for SQLite is free, and Tabel, the database app I make for the Mac, opens the file in a window with the tables on the left. If another app is using the file, close that app or open a copy.

Three ways to open a SQLite file
sqlite3 in Terminal
A few typed commands. Nothing to install, and ‑readonly keeps the file safe.
DB Browser for SQLite
A free app with tabs for the data, the structure and SQL.
Tabel
A Mac app: tables in the sidebar, rows in the middle, one row in the inspector.
Is it a SQLite file?
Lots of apps keep their data in SQLite. The file usually ends in .sqlite, .sqlite3 or .db, but some apps use their own extension. To be sure, type file and a space in Terminal, drag the file into the window and press Return. For a SQLite database, it prints SQLite 3.x database.
In Terminal, with sqlite3
macOS comes with the sqlite3 command, so there's nothing to install.
- Open Terminal (in Applications › Utilities).
- Type
sqlite3 -readonlywith a space at the end, drag the database file into the window so its path is filled in, and press Return. - Type
.tablesto list the tables, and.schemafollowed by a table name to see its columns. - Type
.mode boxonce, then a query such asSELECT * FROM customers LIMIT 10;to see the rows in a bordered grid. Don't forget the semicolon. - Type
.quitwhen you're done.
A sqlite3 session
sqlite3 -readonly shop.dbopens the file read-only.tableslists the tables.schema customersshows how the customers table is built.mode boxshows results as a table with borders.quitquits sqlite3
With -readonly nothing you type can change the file, so it's safe to look around. Leave it out only when you mean to edit.
With a free app: DB Browser for SQLite
DB Browser for SQLite is free and open source, and it's made for exactly this. Download it from sqlitebrowser.org, or with Homebrew: brew install --cask db-browser-for-sqlite. Open the file, and the app's tabs show the rows, how the tables are built and a place to run SQL.
It runs on Windows and Linux too, and it looks it: fine for a quick look, a bit clunky if you use it every day.
With Tabel
Tabel is the Mac database client I make. Choose File › Open SQLite File… (⌘O) and pick the file, or drag it onto Tabel's start window. The tables are in the sidebar with their row counts. Click one to page through the rows, sort, filter and read a whole row in the inspector. Structure shows the columns, indexes and the CREATE statement.


- Every table, with row counts
- One row in full, long text and JSON included
- Columns, types and defaults
- The CREATE statement, ready to copy
Tabel runs in Apple's App Sandbox, so the first time it asks for access to the folder the file is in, because SQLite writes its helper files next to the database. If you only want to look, choose Open Read-Only instead and Tabel won't write anything. Tabel costs $4.99, once, and it works with PostgreSQL too.
If an app is using the file
A database in WAL mode has two more files next to it, ending in -wal and -shm. The -wal file can hold changes that haven't reached the main file yet. So quit the app that owns the database first, or copy all three files together and open the copy.
A database in WAL mode is three files
shop.dbthe databaseshop.db-walchanges not yet written to the databaseshop.db-shma shared index the -wal file needsSome files in your Library folder, such as the Messages database chat.db, are protected by macOS. Terminal, or the app you open them with, needs Full Disk Access first, under System Settings › Privacy & Security.