Airtable

Spreadsheet-style databases. Read, search, add, and update records, and manage the tables, fields, and views that hold them.

Measured routing accuracy

42 golden cases replayed through the router over the whole index: measured over corpus ea4f12ad2948 (65 toolkits, 2283 tools indexed and 13 declared uncallable), 28 cases written by hand and 14 cases from the paraphrase pass. A case counts as top-1 when its gold tool ranked first and top-8 when it reached the slate at all.

The sweep is offline: the reranker is a deterministic identity fake that returns candidates in the order retrieval produced them, so top-1 measures retrieval order rather than a reranked slate. just eval-live measures the same cases through the live reranker.

Authentication

Connect an entity with ConnectionsService.InitiateConnection, naming this toolkit's slug. Credentials stay in the connections vault; callers hold connected-account ids only.

oauth2

api_key

Submit the key with ConnectionsService rather than putting it in a request; it is sealed at rest and never returned.

Tools

28 action tools. The catalog-wide slug is airtable.<tool>, which is what search_tools returns and call_tool takes.

airtable.get_current_user

Get the identity the connected Airtable token is authenticated as: its user id, email, and granted scopes. Use to check which account or integration a connection is running as, not to look up a collaborator.

Class read (reads only). No scopes beyond the connection's defaults. Calls GET /v0/meta/whoami.

Takes no arguments.

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "whose token is this connection using", "check which airtable account this is signed in as", "what user does this connection run as", "confirm my airtable identity".

airtable.list_bases

List every Airtable base the connection can see, with each base's id and permission level. Use when the user asks what bases, workspaces, or spreadsheets they have access to. For one base's tables and columns, use get_base_schema.

Class read (reads only). No scopes beyond the connection's defaults. Calls GET /v0/meta/bases.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what airtable bases do I have", "show every base I can access", "list my airtable spreadsheets", "what workspaces or bases exist for me".

airtable.create_base

Create a new Airtable base in a workspace, with an initial set of tables and their fields. Use when the user wants to set up a brand new base, spreadsheet, or database from scratch. To add a table to a base that already exists, use create_table instead.

Class write (writes, no confirmation needed). Scopes schema.bases:write. Calls POST /v0/meta/bases.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "set up a brand new airtable base", "start a fresh base for this", "make me a new spreadsheet-database from scratch", "spin up a new base with these tables".

airtable.get_base_schema

Get every table in a base, with each table's fields (columns, with their types) and views. Use when the user wants to know a base's structure, what tables or columns exist, or before writing a formula or a new record. For one table's rows, use list_records.

Class read (reads only). Scopes schema.bases:read. Calls GET /v0/meta/bases/{{params.base_id}}/tables.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what tables are in this base", "show me the structure of this airtable base", "what columns does this base have", "list the tables and fields in this base".

airtable.create_table

Add a new table to an existing base, with a name and a starting column (field) schema. Use when the user wants to set up a new table, sheet, or tracker inside a base they already have. For a whole new base, use create_base; to add a row instead, use create_records.

Class write (writes, no confirmation needed). Scopes schema.bases:write. Calls POST /v0/meta/bases/{{params.base_id}}/tables.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "add a new table to this base", "set up a new sheet inside this base", "make a new tracker table here", "I need another table in this base".

airtable.update_table

Rename a table or change its description. Use when the user wants to rename or retitle a table, sheet, or tracker rather than change a row inside it. For a column's schema, use update_field; for a row's values, use update_record.

Class write (writes, no confirmation needed). Scopes schema.bases:write. Calls PATCH /v0/meta/bases/{{params.base_id}}/tables/{{params.table_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "rename this airtable table", "change the description on this table", "retitle this sheet".

airtable.create_field

Add a new field (column) to an existing table, with a name, type, and any type-specific options. Use when the user wants a new column, field, or property added to a table. To change an existing field, use update_field.

Class write (writes, no confirmation needed). Scopes schema.bases:write. Calls POST /v0/meta/bases/{{params.base_id}}/tables/{{params.table_id}}/fields.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "add a new column to this table", "I need a new field on this table", "set up a new property for this table", "add a select column here".

airtable.update_field

Rename a field (column) or change its description. Use when the user wants to rename or redescribe an existing column without changing its type or the data inside it. To add a new column instead, use create_field.

Class write (writes, no confirmation needed). Scopes schema.bases:write. Calls PATCH /v0/meta/bases/{{params.base_id}}/tables/{{params.table_id}}/fields/{{params.field_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "rename this column", "change the description on this field", "retitle this field".

airtable.list_views

List every view defined on a table: grids, forms, calendars, and so on, with each view's id, name, and type. Use when the user asks what views or tabs exist on a table. For one view's details, use get_view.

Class read (reads only). Scopes schema.bases:read. Calls GET /v0/meta/bases/{{params.base_id}}/tables/{{params.table_id}}/views.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what views does this table have", "show me every tab on this table", "list the airtable views available".

airtable.get_view

Get one view's name and type by id. Use when the user names a specific view, tab, or filtered layout on a table. For the whole list of views on a table, use list_views.

Class read (reads only). Scopes schema.bases:read. Calls GET /v0/meta/bases/{{params.base_id}}/tables/{{params.table_id}}/views/{{params.view_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what kind of view is this", "tell me about this specific tab", "look up one view's details".

airtable.list_records

List the rows (records) in one already-known Airtable table, in view order or a chosen view, paginated. Use when the user names a specific table and wants to browse or page through its rows. To filter by a formula or condition, use search_records instead.

Class read (reads only). Scopes data.records:read. Calls GET /v0/{{params.base_id}}/{{params.table_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "show me the rows in this table", "browse this airtable table", "page through the records in this sheet", "what's in this table right now".

airtable.search_records

Find rows in one Airtable table matching an Airtable formula condition, e.g. a status equals done or a date is in the past. Use when the user wants to filter, find, or query rows by a condition rather than browse the whole table. For plain browsing, use list_records.

Class read (reads only). Scopes data.records:read. Calls GET /v0/{{params.base_id}}/{{params.table_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "find rows where the status is done", "filter this table by a condition", "which rows match this formula", "look up records matching a criteria in airtable".

airtable.get_record

Get one row (record) by id, with its field values. Use when the user names or has already found a specific record, row, or item in an Airtable table. For several rows at once, use list_records or search_records.

Class read (reads only). Scopes data.records:read. Calls GET /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "pull up this one row", "show me that specific record", "what are the field values on this item".

airtable.create_records

Add one or more new rows (records) to a table in a single call, up to 10 at once. Use when the user wants to add, log, or insert new rows or entries into an Airtable table. To change an existing row instead, use update_record or update_records.

Class write (writes, no confirmation needed). Scopes data.records:write. Calls POST /v0/{{params.base_id}}/{{params.table_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "add a new row to this table", "insert a few new records here", "log this as a new entry in airtable", "add these rows to the sheet".

airtable.update_record

Change one or more field values on a single existing row, leaving every field not named untouched. Use when the user wants to edit, update, or change one or a few columns on one row. To change several rows at once, use update_records; to replace a row's fields entirely, use replace_record.

Class write (writes, no confirmation needed). Scopes data.records:write. Calls PATCH /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "change the status on this row", "update one field on this airtable record", "edit this row's value".

airtable.update_records

Change field values on several existing rows in a single call, each row keeping any field not named. Use when the user wants to bulk update, edit several rows at once, e.g. mark a batch of items done. For one row, update_record is simpler.

Class write (writes, no confirmation needed). Scopes data.records:write. Calls PATCH /v0/{{params.base_id}}/{{params.table_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "bulk update these rows", "change a field across several records at once", "mark this batch of rows as done".

airtable.replace_record

Overwrite a row's fields entirely: any column not named in this call is cleared, unlike update_record which only touches the fields you name. Use only when the user explicitly wants a row's full contents replaced or reset. Prefer update_record for a normal edit.

Class destructive (held by the mutation gate until the call's own arguments carry "confirm": true). Scopes data.records:write. Calls PUT /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "overwrite this row's entire contents", "reset all the fields on this record", "replace everything on this row with new values".

airtable.delete_record

Permanently delete one row (record) from a table. Use when the user wants to remove, delete, or get rid of a specific row or item. Airtable's API has no trash for records, so this cannot be undone through the API.

Class destructive (held by the mutation gate until the call's own arguments carry "confirm": true). Scopes data.records:write. Calls DELETE /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "remove this row from the table", "delete this record for good", "get rid of this entry in airtable".

airtable.list_record_comments

Read the comments left on one row (record), oldest first. Use when the user wants to see feedback, discussion, or notes people left on a specific Airtable row. To post a new one, use create_record_comment.

Class read (reads only). Scopes data.recordComments:read. Calls GET /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}/comments.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what have people said on this row", "show the comments on this record", "read the discussion on this item".

airtable.create_record_comment

Post a comment on one row (record). Use when the user wants to comment, leave feedback, or note something on a specific Airtable row for collaborators to see. To read existing comments first, use list_record_comments.

Class write (writes, no confirmation needed). Scopes data.recordComments:write. Calls POST /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}/comments.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "leave a comment on this row", "post a note on this record", "comment on this airtable item".

airtable.update_record_comment

Edit the text of a comment already left on a row. Use when the user wants to fix or change something they or someone else wrote on an Airtable row's comment thread. To remove it instead, use delete_record_comment.

Class write (writes, no confirmation needed). Scopes data.recordComments:write. Calls PATCH /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}/comments/{{params.comment_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "fix what I wrote in that comment", "edit my note on this row", "change the text of that comment".

airtable.delete_record_comment

Permanently remove a comment from a row's comment thread. Use when the user wants to delete, remove, or take back a comment they or someone else left on an Airtable row.

Class destructive (held by the mutation gate until the call's own arguments carry "confirm": true). Scopes data.recordComments:write. Calls DELETE /v0/{{params.base_id}}/{{params.table_id}}/{{params.record_id}}/comments/{{params.comment_id}}.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "remove that comment from the row", "take back what I said on this record", "delete that note on this item".

airtable.list_webhooks

List the webhooks registered on a base: each one's id, notification URL, whether it's enabled, and when it expires. Use when the user asks what webhooks or automations are watching a base. To add one, use create_webhook.

Class read (reads only). Scopes webhook:manage. Calls GET /v0/bases/{{params.base_id}}/webhooks.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what webhooks are watching this base", "show me the automations hooked into this base", "list the notification hooks on this base".

airtable.create_webhook

Register a new webhook on a base: a notification URL that Airtable pings when matching changes happen, per a specification of what to watch. Use when the user wants to set up a webhook or automation trigger for a base. To stop one, use delete_webhook.

Class write (writes, no confirmation needed). Scopes webhook:manage. Calls POST /v0/bases/{{params.base_id}}/webhooks.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "set up a webhook for this base", "watch this base for changes and ping a url", "register a new automation trigger here".

airtable.delete_webhook

Remove a webhook from a base so it stops receiving notifications. Use when the user wants to stop, cancel, or remove a webhook or automation trigger. Recreate it with create_webhook if needed again.

Class destructive (held by the mutation gate until the call's own arguments carry "confirm": true). Scopes webhook:manage. Calls DELETE /v0/bases/{{params.base_id}}/webhooks/{{params.webhook_id}}.

Arguments:

Also retrieved by: "stop this webhook", "remove that automation trigger", "cancel the notification hook on this base".

airtable.list_webhook_payloads

Read the change payloads a base's webhook has queued: what changed, in order. Use when the user wants to see what a webhook has captured, e.g. to debug or replay recent changes, rather than what the webhook is configured to watch.

Class read (reads only). Scopes webhook:manage. Calls GET /v0/bases/{{params.base_id}}/webhooks/{{params.webhook_id}}/payloads.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "what changes has this webhook captured", "show me the queued events for this webhook", "what did this webhook pick up recently".

airtable.refresh_webhook

Extend a webhook's expiration so it keeps receiving notifications. Use when the user wants to renew, keep alive, or stop a webhook or automation trigger from expiring. Airtable webhooks expire on their own after a period of inactivity.

Class write (writes, no confirmation needed). Scopes webhook:manage. Calls POST /v0/bases/{{params.base_id}}/webhooks/{{params.webhook_id}}/refresh.

Arguments:

Result fields (the payload is trimmed to these before it reaches the model):

Also retrieved by: "keep this webhook from expiring", "renew this webhook", "extend the webhook so it keeps firing".

airtable.enable_webhook_notifications

Turn a base's webhook notifications on or off without deleting the webhook itself. Use when the user wants to pause or resume a webhook or automation trigger temporarily.

Class write (writes, no confirmation needed). Scopes webhook:manage. Calls POST /v0/bases/{{params.base_id}}/webhooks/{{params.webhook_id}}/enableNotifications.

Arguments:

Also retrieved by: "pause this webhook for now", "turn notifications back on for this webhook", "toggle this webhook on or off".