Skip to content

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.

The TablePro data grid on a Mac, with three edited prices in the products table waiting to be saved.

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.

The products table with four price edits waiting to be saved, and the Preview SQL sheet listing the matching UPDATE statements.

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

Pro

After 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.

The Data Rewind review in TablePro on a Mac, listing the values a save replaced, ready to restore.

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.