Browse and filter
The result grid is virtualized. Opens 50 million rows without hitches, scroll at 60 fps, inline editing.
How it opens
Any SELECT in the SQL editor → Run (⌘+Enter) → the result appears in the bottom panel under Grid.
Double-click a table in the schema tree on the right — opens a tab with SELECT * FROM ... LIMIT 100.
What you see
| Element |
What |
| Column headers |
Name + type in tooltip |
| Cells |
Values formatted by type |
| Footer |
Showing N of M, Load more button, query duration |
Tab Result |
This grid |
Tab JSON |
If the result has 1 jsonb column — pretty-printed JSON |
Tab Summary |
Stats: row count, duration, run time |
Sorting
Click a column header — sorts ascending. Second click — descending. Third — clears sort.
Sort applies to already loaded rows (client-side). To sort by index on the server — add ORDER BY to the SQL.
Filters
The ▼ icon next to a column name opens a filter.
Available:
- Empty values:
is null / is not null
- Text:
contains, equals, starts with, ends with, regex
- Numbers:
>, <, between, equals
- Dates:
between, before, after, today, last 7 days, custom range
- JSONB:
key exists, key equals (see JSON, JSONB and other types)
Multiple filters combine via AND. Clear filters in the grid header resets all.
Lazy loading
By default, ide99 shows the first page (1000 rows). At the bottom — Load more, adds another thousand. Page size is configurable in Settings → General → Result page size.
If the query returned few rows (≤ 1000) — the button doesn't appear.
Search in the grid
⌘+F with focus in the grid — opens a search bar. Finds in already loaded rows.
Selection and copy
- Click a cell — selects one.
- Shift + click — selects a range.
- ⌘ + click — selects multiple separate cells.
- ⌘+C — to clipboard. Format: TSV — pastes into Excel/Numbers/Sheets.
Export
The Export button in the grid header:
- CSV — with column headers and quoted strings
- JSON Lines (
.jsonl) — one row = one JSON object per line
- Markdown table — for issues or notebooks
- SQL INSERT — generates
INSERT INTO ... VALUES ... for seed files
All exports cover only what's loaded in the grid. For full export, run with a higher LIMIT or use logical backup.
Next