Data Grid
Browse, edit, filter, sort, and import data in tpaw's virtualized spreadsheet-style Data Grid.
The Data Grid is tpaw's primary interface for viewing and editing table data. It loads table rows in a virtualized scrollable grid, supports inline cell editing, filtering, sorting, row insertion/deletion, JSON expansion, and CSV import. Open any table from the sidebar to start working with its data.
Navigating the grid
The grid loads 500 rows per page and virtualizes rendering for performance. Use the pagination controls at the bottom to move between pages.
| Action | How |
|---|---|
| Select a cell | Click |
| Navigate cells | Arrow keys |
| Select a row | Click row number |
| Expand a cell (JSON/long text) | Double-click or right-click → Expand |
| Open row detail panel | Right-click → Open Row Detail |
Row density
Choose between three row height modes with the density button in the toolbar:
- Compact — 30px rows, maximum data density
- Comfortable — 42px rows
- Spacious — 54px rows, easier reading (default)
Column operations
Resize: Drag the column header divider to resize.
Sort: Click a column header to sort ascending. Click again to sort descending. Click a third time to remove the sort.
Sort popover: Click the sort icon in the toolbar to set multi-column sort order with explicit ASC/DESC.
Read-only mode
The grid has a lock toggle in the toolbar. When locked (read-only mode), cell edits are disabled and no mutation dialogs appear. Unlock by clicking the lock icon (Cmd+L). Connections marked as Safe Mode (read-only) in the connection form are always locked.
Keyboard shortcuts in the grid
| Shortcut | Action |
|---|---|
Cmd+L | Toggle edit mode (lock/unlock) |
Cmd+I | Open insert row modal |
Cmd+D | Duplicate selected row |
Cmd+F | Open filter popover |
Cmd+R | Refresh table data |
What's in this section
- Inline Editing — Edit cells, insert rows, and delete rows
- Filtering — Filter rows by column values and operators
- CSV Import — Import CSV files into a table