SQLite Editor for Mac

Petti lets you edit SQLite cells much like a spreadsheet, while keeping inspection and changes separate. Open in read-only mode; unlock when you intend to write.

How to edit a SQLite value

1. Open the database and select a table.
2. Activate your Petti 1 license and click the lock to enable editing.
3. Double-click a cell, change the value, and press Return or Tab to commit it.
4. Lock the database again when you finish.

Edits save directly to the database. There is no final document-level Save step. Cell edits support undo, but relocking clears that edit history. Keep a SQLite-aware backup when changing data that matters.

More than individual cells

Add and delete rows, copy cells, paste spreadsheet data, or import CSV into a table. You can create a table, inspect its structure, and use the Query view for SQL. SQLite constraints still apply; a spreadsheet-like interface does not remove primary keys, unique constraints or required values.

Editing also needs a row Petti can identify safely. Views, query results, generated columns and tables without a usable row identity are not equivalent to ordinary editable table cells. Opening a file with a writable connection does not make every displayed result editable.

Free viewing, licensed editing

The free app includes read-only browsing, search, filters, read-only queries and export. A Petti 1 license enables writing features and includes 1.x updates. See current pricing and license terms.

Use the owning application’s rules

Petti is useful for correcting development fixtures, inspecting local app data and making deliberate changes to your own SQLite tables. Direct edits can bypass application-level validation. For Django, Core Data or another app’s database, prefer that framework’s APIs for changes you expect the application to understand.

If another process is writing the same file, SQLite coordinates access, but you can still encounter database locked errors. Avoid modifying a live production database casually.