SQLite Viewer for Mac

Open a SQLite file, choose a table, and browse its rows. Petti is a native Mac app for inspecting databases without setting up a database server or a full database IDE.

From a file to a table

1. Choose Open Database in Petti, or press ⌘O.
2. Select a .sqlite, .sqlite3, or SQLite .db file.
3. Choose a table in the sidebar. Rows appear in a spreadsheet-style grid.

The extension alone does not establish the format. If you received an unfamiliar .db file, check whether it is SQLite first. Petti 1 does not open SQLCipher-encrypted databases.

Find a value without writing SQL

Use Search current table, add column filters, or click a column heading to sort. Active conditions remain visible, and Clear All removes search and filters. The Structure view shows the table’s schema; the Query view lets you run SQL when a grid is not enough.

Read-only starts at the database connection

Petti opens files with a genuine read-only SQLite connection. Viewing, searching, filtering and exporting do not require a paid license. To change data, activate a license and deliberately unlock the database. See what read-only mode protects and how editing works.

Large tables, small pages

Petti fetches rows as you browse and keeps a bounded cache. It does not load the whole table or automatically count every row when you open a file. An unindexed search or sort can still take time: query cost matters even with lazy loading.

A local Mac workflow

Your database contents stay on your Mac. With Petti installed, press Space in Finder to preview database information before opening it. The current release supports Apple silicon Macs running macOS 14 or later.

Choosing between tools? Compare Petti with DB Browser for SQLite, or browse the SQLite app comparisons.