Saved queries & history

#Save a query

Press ⌘ S in a new console, give the query a name, and it is saved under Saved Queries (⌘ 4). After that:

Saved queries are plain .sql files in ~/.tablegrip/queries/, folders included. You can edit them in another editor, share them, or keep the folder in git.

#Tie a query to a connection

Turn on Always run on <connection> when saving and the query opens on that connection from then on. TableGrip records this as a first line in the file:

-- connection: shop-production
SELECT count(*) FROM orders WHERE status = 'paid';

Without that line, a saved query opens on whichever connection is current.

#Parameters

Write :name or ${name} in a query and TableGrip asks for the values before running it:

SELECT *
FROM orders
WHERE status = :status
  AND created_at >= ${since};

• Values are inserted as written: type 'paid' (with quotes) for text and 42 for a number.
• Parameters inside strings and comments are ignored, and a::int is a PostgreSQL cast, not a parameter.
• The last values you used are offered again next time.

#Query history

Every statement you run is recorded in the Query History tool window, newest first, so you can find and re-open something you ran last week. Open it with ⌘ 2. History is stored in ~/.tablegrip/history.jsonl.