Data Grid & Table View
The Data Grid appears whenever you run a SELECT query or open a table from the Schema Explorer. It's a fast, read-optimized view of your results.
Features
Sorting
Click any column header to sort ascending. Click again for descending. Hold Shift and click a second header to add a secondary sort.
Column Resizing
Drag column borders to resize. Double-click a border to auto-fit the column to its content.
Filtering
A filter bar above the grid lets you type a string to filter visible rows client-side. This works on data already loaded — it doesn't re-run the query.
For server-side filtering, add a WHERE clause in the SQL editor.
Copying Data
Right-click a selection to copy as:
- CSV — comma-separated, with headers
- JSON — array of row objects
- SQL INSERT — ready-to-paste insert statements
- Plain text — tab-separated
Pagination
By default, queries return up to 1000 rows. Pagination controls at the bottom let you load the next page. The row count is shown in the toolbar.
On Production environments (Pro), queries that return more than 500 rows show a warning banner. This is intentional — large scans on production can degrade performance.
Table View
Opening a table from the Schema Explorer is equivalent to running SELECT * FROM table_name LIMIT 1000. The Data Grid shows the result, and you can filter, sort, and copy data as usual.
Table View does not support in-grid editing. To modify data, write an UPDATE or INSERT statement in the SQL editor.
Exporting
The Export button in the grid toolbar lets you export the full result set (not just the visible page) to:
- CSV
- JSON
Large exports run in the background and notify you when complete.
NULL Values
NULL values are displayed as a distinct NULL badge (not empty string) so they're unambiguous.
Timestamps
All timestamps are displayed in your local timezone. The raw UTC value is shown in a tooltip on hover.