Save queries you run often as favorites. Organize them in folders, assign keyword shortcuts, and insert them from the sidebar or type a keyword to expand via autocomplete.Right-click in the editor or Query History and pick Save as Favorite, or click + New Favorite in the Favorites sidebar. Enter a name, optional autocomplete keyword, SQL, and scope (global or per-connection).Switch to the Favorites tab to browse saved queries. Organize with folders (right-click to manage). Double-click a favorite to insert it, or right-click to edit, copy, run, move, or delete. Assign a unique keyword to expand as an autocomplete suggestion. Global favorites visible in all connections; connection-scoped only in that connection.
Favorites live in a SQLite database (sql_favorites.db) in ~/Library/Application Support/TablePro/, separate from query history. Search uses FTS5 full-text indexing on name, keyword, and query text.
