Automate Airtable Data Management

Airtable Automation via Rube MCP is a skill for automating Airtable operations through Composio's Airtable toolkit over the Rube MCP connector - records, bases, tables, fields, and views. It requires Rube MCP connected (RUBE_SEARCH_TOOLS available) and an active Airtable connection established via RUBE_MANAGE_CONNECTIONS, with the rule to always call RUBE_SEARCH_TOOLS first to get current tool schemas since they can change.

It documents four core workflows with exact tool sequences and pitfalls. Record management: AIRTABLE_LIST_BASES and AIRTABLE_GET_BASE_SCHEMA as prerequisites, then AIRTABLE_LIST_RECORDS/CREATE_RECORD(S)/UPDATE_RECORD(S)/DELETE_RECORD(S) - noting pageSize caps at 100 with offset pagination (changing filters mid-pagination can skip or duplicate rows), CREATE_RECORDS has a hard 10-record-per-request limit requiring chunking, field names are case-sensitive, and INVALID_MULTIPLE_CHOICE_OPTIONS errors may require typecast=true. Search and filter: verify schema first, then query with filterByFormula (Airtable formula syntax, e.g. {Status}='Done'), noting the ~5 requests/second per-base rate limit and the need to handle 429 responses with Retry-After. Field/schema management: AIRTABLE_CREATE_FIELD and AIRTABLE_UPDATE_FIELD, noting UPDATE_FIELD only changes name/description (not type/options - a replacement field must be created and data migrated), and that computed fields (formula, rollup, lookup) cannot be created via the API. Comment management: AIRTABLE_LIST_COMMENTS with 17-character record IDs.

AND({A}='x', {B}='y')          # both conditions
OR({A}='x', {A}='y')           # either condition
FIND('test', {Name})>0         # contains text
IS_BEFORE({Due Date}, TODAY()) # date comparison

A quick-reference table maps every task to its exact tool slug and key parameters. ID format rules are strict and consistent: base IDs start with 'app', table IDs with 'tbl', record IDs with 'rec', and field IDs with 'fld', each 17 characters. Batch limits (CREATE/UPDATE/DELETE_MULTIPLE_RECORDS) are capped at 10 records per request across the board.

Use this skill when automating Airtable through Rube MCP - creating, reading, updating, or deleting records, searching with formulas, managing fields and table schema, or working with record comments.

This skill is tagged critical risk (community-sourced) since it covers delete operations (single and bulk) with no built-in confirmation step - review delete/update parameters carefully before execution, especially bulk operations. It is scoped to what the Airtable REST API supports through Composio's toolkit; computed field types (formula, rollup, lookup) cannot be created this way regardless of workflow.

Inputs: Airtable base/table/record/field identifiers, field values, and filter formulas.

Outputs: created, updated, or deleted Airtable records and fields; query results matching a filter formula; and record comment lists.

Operates through Rube MCP (https://rube.app/mcp, no API keys needed) and Composio's Airtable toolkit, requiring an active Airtable OAuth connection via RUBE_MANAGE_CONNECTIONS.

Operations and automation teams using Airtable who want an agent to manage records, fields, and schema through Rube MCP with documented tool sequences and known API pitfalls.