Filtering
Press Cmd+F to open the filter panel. Type a raw SQL WHERE clause and press Enter to filter. Raw SQL is the default mode.
Each row has a column picker, operator, value field, and +/− buttons. Multiple rows combine with AND or OR (toggle in the header). Click Apply or press Enter to activate. Click Unset to clear all.
Filters are per-tab. Tables with active filters open in a new tab when you click another table.
Operators
18 operators: =, !=, contains, not contains, starts with, ends with, >, >=, <, <=, IS NULL, IS NOT NULL, IS EMPTY, IS NOT EMPTY, IN, NOT IN, BETWEEN, REGEX.
BETWEEN shows two value fields. IN/NOT IN takes comma-separated values.
Raw SQL
The default mode. Type any WHERE condition directly:
created_at > NOW() - INTERVAL 7 DAY
Raw SQL is injected directly into the WHERE clause. Ensure syntax matches your database type.
Presets
Save and load filter configurations via the ⋯ menu in the header.
| Action | How |
|---|
| Save | ⋯ > Save as Preset… |
| Load | ⋯ > click preset name |
| Delete | ⋯ > Delete Preset > click name |
SQL Preview
⋯ > Preview Query shows the generated WHERE clause with a copy button.
Settings
⋯ > Filter Settings to configure:
| Setting | Options |
|---|
| Default Column | Raw SQL, Primary Key, Any Column |
| Default Operator | Equal, Contains |
| Panel State | Always Hide, Always Show, Restore Last Filter |
