pettiYour rows, right away.
Choose a table and start exploring. Search, sort and combine filters in a familiar grid. See every active filter and clear them all in one click.
How to open a SQLite file A LITTLE APP FOR YOUR BIG DATABASES
SQLite. As easy as
a spreadsheet.
Open a database. Find your rows. Edit when you choose.
A native SQLite viewer and editor that feels at home on your Mac.
macOS 14+Read-only by defaultYour database stays on your Mac
Less setup. More “there it is.”
Interactive preview · sample data8 rows loaded
Try it: search for “Maya”, sort a column, or unlock and double-click a cell.
This preview uses sample data in your browser. The Mac app opens real SQLite files.
10 millionrows in our generated test database
500 at a timebounded pages, rather than a full-table load
100% localdatabase work happens on your Mac
THE GOOD PART OF WORKING WITH DATA
A database tool.
Without the database-tool feeling.
You don’t need a new workflow just to check a value or fix a row.
Look first. Edit on purpose.
Every database opens with a genuine read-only connection. Unlock when you’re ready, edit inline, paste spreadsheet cells, and undo cell changes.
How read-only mode worksBig tables. Small appetite.
Petti fetches rows as you browse and keeps a bounded cache. Opening a database doesn’t automatically count every row or load the whole table.
What makes large files differentFROM FILE TO FIRST EDIT
Three steps.
No ceremony.
For app developers inspecting local data, analysts checking an export, and anyone who just needs to see what’s inside a SQLite file.
- 1
Open your .sqlite, .db or .sqlite3 file.
Your tables appear in the sidebar. Browse safely in read-only mode.
- 2
Get to the rows that matter.
Search the current table, sort a column, or add a filter. No SQL required for everyday browsing.
- 3
Unlock. Double-click. Done.
Change a cell and press Return to save. Keep using SQL whenever you need more control.
SMALL APP. USEFUL DETAILS.
Simple doesn’t mean limited.
Native window tabs
Keep databases together, or move a tab into its own window to compare files side by side.
SQL when you need it
Write queries with syntax highlighting, browse results, revisit query history and cancel work in progress.
Structure at a glance
Inspect columns, keys, indexes, triggers and CREATE statements. Schema changes create a backup first.
Data in. Data out.
Import CSV. Export a table, filtered results or selected rows to CSV, JSON or SQL.
Spreadsheet muscle memory
Copy and paste cells, navigate with the keyboard, insert rows and undo cell edits.
Quick Look in Finder
Select a SQLite file and press Space. See table names, table, view and index counts, file size and modification date without opening Petti.
No database upload
The app reads your local file. No account, cloud database or server setup is needed to browse and edit.
BEFORE YOU OPEN THAT FILE
Good questions.
Straight answers.
What is Petti?
Petti is a native SQLite viewer and editor for macOS. It helps you browse tables, search and filter rows, edit cells, inspect database structure, run SQL, and import or export data.
Can I preview a SQLite file in Finder?
Yes. Petti includes a Quick Look extension. Select a SQLite file in Finder and press Space to preview its table names, table, view and index counts, file size and modification date. Choose Open with Petti when you want to browse the rows.
Can I use Petti without knowing SQL?
Yes. Choose a table in the sidebar to browse it. You can search, sort, filter and edit through the grid. The SQL editor is there for the tasks where a query is more useful.
Will opening a database change it?
Petti opens databases with a read-only SQLite connection. You must explicitly unlock editing to obtain a writable connection. Once unlocked, edits save to the database; they are not a separate unsaved document.
Can it open a database with millions of rows?
Petti has been tested with generated databases of 10,000, one million and ten million rows. It loads bounded pages and uses a bounded row cache. Performance still depends on indexes, storage, query complexity and cell sizes; an unindexed search or sort can take time.
Which Macs and file formats are supported?
The current build targets Apple silicon Macs running macOS 14 or later. Petti opens SQLite files, commonly named .sqlite, .sqlite3 or .db. A .db extension alone does not guarantee the file is SQLite. SQLCipher-encrypted databases are not supported in this release.
Does my database leave my Mac?
No. Database operations in the app run locally. Petti does not upload database contents, and the current app has no telemetry or account system. See the privacy page for the distinction between the app and this website.
How much does Petti cost?
Petti 1 is a one-time US$14.99 purchase, with a US$9.99 launch offer for the first 100 purchases. All Petti 1.x updates are included. Checkout and public downloads are not open yet.
Are future versions and connectors included?
All Petti 1.x updates are included with Petti 1. Petti 2 and later major versions may have different pricing and are not included. Direct CSV querying and platform connectors are planned ideas, not current features or promised entitlements; connectors may be sold separately. Read the license and update details.
A LITTLE HELP WITH SQLITE
Start with the file you have.
GETTING STARTED · 4 MIN
How to open a SQLite file on a Mac
Identify the file, open it safely, and find your first table.
↗DATA SAFETY · 3 MINWhat read-only mode actually means
Understand the difference between looking at data and changing it.
↗LARGE DATABASES · 4 MINBrowsing millions of SQLite rows
Why paging, indexes and query cancellation matter.
↗ONE PAYMENT. YOUR PETTI 1.
Small price.
Less friction.
Get the complete Petti 1 app, with every update in the 1.x series included. No subscription.
Petti 2 and later major versions are separate. Future connectors may be priced separately. Buy for what Petti does today.
License & update details ↗PETTI 1 · LAUNCH OFFER
Final tax and payment details will appear at checkout.
$9.99USD / once
Regular price $14.99 · First 100 purchases
- SQLite browsing, editing and SQL queries
- CSV import · CSV, JSON and SQL export
- Every Petti 1.x update included
Checkout opens at launch.
Try the interactive preview ↑macOS 14+ · Apple siliconFinal tax and payment details will appear at checkout.