Airtable Automation via Rube MCP

Automate Airtable operations through Composio's Airtable toolkit via Rube MCP.

Toolkit docs: composio.dev/toolkits/airtable

Prerequisites

• Rube MCP must be connected (RUBE_SEARCH_TOOLS available)
• Active Airtable connection via RUBE_MANAGE_CONNECTIONS with toolkit airtable
• Always call RUBE_SEARCH_TOOLS first to get current tool schemas

Setup

Get Rube MCP: Add https://rube.app/mcp as an MCP server in your client configuration. No API keys needed, just add the endpoint and it works.

1. Verify Rube MCP is available by confirming RUBE_SEARCH_TOOLS responds
2. Call RUBE_MANAGE_CONNECTIONS with toolkit airtable
3. If connection is not ACTIVE, follow the returned auth link to complete Airtable auth
4. Confirm connection status shows ACTIVE before running any workflows

Core Workflows

1. Create and Manage Records

When to use: User wants to create, read, update, or delete records

Tool sequence:

1. AIRTABLE_LIST_BASES - Discover available bases [Prerequisite]
2. AIRTABLE_GET_BASE_SCHEMA - Inspect table structure [Prerequisite]
3. AIRTABLE_LIST_RECORDS - List/filter records [Optional]
4. AIRTABLE_CREATE_RECORD / AIRTABLE_CREATE_RECORDS - Create records [Optional]
5. AIRTABLE_UPDATE_RECORD / AIRTABLE_UPDATE_MULTIPLE_RECORDS - Update records [Optional]
6. AIRTABLE_DELETE_RECORD / AIRTABLE_DELETE_MULTIPLE_RECORDS - Delete records [Optional]

Key parameters:

• baseId: Base ID (starts with 'app', e.g., 'appXXXXXXXXXXXXXX')
• tableIdOrName: Table ID (starts with 'tbl') or table name
• fields: Object mapping field names to values
• recordId: Record ID (starts with 'rec') for updates/deletes
• filterByFormula: Airtable formula for filtering
• typecast: Set true for automatic type conversion