Saved Queries
Save, name, and organize SQL queries in tpaw for reuse across sessions.
Saved Queries stores named SQL queries that persist across sessions. Save a query once, give it a descriptive name, and open it instantly from the sidebar or command palette. Saved queries can also be starred to appear in Favorites.
Saving a query
From the Query Editor, click the Saved button in the toolbar to open the save panel. A panel slides open on the right:
- Enter a name for the query (required)
- Optionally add a description with notes about what it does
- Press Enter or click Save
The query is saved and appears in the Saved Queries panel.
Opening a saved query
From the sidebar: Click the Saved icon to open the Saved Queries panel. Click any query to open it in the Query Editor. The tab title shows the query name with "Saved Query" as the subtitle.
From Favorites: Star a saved query to pin it. Starred queries appear in the Favorites panel for even faster access.
From the command palette (Cmd+K): Type the query name to jump to it instantly.
Managing saved queries
Search and sort
The Saved Queries panel has a search bar (filters by name and SQL content) and sort options:
- Recent — most recently saved or used first
- Name — alphabetical order
Editing a saved query
Open the saved query in the Query Editor, modify the SQL, and click the Saved button again. The existing saved query is updated.
Deleting a saved query
In the Saved Queries panel, hover over a query and click the trash icon that appears. The query is permanently deleted.
Starring a saved query
Click the star icon next to any saved query to add it to Favorites. Click again to unstar.
Saved queries per connection
Saved queries are stored per connection. Each database connection has its own independent list of saved queries.
Keyboard shortcut
| Action | Shortcut |
|---|---|
| Open command palette to find saved query | Cmd+K |