Every database opens with a genuine read-only connection. With an editing license, unlock when you’re ready, edit inline, paste spreadsheet cells, and undo cell changes.

How read-only mode works

03 / SCALE · FREE

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

NEW IN PETTI 1.4.1

Clean up rows.
Bring corrected data back.

The paid editing license adds guided tools for repetitive changes. Preview the affected rows and keep a recovery snapshot before saving.

PAID · BULK CLEANUP

Fix a column in one pass.

Trim whitespace, replace text or turn empty strings into NULL across selected or filtered rows. Review the before and after before applying the change.

Explore Clean Up Rows ↗

PAID · CSV RECONCILIATION

Update rows from a corrected CSV.

Map columns, match existing records by primary key, and preview inserts and updates. Save the mapping for the next file.

Explore Reconcile CSV ↗

FREE · COMPARE & EXPORT

See changes. Export a patch.

Compare saved snapshots and export selected row changes as a guarded SQL patch from supported comparisons. Exporting does not apply the patch.

Use snapshots and comparisons ↗

Guided cleanup and CSV reconciliation support ordinary tables with non-null primary keys. Tables with triggers, foreign-key dependencies or generated columns are not supported. See current limits and in-app updates.

FROM 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
Activate. Unlock. Edit.
Activate an editing license, 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 fixtures up to 100 million rows and 10.05 GB on an M1 Mac with 8 GiB RAM. These are local test results, not a speed guarantee for every database. 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 requires an Apple silicon Mac running macOS 14 or later. Intel Macs are not supported. To check your Mac, open Apple menu → About This Mac: look for an Apple M-series chip. 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. Download and use read-only browsing, search, exports and read-only SQL for free. A license unlocks cell and row editing, bulk cleanup, CSV import and reconciliation, schema changes and write queries. Cleanup and reconciliation include a change preview and a recovery snapshot for supported tables.

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.

All guides ↗

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 MIN

What read-only mode actually means

Understand the difference between looking at data and changing it.

LARGE DATABASES · 4 MIN

Browsing millions of SQLite rows

Why paging, indexes and query cancellation matter.

ONE PAYMENT. YOUR PETTI 1.

From finding a problem
to fixing the data.

Unlock editing, bulk cleanup and CSV reconciliation with one payment. All Petti 1.x updates 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 · PAID EDITING LICENSE

$9.99USD / once

Regular price ~~$14.99~~ · First 100 purchases

Clean up rows in bulk — trim, replace text and clear empty values
Import & reconcile CSV — map columns, preview inserts and updates
Edit your database — cells, rows, schema changes and write SQL

Free: browsing, filters, exports and read-only SQL. Paid: the editing tools above, plus every 1.x update. Activate through Petti → License. Guided editing limits ↗

Apple silicon only · macOS 14+
Intel Macs aren’t supported in this release.

Updating from 1.4.0 or earlier? Install 1.4.1 manually once. Future releases can be discovered inside Petti.

Buy Petti 1 Download for Apple silicon ↓

macOS 14+ · Apple silicon · Signed & notarized
Open the DMG and drag Petti into Applications.
Final price and applicable taxes are shown at checkout.

SQLite. As easy asa spreadsheet.

Less setup. More “there it is.”

Tutorials: learn with a real database.

Find your first answer with SQL

See exactly what changed

Bring a CSV into SQLite

Use cases for your everyday data work.

Debug what your app saved

Investigate a database bug report

Answer a question with local data

Check a CSV before sharing it

A database tool.Without the database-tool feeling.

Your rows, right away.

Look first. Edit on purpose.

Big tables. Small appetite.

Clean up rows.Bring corrected data back.