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

¶Toolbar

An icon toolbar sits above the grid: refresh, filter & sort (toggles the panel; shows a badge with the active-criteria count), add row, import CSV, export, and — when you have pending edits — revert and review & apply. The table name and loaded/estimate counts are shown on the right.

¶Column profile

Right-click a column header and choose Profile column… for instant stats: row / non-null / null counts, distinct count, min/max, and the most common values with mini bars.

¶Charts

Toggle the chart view (grid/chart buttons in the toolbar, or the Chart button under query results) to visualise the current rows. Pick a chart type (bar, line, area, pie), an X-axis / label column, and one or more numeric series. Charts render from the loaded rows — no query needed.

¶Filter & Sort

Click Filter & sort to open a panel where you can:

• Add multiple filter criteria — choose a column, an operator (=, ≠, <, ≤, >, ≥, contains, starts with, is null, not null) and a value. Filters combine with AND.
• Add multiple sort columns (ascending/descending). Sorting runs server-side (ORDER BY), so it covers the whole table — not just the loaded rows.

Click Apply filter & sort to reload the paged grid, or Clear to reset. You can also click a column header for a quick client-side sort of the loaded rows. (Filtering/sorting the grid is available on 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.

¶Column tools

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