¶Data Grid & Editing

Double-click a table to open it in the data grid — a virtualized, server-paged view that stays smooth on very large tables.

!Data grid

¶Browsing large tables

• Virtualized rendering draws only the visible rows.
• Server-side keyset pagination loads pages as you scroll (falling back to offset paging when a table has no single-column primary key).
• The header shows the loaded count and the total estimate.

¶Filters

Click Filter to add no-SQL conditions: choose a column, an operator (=, ≠, <, ≤, >, ≥, contains, starts with, is null, not null) and a value. Filters combine with AND and reload the paged grid. (Pro)

¶Foreign-key lookup

Cells in a foreign-key column show a ↗ button that opens the referenced table filtered to the matching row. (Pro)

¶Inline editing

On writable connections (Pro/Premium):

• Double-click a cell to edit; use ∅ to set NULL.
• Delete a row with the row's ✕ (toggles a strikethrough); Add row inserts a new row at the top.
• Changes are buffered and highlighted (edited = blue, deleted = red, new = green). The bar shows the pending count.
• Review & apply shows the exact INSERT/UPDATE/DELETE SQL, which runs in a single transaction. Revert discards the buffer.

!!! warning "Primary key required" Editing and deleting require a single-column primary key so rows can be targeted safely.

¶Column tools

Right-click a column header to copy the column as a list or as an IN (…) clause.