HomeFeaturesPluginsDocsDownload

Browsing tables

Double-click a table in the tree to open a Browse tab — page through its rows without writing a line of SQL.

Paging

Browse mode fetches one page at a time, server-side, so opening a huge table doesn't pull the whole thing into memory. Use the Previous / Next controls to move between pages; the page size defaults to 200 rows and is configurable (Browse page size) in Settings. Elasticsearch uses cursor-based paging under the hood; the other engines use LIMIT/OFFSET-style paging.

Paging is a Browse-mode feature. Results from a query you type in the editor are returned in full, not paged.

Sorting

Click a column header to sort: it cycles unsorted → ascending → descending. Sorting is applied as a server-side ORDER BY and re-queries from the first page, so it orders the whole table — not just the rows currently on screen.

Filtering

Each column has an inline filter box (a case-insensitive LIKE match), and there's a free-text WHERE box for anything more complex. Filters combine into the query's WHERE clause and, like sorting, run server-side.

Editing while browsing

Browse grids are editable with the same reviewable save flow as query results — edit cells, add or delete rows, then save. See Editing data for how that works and when a grid is read-only.