​

Data Grid

Query results and table data open in a spreadsheet-style grid. Sort and filter columns, edit cells inline, and copy in several formats.

​

View Modes

Switch between Data, Structure, and JSON in the status bar. Query tabs show Data and JSON only. The mode is remembered per tab. JSON mode shows the rows as a JSON array, with Text and Tree views. Select rows in Data mode first to limit what JSON shows, then use Copy JSON.

​

Columns

​

Sort

Click a header to cycle through ascending, descending, and off. Sort re-runs the query with ORDER BY appended, replacing any existing one. To sort on open, set Settings > Data Grid > Default row sort to Primary key or First column (default is No sorting). A click on any header still overrides it.

​

Filter by Value

Filter the loaded rows by picking values, without re-querying. Hover a header and click the funnel icon, or right-click the header and choose Filter Values…. The popover lists each value in the column with its count. Search to narrow the list, check the values to keep, and click Apply. NULL and empty values appear as their own entries. Return applies, Escape cancels. Filter several columns at once and the grid shows rows that match every filter. Clear from the header menu (Clear Value Filter, Clear All Value Filters) or check Select All in the popover.

​

Resize and Hide

Drag a column border to resize, or double-click it to fit the content. Widths are saved per table. Hide columns from the columns button in the status bar or the header menu. A hidden column isn’t fetched, so hiding a large column makes the table load faster. The primary key is always fetched, so editing still works.

​

Display Format

UUIDs and Unix timestamps render in a readable form when the column type and name match (for example a BINARY(16) column named uuid, or a BIGINT named created_at). Right-click a header and choose Display As to set the format per column. Toggle the automatic behavior in Settings > Editor > Smart value detection.

​

Editing

Double-click a cell to edit it. Press Enter to confirm or Escape to cancel. Some types open a dedicated editor:

​

Foreign Keys

Foreign key cells show an arrow on the right edge. Click it to open the referenced table filtered to the matching row; Cmd-click opens a new tab. Right-click for Preview Referenced Row, which shows the row in a popover.

​

Add, Delete, and Fill

• Add a row: click + in the status bar.
• Delete rows: select rows by their row number (Shift-click for a range, Cmd-click for separate rows) and press Delete.
• Fill a column: right-click a header and choose Fill Column to set one value across all loaded rows. It skips primary key columns.

​

Saving Changes

Edits are queued, not applied right away. The toolbar shows the pending count, modified cells are highlighted, and new and deleted rows are marked.

• Preview SQL (Cmd+Shift+P): review the statements before applying.
• Commit (Cmd+S): apply all pending changes.
• Discard: drop all pending changes.
• Undo / Redo (Cmd+Z / Cmd+Shift+Z): step through edits before committing.

See Change Tracking for details.

​

Cell Inspector

Toggle the inspector with Cmd+Shift+B. With a row selected, it lists every column value with a full editor for long text and JSON. With no row selected, it shows table metadata: row count, size, engine, charset, and collation.

​

Select and Copy

Click a cell to select it, drag or Shift-click for a range, and click row numbers for whole rows.

• Cmd+C: the focused cell, or the selected rows as TSV.
• Cmd+Shift+C: the selected rows as TSV.
• Cmd+Option+J: the selected rows as JSON.

Right-click a row and choose Copy as for more formats: Copies follow the grid as shown: hidden columns are left out and columns keep their current order. Copy as UPDATE always includes the primary key. Right-click a header and choose Copy Column Values to copy a whole column, one value per line.

​

Pagination and Limits

Table tabs page through data. The status bar has a rows-per-page menu (5 to 1,000, a custom size, or All rows) and First / Previous / Next / Last controls. Set the default in Settings > Editor. Smaller pages load faster. Query tabs cap results at 10,000 rows by default to stay responsive. When the cap applies, the status bar shows Fetch All to load the rest (with a confirmation, since large results use a lot of memory). Your own LIMIT and OFFSET are passed through unchanged. Adjust the cap in Settings > Editor (Truncate query results, Row cap). Press Cmd+. to cancel a running query or a Fetch All.

​

Display Settings

NULL shows as styled NULL text. Set the NULL display, date format, row height, and alternate row colors in Settings > Editor.

​

MongoDB Collections

MongoDB has no fixed schema, so TablePro infers columns by sampling up to 500 documents. Missing fields show as NULL, and the _id column is read-only (delete and re-insert to change it). BSON values display as ObjectId("..."), ISO 8601 dates, BinData(...), decimal strings, and DBRef(...). Changes preview as shell commands: insertMany, updateOne with $set, and deleteMany.