Data grid
Double-click a table in the sidebar to open its data, or right-click it and choose Open Data. Query results use the same grid.
Editing
Press Enter or F2 on a cell to edit it, Esc to cancel. Tab moves to the next cell, the arrow keys move around, and Shift+click selects a range.
Edits are collected and applied when you press Ctrl+S or click Save. Discard throws them away. The toolbar shows how many unsaved changes are pending, and NabuSQL asks for confirmation before you page away from them.
Delete sets a cell to NULL. To remove rows, select them and use Delete row from the right-click menu.
Tables without a primary key
If the table has no primary key the grid shows Table has no primary key. Without one there is no reliable way to address a single row, so edit such tables with care — or add a key first in Tables and columns.
Filtering and sorting
- Filter opens a condition builder. Click ＋ Add condition, pick a column, an operator and a value, then apply. Conditions combine, and Clear removes them.
- You can also type a raw expression, e.g.
age > 18 AND name LIKE 'A%'. - Click a column header to sort; the column menu offers ascending, descending and clear.
- Columns controls which columns are visible; Show all brings them back.
- The search box filters the loaded rows.
Paging
The bottom bar sets rows per page and jumps to a page number — type a value and press Enter. With unsaved edits pending, changing either asks for confirmation first.
Copying data out
Right-click a cell or a selection:
| Entry | Result |
|---|---|
| Copy row | The row as text (Ctrl+C) |
| Copy as ▸ INSERT statement | A ready INSERT for the selected rows |
| Copy as ▸ INSERT statement (without PK) | Same, minus the primary key — for copying rows into another table |
| Copy as ▸ UPDATE statement | An UPDATE keyed on the primary key |
| Copy as ▸ Tab separated values | TSV, ready for a spreadsheet |
| Copy as ▸ Field names + tab separated | TSV with a header row |
| Copy cell value | Just that one cell |
Select several rows first and every Copy as entry applies to all of them.
Adding and pasting rows
- Insert row above / Insert row below create an empty row at that position.
- New Row in the toolbar appends one.
- Paste (
Ctrl+V) writes clipboard content into the selected cells. - After copying a row, Insert copied row as new adds it as another row, while Paste row into this row overwrites the row you clicked.
Column operations
The column header menu can sort, copy the whole column's data, copy the column name, and set every visible cell in the column to an empty string or to NULL. Both bulk operations ask for confirmation and name the column.
Cell viewer
The cell viewer panel shows the full content of the selected cell — useful for long text, JSON blobs and anything else that a grid cell truncates.