Skip to main content

​
Query History

Every query you execute is automatically saved to a local SQLite database. Search with full-text search, filter by connection or time range, and re-run past queries. History persists across sessions.
Query History
Click View > Query History, press Cmd+Y, or click the History icon in the toolbar. Recent queries also appear in the sidebar. The history panel shows your executed queries with execution time, status, and database. Sort by time (most recent first), duration, or query text. Filter by connection, status (success/error), or time range (today, week, month, all time).
History panel with filter controls

​
Searching History

​
Full-Text Search

Type in the search box to find queries containing specific text: 
SELECT users  -- Find all queries containing "SELECT" and "users"
History search

​
Using History

​
Re-running Queries

Double-click a query to load it into the editor, then press Cmd+Enter. Or right-click > Run Query.

​
Copying Queries

Select a query and press Cmd+C, or right-click > Copy Query.
Query history context menu

​
Editing Before Running

Double-click to load into the editor, modify, and execute. The original history entry is preserved.

​
Query Details

​
Viewing Full Query

For long queries, click to expand and see the full text:
Query detail
Failed queries show the error message, the query that failed, and the timestamp. Load a failed query into the editor to fix and re-run.
Failed query entry with error message

​
Storage

Query history is stored in ~/Library/Application Support/TablePro/query_history.db (a local SQLite database with FTS5 full-text search). Configure retention in Settings > History:
SettingDefaultDescription
Max Entries10,000Maximum queries to store
Max Days90Delete queries older than this
Auto CleanupOnAutomatically remove old entries
To clear all history, open Settings > History and click Clear All History. For a specific connection, right-click it in the sidebar and select Clear History.