DBX

The data grid displays query results and table data. It is designed for two common workflows: inspecting data quickly and making small, reviewable edits.

Browse Data

DBX uses virtual scrolling, rendering only the rows visible on screen. Large tables remain responsive because the grid does not render every row at once.

Common browsing actions:

Drag column borders to resize columns
Double-click a column border to auto-fit width
Click column headers to sort
Use row numbers to locate records
Open cell details for long text, JSON, or other complex values

Filter and Sort

Feature	Best For
Search	Finding rows in the current result set
WHERE	Database-level filtering for large tables or precise conditions
ORDER BY	Database-level ordering for reproducible results

For large tables, prefer WHERE and ORDER BY. They run in the database and are usually more reliable than client-side search.

Inline Editing

You can edit data directly in the grid:

Update a cell: double-click a cell and edit its value
Insert a row: add a pending row in the grid
Delete rows: select rows and mark them for deletion
Set NULL: explicitly write NULL from the cell detail panel

All changes are staged locally first. Before saving, DBX shows the SQL it is about to execute.

Editing is available when DBX can identify the target table and enough key information to generate reviewable UPDATE, INSERT, or DELETE statements. Simple table browsing is usually editable. Ad-hoc joins, aggregates, expressions, or result sets without usable keys are treated as read-only.

Result Type	Typical Behavior
Opened table data	Editable when the database and table support edits
Simple `SELECT * FROM table`	Often editable if primary key or row identity is available
Joins, aggregates, computed columns	Read-only result set
Redis or MongoDB views	Use their dedicated editors instead of relational row SQL

SQL Preview

Edits are not written to the database immediately. Before saving, review the SQL preview carefully, especially on production connections.

The preview shows UPDATE, INSERT, or DELETE statements. Use it to confirm:

Update conditions target the intended rows
Inserted rows contain the expected fields
Delete operations match the expected records
NULL, empty strings, and default values are handled correctly

If the preview looks too broad, cancel the save and narrow the filter or selection first.

Cell Details

Click a cell to open the detail panel. It is useful for values that are awkward to edit directly inside a table:

Long text
JSON
SQL fragments
Multi-line content
Fields that should be explicitly set to NULL

Export and Copy

Format	Use Case
CSV	Excel, Numbers, or spreadsheet tools
JSON	Scripts, API debugging, or programmatic processing
Markdown	Issues, PRs, documentation, or chat
INSERT	Copy selected rows as executable `INSERT` statements

Before exporting, check the active filters and sort order so the exported data matches what you expect.

Pagination And Large Results

DBX can page result sets and keep large grids responsive with virtual scrolling. For large tables, prefer database-side WHERE and ORDER BY clauses instead of relying only on client search, because the database can use indexes and return a smaller result set.

Data Grid