Result Table and Data Grid

The Result Table is Tablen's data grid for viewing, editing, and analyzing query results. It provides a spreadsheet-like interface with inline editing, sorting, filtering, and cell-level operations.

Data Grid Features

Column Display

• Columns are auto-sized based on content
• Manually resize columns by dragging column borders
• Column widths are persisted per result set

Row Numbers

• Row numbers are displayed in the first column
• Toggle in Settings > Appearance > Show Row Numbers

Alternating Row Colors

• Alternating row colors improve readability
• Toggle in Settings > Appearance > Alternating Row Colors

Hover Highlighting

• Rows are highlighted on mouse hover for easy tracking

Sorting

Click a column header to sort by that column:

• First click: Sort ascending
• Second click: Sort descending
• Third click: Remove sort
• Sort indicator (arrow) shows the current sort direction

Cell Selection

Single Cell Selection

Click any cell to select it.

Multi-Cell Selection

• Click + drag: Select a range of cells
• Shift+Click: Select a range from the last clicked cell to the current cell
• Cmd+Click: Add or remove individual cells from the selection

Row Selection

• Click the row number to select an entire row
• Shift+Click: Select a range of rows
• Multiple row selection is supported

Aggregate View

When multiple cells are selected, the status bar shows aggregate values:

• Count: Number of selected non-null values
• Sum: Sum of numeric values
• Average: Mean of numeric values
• Min: Minimum numeric value
• Max: Maximum numeric value

Inline Editing

Edit data directly in the result table:

1. Double-click a cell to enter edit mode
2. Modify the value
3. Press Enter to confirm or Escape to cancel
4. The cell shows a change indicator (highlighted background)
5. Press Cmd+S to commit all pending changes

Code Review Mode

When enabled (Settings > General > Safety):

• Pressing Cmd+S shows a preview of the SQL that will be executed
• Review INSERT, UPDATE, or DELETE statements before they run
• Approve or cancel the changes

Undo Cell Change

• Shortcut: Cmd+Z
• Reverts the last uncommitted cell change
• Only works for changes that haven't been committed yet

Pending Changes

• Modified cells are visually highlighted
• The number of pending changes is shown in the toolbar
• Changes are tracked as CellChange objects with old and new values

Row Deletion

Delete rows from the database:

1. Select one or more rows
2. Right-click and select "Delete Rows"
3. Confirm the deletion (subject to Safe Mode if enabled)
4. Uses primary key values to identify rows for deletion

Quick Filter Bar

Filter results without writing SQL:

• Shortcut: Cmd+Option+F
• A filter bar appears above the result table
• Type a filter expression to narrow down visible rows
• Filters are applied client-side on the current result set

Column Filters

Filter individual columns:

• Click the filter icon in a column header
• Enter a filter value
• Multiple column filters can be active simultaneously
• Column filters work together (AND logic)

Result Tab Bar

Multiple result views are available through the result tab bar:

• Data Grid: The default tabular view
• JSON Tree: View results as an expandable JSON tree
• Chart: Visualize results as charts
• Snapshots: Access saved result snapshots

JSON Tree View

View query results as structured JSON:

• Expandable/collapsible tree structure
• Useful for JSON columns or complex nested data
• Supports deep nesting with indentation

Chart Visualization

Visualize query results as charts:

Chart Types

Charts are built using SwiftUI Charts framework and automatically adapt to your data.

Snapshots

Save result snapshots for later comparison:

1. After running a query, click "Save Snapshot" in the result toolbar
2. Enter a name for the snapshot (via the Snapshot Name Sheet)
3. Snapshots are saved and can be accessed from Settings > Snapshots
4. Compare current results with previous snapshots

Export from Results

Export the current result set:

• CSV: Comma-separated values
• JSON: JSON array format
• SQL: INSERT statements

Export is available from the result toolbar. Export capability may be restricted based on your license plan and user role.

Data Masking

For Team plan users, sensitive data can be masked:

• Masking rules are configured by the team administrator
• Supported masking types: email, phone, credit card, and more
• Masked values are displayed in place of actual data based on user role
• Masking is applied at the display level

Foreign Key Navigation

Navigate between related tables using foreign keys:

• FK columns show a navigation indicator
• Click an FK cell value to jump to the referenced table and row
• The related record opens in a new tab or replaces the current view

Redis Key Browser

For Redis connections, a specialized Key Browser view is available:

• Browse keys by pattern
• View key types and values
• Supports string, list, set, hash, and sorted set key types

Keyboard Shortcuts