AI agents for Grist

List workspaces and documents

Lists the site's workspaces with their documents, to find a document's ID.

List tables

Lists a document's tables.

List columns

Lists a table's columns.

Fetch records

Fetches records of a table, optionally only those whose columns hold one of the given values, sorted and limited.

Run SQL

Runs one read-only SQLite SELECT (WITH allowed, no closing semicolon) over a document, whose tables are named by their table IDs, like SELECT Name, Total FROM Orders WHERE Total > ?

Add records

Adds records to a table.

Update records

Changes some columns of records by row ID; columns left out keep their values.

Add or update records

For each entry, finds the record whose columns match require (like {"Email": "ada@example.com"}) and sets fields on it, or adds a record with both when none matches.

Delete recordsDeletes data

Deletes records by row ID, for good (the document's history keeps them).