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.

A glass jar of mint, white and amber tiles on a light desk, with a magnifying glass and a teal lid beside it

Three ways to open a SQLite file

sqlite3 in Terminal

A few typed commands. Nothing to install, and ‑readonly keeps the file safe.

Comes with macOSTyped commands only

DB Browser for SQLite

A free app with tabs for the data, the structure and SQL.

Free, open sourceMac, Windows, Linux

Tabel

A Mac app: tables in the sidebar, rows in the middle, one row in the inspector.

Mac onlyPostgreSQL too
Prices from each project's own website, checked 3 November 2026.

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.

  1. Open Terminal (in Applications › Utilities).
  2. Type sqlite3 -readonly with a space at the end, drag the database file into the window so its path is filled in, and press Return.
  3. Type .tables to list the tables, and .schema followed by a table name to see its columns.
  4. Type .mode box once, then a query such as SELECT * FROM customers LIMIT 10; to see the rows in a bordered grid. Don't forget the semicolon.
  5. Type .quit when 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.

Tabel with a customers table open: the tables in the sidebar, the rows in the middle and one row in the inspector1Every table, with row counts2One row in full, long text and JSON included
Tabel's Structure view of the customers table: columns, indexes, constraints and the CREATE statement3Columns, types and defaults4The CREATE statement, ready to copy
  1. Every table, with row counts
  2. One row in full, long text and JSON included
  3. Columns, types and defaults
  4. The CREATE statement, ready to copy
Shown here with a PostgreSQL database; a SQLite file opens in the same window.

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 database
shop.db-walchanges not yet written to the database
shop.db-shma shared index the -wal file needs
Copy them together, with the app that owns them closed.

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