Workspace
Table grid
Read-only virtual tables for SQL results, table viewers, and Mongo documents — pagination, filters, sort, and export.
Data viewers, query results, and Mongo document lists share the same grid. It is a virtualized table: large result sets stay scrollable without mounting every row. Cells render as formatted strings from the engine.
Where it appears
- Open Data on a table, view, or collection — a tab keyed by connection + object (opening the same object focuses the existing tab).
- Query results under the SQL / pipeline editor.
- Mongo documents from
find()on a collection.
Pagination
SQL viewers fetch a page at a time. Page size comes from Settings → Query defaults (default 500, range 50–5000). Prev / next move through pages.
Mongo document viewer is not paged the same way: it runs find()
with a fixed limit of 200 documents.
Filters
The filter bar picks a column, an operator, and a value, then applies a
server-side predicate (SQL WHERE or a Mongo filter). Apply and
Clear sit on the bar.
| Operator | SQL (Postgres) | SQL (SQLite) |
|---|---|---|
| = | equality | equality |
| ≠ | not equal | not equal |
| contains | ILIKE '%value%' | LIKE (case-insensitive via lowercasing) |
| > / < | comparison | comparison |
| is null / is not null | no value field | no value field |
Identifiers are quoted. Values are escaped as SQL string literals. Mongo uses the same operators as a JSON predicate on the selected field.
Sorting and columns
Header click sorts the current page in the client. It does
not add ORDER BY to the query. Column resize, reorder, row
select, cell select, and wrap-around keyboard selection are all toggles in
Settings → Query defaults → Table interaction.
Zebra striping and row size live under Settings → Appearance → Tables. SQLite read-only connections show a read-only badge in the viewer footer.
Export
CSV and XLSX export from a popover on data viewers and query result grids. Export uses the rows currently loaded in the grid, not the unfetched rest of the table.