Settings
Open with ⌘ , or the gear in the connection bar.
Appearance
| Setting | Default |
|---|---|
| Language: System, English, Português | System (Portuguese when macOS prefers it, otherwise English) |
| Theme: Violet, Ocean, Sunset, Forest, Graphite | Violet |
| Editor font size (10 to 22 pt) | 13 pt |
| Auto-format query when run | Off |
Lily always uses a dark appearance; the theme changes its accent colors.
AI
Providers, their order and the test button, Grounding › Focus AI on the tables relevant to each request, and Re-detect installed CLIs. See Setting up AI.
Workspace
| Setting | Default |
|---|---|
| iCloud sync | Off |
| Reopen last connections on launch | On |
| Remember Trace history on disk | Off |
| Alert me while Trace is recording | Off |
| ↳ Alert on queries slower than (5 to 600 s) | 30 s |
| ↳ Alert when a query blocks another | On |
| ↳ Keep recording while Lily is in the background | Off |
See Trace.
Data & queries
| Setting | Default |
|---|---|
| Rows to load per table (50 to 10,000) | 500 |
| Query result cap (1,000 to 500,000 rows) | 50,000 |
| Query timeout (0 to 600 s, 0 is off) | 30 s |
| Preview SQL before committing edits | On |
Also here: how many queries the history holds, with Clear history, and how many plans are saved, with Clear plans.
Sharing
Everything here is off by default. See Privacy.
Query library
Favorites (your saved queries, with folders) and Snippets (your own triggers). See History and Query Library and snippets.
About
The version, Send Feedback…, What's New, Replay onboarding, and Updates: Automatically check for updates, Download updates automatically and Check Now.