Airtable

Airtable MCP Server for Cloudflare Workers

Available Tools

23 tools available in the Airtable MCP server. Each tool can be called by AI assistants to perform specific actions.

airtable_list_bases

List all Airtable bases accessible with the current API key.

Returns a list of bases with their IDs, names, and permission levels. Use the offset parameter for pagination if there are more bases.

Returns: { bases: [{ id, name, permissionLevel }], offset? }

{
  "type": "object",
  "properties": {
    "offset": {
      "type": "string",
      "description": "Pagination offset from previous response"
    }
  }
}

airtable_get_base_schema

Get the schema (tables, fields, views) for a base.

Returns all tables in the base with their fields and views. This is useful for understanding the structure before working with records.

Args:

baseId: The base ID (e.g., 'appXXXXXXXXXXXXXX')

Returns: { tables: [{ id, name, primaryFieldId, fields: [...], views: [...] }] }

{
  "type": "object",
  "required": [
    "baseId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    }
  }
}

airtable_create_table

Create a new table in a base.

Creates a table with the specified name and fields. At least one field must be provided.

Args:

baseId: The base ID
name: Table name
description: Optional table description
fields: Array of field definitions [{ name, type, description?, options? }]

Returns: The created table with all fields and views.

{
  "type": "object",
  "required": [
    "baseId",
    "name"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Table name"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "description": {
      "type": "string",
      "description": "Table description"
    }
  }
}

airtable_update_table

Update a table's name or description.

Args:

baseId: The base ID
tableId: The table ID
name: New table name (optional)
description: New table description (optional)

Returns: The updated table.

{
  "type": "object",
  "required": [
    "baseId",
    "tableId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New table name"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "description": {
      "type": "string",
      "description": "New table description"
    }
  }
}

airtable_create_field

Create a new field (column) in a table.

Field types include: singleLineText, email, url, multilineText, number, percent, currency, singleSelect, multipleSelects, date, dateTime, checkbox, rating, etc.

Args:

baseId: The base ID
tableId: The table ID
name: Field name
type: Field type
description: Optional field description
options: Type-specific options (e.g., choices for select fields)

Returns: The created field.

{
  "type": "object",
  "required": [
    "baseId",
    "tableId",
    "name",
    "type"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Field name"
    },
    "type": {
      "type": "string",
      "description": "Field type (e.g., singleLineText, number, singleSelect)"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "options": {
      "type": "object",
      "description": "Type-specific field options"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "description": {
      "type": "string",
      "description": "Field description"
    }
  }
}

airtable_update_field

Update a field's name, description, or options.

Note: Field type cannot be changed after creation.

Args:

baseId: The base ID
tableId: The table ID
fieldId: The field ID
name: New field name (optional)
description: New field description (optional)
options: Updated field options (optional)

Returns: The updated field.

{
  "type": "object",
  "required": [
    "baseId",
    "tableId",
    "fieldId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New field name"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "fieldId": {
      "type": "string",
      "description": "The field ID"
    },
    "options": {
      "type": "object",
      "description": "Updated field options"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "description": {
      "type": "string",
      "description": "New field description"
    }
  }
}

airtable_whoami

Get information about the current API token.

Returns the user ID and scopes associated with the API key.

Returns: { id: string, scopes?: string[] }

{
  "type": "object",
  "properties": {}
}

airtable_list_comments

List comments on a record.

Returns all comments on a specific record with author information.

Args:

baseId: The base ID
tableId: The table ID
recordId: The record ID
offset: Pagination offset (optional)

Returns: { comments: [{ id, author, text, createdTime }], offset? }

{
  "type": "object",
  "required": [
    "baseId",
    "tableId",
    "recordId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "offset": {
      "type": "string",
      "description": "Pagination offset"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "recordId": {
      "type": "string",
      "description": "The record ID"
    }
  }
}

airtable_create_comment

Add a comment to a record.

Args:

baseId: The base ID
tableId: The table ID
recordId: The record ID
text: Comment text (supports @mentions using format @[user_id])

Returns: The created comment.

{
  "type": "object",
  "required": [
    "baseId",
    "tableId",
    "recordId",
    "text"
  ],
  "properties": {
    "text": {
      "type": "string",
      "description": "Comment text"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "recordId": {
      "type": "string",
      "description": "The record ID"
    }
  }
}

airtable_update_comment

Update an existing comment.

Only the comment author can update their own comments.

Args:

baseId: The base ID
tableId: The table ID
recordId: The record ID
commentId: The comment ID
text: New comment text

Returns: The updated comment.

{
  "type": "object",
  "required": [
    "baseId",
    "tableId",
    "recordId",
    "commentId",
    "text"
  ],
  "properties": {
    "text": {
      "type": "string",
      "description": "New comment text"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "recordId": {
      "type": "string",
      "description": "The record ID"
    },
    "commentId": {
      "type": "string",
      "description": "The comment ID"
    }
  }
}

airtable_delete_comment

Delete a comment.

Only the comment author can delete their own comments.

Args:

baseId: The base ID
tableId: The table ID
recordId: The record ID
commentId: The comment ID

Returns: Confirmation of deletion.

{
  "type": "object",
  "required": [
    "baseId",
    "tableId",
    "recordId",
    "commentId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "tableId": {
      "type": "string",
      "description": "The table ID"
    },
    "recordId": {
      "type": "string",
      "description": "The record ID"
    },
    "commentId": {
      "type": "string",
      "description": "The comment ID"
    }
  }
}

airtable_list_records

List records from a table with optional filtering, sorting, and pagination.

Supports Airtable formula filtering, view-based filtering, field selection, and sorting. Maximum 100 records per page. Use offset for pagination.

Args:

baseId: The base ID
tableIdOrName: Table ID or name
view: View ID or name to filter by (optional)
filterByFormula: Airtable formula to filter records (optional)
fields: Array of field names to return (optional, returns all if not specified)
sort: Array of sort specifications [{ field, direction }] (optional)
pageSize: Number of records per page (1-100, default 100)
offset: Pagination offset from previous response (optional)
maxRecords: Maximum total records to return (optional)

Returns: { records: [{ id, createdTime, fields }], offset? }

{
  "type": "object",
  "required": [
    "baseId",
    "tableIdOrName"
  ],
  "properties": {
    "view": {
      "type": "string",
      "description": "View ID or name to filter by"
    },
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "fields": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Field names to return"
    },
    "offset": {
      "type": "string",
      "description": "Pagination offset"
    },
    "pageSize": {
      "type": "integer",
      "default": 100,
      "maximum": 100,
      "minimum": 1,
      "description": "Records per page"
    },
    "maxRecords": {
      "type": "integer",
      "description": "Maximum total records"
    },
    "tableIdOrName": {
      "type": "string",
      "description": "Table ID or name"
    },
    "filterByFormula": {
      "type": "string",
      "description": "Airtable formula to filter records"
    }
  }
}

airtable_get_record

Get a single record by ID.

Args:

baseId: The base ID
tableIdOrName: Table ID or name
recordId: The record ID (e.g., 'recXXXXXXXXXXXXXX')

Returns: { id, createdTime, fields }

{
  "type": "object",
  "required": [
    "baseId",
    "tableIdOrName",
    "recordId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "recordId": {
      "type": "string",
      "description": "The record ID"
    },
    "tableIdOrName": {
      "type": "string",
      "description": "Table ID or name"
    }
  }
}

airtable_create_records

Create one or more records in a table.

Can create up to 10 records per request. Use typecast=true to automatically convert string values to appropriate types.

Args:

baseId: The base ID
tableIdOrName: Table ID or name
records: Array of records to create [{ fields: { fieldName: value } }]
typecast: Whether to typecast values (default false)

Returns: { records: [{ id, createdTime, fields }] }

{
  "type": "object",
  "required": [
    "baseId",
    "tableIdOrName"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "typecast": {
      "type": "boolean",
      "default": false,
      "description": "Typecast string values"
    },
    "tableIdOrName": {
      "type": "string",
      "description": "Table ID or name"
    }
  }
}

airtable_update_records

Update one or more existing records (partial update).

Can update up to 10 records per request. Only specified fields are updated; others remain unchanged.

Args:

baseId: The base ID
tableIdOrName: Table ID or name
records: Array of records to update [{ id, fields: { fieldName: value } }]
typecast: Whether to typecast values (default false)

Returns: { records: [{ id, createdTime, fields }] }

{
  "type": "object",
  "required": [
    "baseId",
    "tableIdOrName"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "typecast": {
      "type": "boolean",
      "default": false,
      "description": "Typecast string values"
    },
    "tableIdOrName": {
      "type": "string",
      "description": "Table ID or name"
    }
  }
}

airtable_upsert_records

Upsert (update or insert) records based on matching fields.

Creates records that don't exist, updates those that do. Matches are determined by the fieldsToMergeOn parameter.

Args:

baseId: The base ID
tableIdOrName: Table ID or name
records: Array of records [{ fields: { fieldName: value } }]
fieldsToMergeOn: Field names to match for upsert (e.g., ['Email'])
typecast: Whether to typecast values (default false)

Returns: { records, updatedRecords: string[], createdRecords: string[] }

{
  "type": "object",
  "required": [
    "baseId",
    "tableIdOrName",
    "fieldsToMergeOn"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "typecast": {
      "type": "boolean",
      "default": false,
      "description": "Typecast string values"
    },
    "tableIdOrName": {
      "type": "string",
      "description": "Table ID or name"
    },
    "fieldsToMergeOn": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Fields to match for upsert"
    }
  }
}

airtable_delete_records

Delete one or more records.

Can delete up to 10 records per request.

Args:

baseId: The base ID
tableIdOrName: Table ID or name
recordIds: Array of record IDs to delete

Returns: { records: [{ id, deleted: boolean }] }

{
  "type": "object",
  "required": [
    "baseId",
    "tableIdOrName",
    "recordIds"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "recordIds": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Record IDs to delete (max 10)"
    },
    "tableIdOrName": {
      "type": "string",
      "description": "Table ID or name"
    }
  }
}

airtable_list_webhooks

List all webhooks for a base.

Returns all webhooks configured on the base with their specifications.

Args:

baseId: The base ID

Returns: { webhooks: [{ id, notificationUrl, specification, isHookEnabled, ... }] }

{
  "type": "object",
  "required": [
    "baseId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    }
  }
}

airtable_create_webhook

Create a webhook to receive notifications about base changes.

Webhooks notify your endpoint when records, fields, or metadata change. The webhook secret (macSecretBase64) must be saved to validate payloads.

Args:

baseId: The base ID
notificationUrl: URL to receive webhook notifications (optional)
dataTypes: Array of data types to watch ('tableData', 'tableFields', 'tableMetadata')
recordChangeScope: Scope for record changes (optional)
watchDataInFieldIds: Field IDs to watch for data changes (optional)
watchSchemasOfFieldIds: Field IDs to watch for schema changes (optional)
includeCellValuesInFieldIds: Field IDs to include cell values for (optional)
includePreviousCellValues: Include previous values in payload (optional)
includePreviousFieldDefinitions: Include previous field definitions (optional)

Returns: The created webhook with macSecretBase64 for payload validation.

{
  "type": "object",
  "required": [
    "baseId",
    "dataTypes"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "dataTypes": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Data types to watch"
    },
    "notificationUrl": {
      "type": "string",
      "description": "URL for webhook notifications"
    },
    "recordChangeScope": {
      "type": "string",
      "description": "Scope for record changes"
    },
    "watchDataInFieldIds": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Field IDs to watch"
    },
    "watchSchemasOfFieldIds": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Field IDs to watch schemas"
    },
    "includePreviousCellValues": {
      "type": "boolean",
      "description": "Include previous values"
    },
    "includeCellValuesInFieldIds": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Field IDs to include values"
    },
    "includePreviousFieldDefinitions": {
      "type": "boolean",
      "description": "Include previous field definitions"
    }
  }
}

airtable_delete_webhook

Delete a webhook.

Args:

baseId: The base ID
webhookId: The webhook ID

Returns: Confirmation of deletion.

{
  "type": "object",
  "required": [
    "baseId",
    "webhookId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "webhookId": {
      "type": "string",
      "description": "The webhook ID"
    }
  }
}

airtable_list_webhook_payloads

List pending webhook payloads.

Retrieves payloads that have been generated but not yet delivered. Use cursor for pagination through payloads.

Args:

baseId: The base ID
webhookId: The webhook ID
cursor: Cursor for pagination (optional)

Returns: { payloads: [...], cursor, mightHaveMore }

{
  "type": "object",
  "required": [
    "baseId",
    "webhookId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "cursor": {
      "type": "number",
      "description": "Pagination cursor"
    },
    "webhookId": {
      "type": "string",
      "description": "The webhook ID"
    }
  }
}

airtable_refresh_webhook

Refresh a webhook's expiration time.

Webhooks expire after a period of inactivity. Call this to extend the expiration.

Args:

baseId: The base ID
webhookId: The webhook ID

Returns: { expirationTime: string }

{
  "type": "object",
  "required": [
    "baseId",
    "webhookId"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "webhookId": {
      "type": "string",
      "description": "The webhook ID"
    }
  }
}

airtable_toggle_webhook_notifications

Enable or disable webhook notifications.

When disabled, the webhook continues to track changes but doesn't send notifications.

Args:

baseId: The base ID
webhookId: The webhook ID
enable: Whether to enable notifications

Returns: Confirmation of the operation.

{
  "type": "object",
  "required": [
    "baseId",
    "webhookId",
    "enable"
  ],
  "properties": {
    "baseId": {
      "type": "string",
      "description": "The Airtable base ID"
    },
    "enable": {
      "type": "boolean",
      "description": "Enable or disable notifications"
    },
    "webhookId": {
      "type": "string",
      "description": "The webhook ID"
    }
  }
}