Data Settings

Browsing a table pages 1,000 rows at a time, and a query that returns more than 10,000 rows stops there. Both numbers, and the rest of what the grid does before you touch anything, are on Settings > Data. The tab is app-wide, so these values apply to every connection you open; filters, column widths, and the sort you clicked are remembered per table instead. Grid fonts are per-theme, on the theme’s Fonts tab under Appearance.

Data Grid

Setting	Default	Notes
Row height	Normal	Compact, Normal, Comfortable, Spacious
Date format	ISO 8601	ISO 8601, ISO Date, US Long, US Short, EU Long, EU Short
NULL display	`NULL`	Text shown for NULL cells, up to 20 characters
Show alternate row backgrounds	On
Show row numbers	On
Auto-show inspector on row select	Off	Opens the row details inspector when you select a row
Smart value detection	On	Renders UUID, Unix timestamp, JSON, and PHP serialized columns in readable form. Override per column with Display As, see Data Grid
Default row sort	No sorting (engine order)	Or Primary key, First column. Applied when a table first opens; clicking a column header overrides it

Pagination

Setting	Default	Options
Default page size	1,000 rows	100, 500, 1,000, 5,000, 10,000
Count rows if estimate less than	100,000	1,000; 10,000; 100,000; 1,000,000; Always count

Tables with more estimated rows than the threshold show an approximate count instead of running a slow COUNT(*).

Query result row cap

Setting	Default	Options
Truncate query results	On
Row cap	10,000	100; 1,000; 5,000; 10,000; 50,000; 100,000; 500,000

The cap limits the rows read back, not the statement: your SQL reaches the server exactly as you typed it, and a query carrying its own LIMIT is untouched. What a capped result offers instead is in Query Results.

JSON Viewer

Setting	Default	Options
Default view	Text	Text, Tree

Switching modes inside the viewer writes the choice back to this setting. See JSON Viewer.

Query History

Setting	Default	Description
Maximum entries	10,000	100 to 10,000, or Unlimited
Keep entries for	90 days	7 days to 1 year, or Forever
Auto cleanup	On	Applies the two limits in this table. Turn it off and nothing is pruned.
Clear History…	-	Wipe all history, for every connection, after confirmation

To clear only what you are looking at, use the trash button in the history drawer instead: it respects the drawer’s connection scope and date range.

⌘I

Start here

Connections

Databases

Write SQL

Browse and edit data

Schema and server

Import and export

AI

Around the app

Sync and licensing

Customization

iPhone and iPad

Security and privacy

Data Grid

Query result row cap

JSON Viewer

Query History

​Data Grid

​Pagination

​Query result row cap

​JSON Viewer

​Query History

Data Grid

Pagination

Query result row cap

JSON Viewer

Query History