Browse and find rows
The Data tab shows the contents of a table and lets you narrow them down with conditions you pick from lists.
Pick a table
The list on the left shows every table in the database. For MongoDB it shows collections, and for LMDB it shows sub-databases.
Type part of a name in the filter box above the list to shorten it.
Select a table. Its rows load in the grid and the Data tab comes to the front.
If you created or dropped a table elsewhere, select the refresh button in the title bar to reload the list.
Read the grid
The toolbar above the grid shows the table name and its total row count, for example orders · 1532 rows.
- The grid shows 100 rows at a time. Use the arrow buttons, Previous page and Next page. The numbers between them, such as
101–200, tell you which rows you are looking at. - Empty database values are shown as
NULLin grey italics. - Long text is cut to 200 characters in the grid, and line breaks are shown as
⏎. Open the row to see the full value. - Binary data is shown as
0xfollowed by hexadecimal digits. - The refresh button at the right of the toolbar reloads the page and the row count.
Find rows without writing a query
Select the funnel button in the toolbar (Find rows without writing a query).
Select Add a condition (e.g. "name contains john").
Choose a column, choose a comparison, and type a value.
To narrow the search further, select Add another condition. A row must match every condition.
To sort the result, pick a column in the Sort by list. The arrow next to it switches between Smallest first and Largest first.
Select Find rows, or press Enter in a value box.
The toolbar adds (filtered) after the row count, and the funnel button shows the number of conditions.
To remove one condition, select the cross at the end of its row and then Find rows. To remove everything, select Clear. Selecting another table also clears the search.
The comparisons
| Comparison | Matches rows where the column |
|---|---|
| is | Equals the value |
| is not | Does not equal the value |
| contains | Has the value somewhere inside it |
| starts with | Begins with the value |
| is more than | Is greater than the value |
| is less than | Is smaller than the value |
| is at least | Is greater than or equal to the value |
| is at most | Is smaller than or equal to the value |
| is empty | Has no value, or holds empty text |
| is not empty | Has a value |
is empty and is not empty need no value, so the value box disappears.
A value that looks like a number is compared as a number. Anything else is compared as text.
See and reuse the query
The panel can show the query it runs, which is a good way to learn SQL.
Select Show the query this runs at the bottom of the panel.
Select the copy icon (Copy query) to put it on the clipboard.
Or select the arrow icon (Open in Query tab to customize). The query is placed in the Query tab, ready to edit and run.
For SQL databases the query is a SELECT statement. For MongoDB it is a find command in JSON.
Differences between databases
- MongoDB: the columns are the fields found in the documents on the current page, with
_idfirst. Documents that lack a field showNULLfor it. Nested values are shown as JSON text. contains and starts with ignore upper and lower case. - LMDB: every sub-database has two columns,
keyandvalue. Conditions are checked against the text shown in the grid.