Data editing
Filter rows, follow foreign keys and edit in the grid. Nothing is written until you save, and you can read the SQL first.


Find the rows you need
Sorting and paging run on the server, so a large table opens at its first page. Filter with 18 operators or a SQL condition, save the filters you reuse, and color matching rows or cells with highlight rules.
Follow a foreign key to its row or preview it in place, and open JSON values in a tree.
Saved filters and highlight rules stay on the Mac where you made them.
Review edits before saving
Edits, new rows and deletions wait in the tab until you press ⌘S. Preview SQL shows the statements first, undo works until you save, and the save checks affected row counts, in a transaction where the engine has one.
Each type gets its editor: dates, ENUM and SET lists, arrays, JSON, hex for binary values, and images.
On Linux and on iPhone and iPad, a row needs a primary key to be edited. A join, CTE or UNION result is read-only everywhere.


Safe Mode
Give each connection a level. The default, Silent, runs statements without asking; Alert confirms writes, Safe Mode adds Touch ID or your password, the Full levels confirm reads too, and Read-Only blocks writes. DROP, TRUNCATE and DELETE without WHERE always ask. Safe Mode is free.
Linux offers Off, Confirm Writes and Read-Only. iPhone and iPad offer Off, Confirm Writes and Read-Only.
Data Rewind
ProAfter a save, Restore Previous Values brings back what it replaced. The review flags rows that changed since, and the restore follows Safe Mode, in one transaction where the engine allows. Previous values stay encrypted on this Mac for 7 days and never sync.
It is not a backup: triggers, cascades and changes made outside TablePro are not undone.


Also
Documents and keys
Edit MongoDB documents as Extended JSON, and Redis strings, key names and TTLs in the grid.
Copy rows
Copy rows as CSV, JSON, Markdown, an IN list, or INSERT and UPDATE statements.
On iPhone and iPad
Rows show as cards you can sort, filter and edit. Editing and deleting need a primary key.
Get TablePro
Pro adds Data Rewind. Everything else on this page is free.