Query history
Every executed query is saved into a local history — search, filter, re-run, export.
Open
⌘+H opens a separate History tab.
What's saved
| Field |
Meaning |
Query |
Full SQL text |
Connection |
Connection label (no password or host, just the label) |
When |
Run time |
Duration |
How long it took |
Rows |
Returned (or affected) |
Status |
OK / Error / Cancelled |
Tags |
Auto-tags: read, write, ddl, slow |
Search and filters
A search bar at the top — searches by query text. Full-text, not regex. Filters on the right:
- Connection — all or a specific one
- Status — OK / Error / Cancelled
- Date — day / week / month / all
- Type — read / write / ddl
- Slow only — duration ≥ 1 second
All filters compose — e.g., "all error queries from the last 7 days against the prod connection".
Re-running
| Action |
What it does |
| Double-click on a query |
Opens a new editor tab with that SQL |
| Run again button |
Executes against the current connection (not the original — careful) |
| Right-click → Copy SQL |
To clipboard |
| Right-click → Pin |
Pins the query to the top of the list |
What's not saved
- Result contents (rows). Just count.
- Passwords and parameter values
$1, $2, ... — parameterized queries are stored verbatim, without bind values.
- Queries on connections with Exclude from history enabled (see Create a connection). Good practice for prod with PII.
Where it lives
history.db (SQLite) next to the profile:
| OS |
Path |
| macOS |
~/Library/Application Support/ide99/history.db |
| Windows |
%APPDATA%\ide99\history.db |
| Linux |
~/.config/ide99/history.db |
The DB is local, never sent anywhere. Wipe via Settings → Privacy → Clear all local data.
Limit
By default, the last 10,000 queries per connection are kept. Older ones drop automatically. The limit lives in Settings → General → History limit.
Export
The Export button in the tab header saves the current filtered list as .csv or .jsonl. Useful for "what did I do this week" reports or for incident analysis.
Next