Integration

Airtable integration

Cloud-based platform combining spreadsheet flexibility with relational database power. Perform CRUD operations on records, manage comments, work with structured data, manage database schemas and metadata, sync CSV data, upload attachments, and configure webhooks for real-time event notifications. Features include filtering with formula syntax, sorting, pagination, batch operations, table and field management, and event-driven integrations. Note: legacy user API keys were deprecated on February 1, 2024 - only Personal Access Tokens (PAT) and OAuth tokens are accepted.

Connect Airtable How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Airtable.Built from the 29 Airtable tools below, on the connection you add once.

Common Airtable use cases

cleaning up unused views
correcting comment typos
dynamic schema evolution
removing outdated comments
form submission to Airtable
renaming fields for clarity
renaming tables for clarity
decommissioning integrations
processing real-time changes
programmatic workspace setup

What you can do with Airtable

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Record, 9 operations

create_recordsCreate recordsPOSTCreates one or more new records in an Airtable table. Supports batch creation of up to 10 records per request. Field values must match your table's schema (field names are case-sensitive). Returns all created records with their newly assigned IDs ...
delete_recordDelete recordDELETEPermanently deletes a single record by its record ID. This operation is irreversible through the API. Returns confirmation with the deleted record ID and deleted flag.
delete_recordsDelete recordsDELETEPermanently deletes records from an Airtable table. Supports batch deletion of up to 10 records per request by providing their record IDs. This operation is irreversible through the API - deleted records cannot be recovered programmatically. Retur...
get_recordGet recordGETRetrieves a single record by its unique ID from an Airtable table. Returns the complete record with all field values, creation timestamp, and record ID. Perfect for displaying detailed record information or loading data for edit forms after you've...
list_recordsList recordsGETRetrieves records from an Airtable table with advanced filtering, sorting, and field selection. Supports Airtable's formula syntax for complex queries (similar to Excel formulas). Returns each record's unique ID, creation timestamp, and requested ...
replace_recordReplace recordPUTCompletely replaces a single record by its ID. This is a destructive operation: any fields not included in the request will be cleared. Use this only when you want to completely overwrite a single record.
replace_recordsReplace recordsPUTCompletely replaces existing records in an Airtable table. This is a destructive operation that clears all existing field values and sets only the fields you provide. Any fields not included in your request will be emptied. Use this only when you ...
update_recordUpdate recordPATCHPartially updates a single record by its record ID. Only specified fields are modified; unspecified fields remain unchanged. Use this when updating one specific record rather than batch updating multiple records.
update_recordsUpdate recordsPATCHPartially updates existing records in an Airtable table. Only the fields you specify will be modified - all other field values remain unchanged. Supports batch updates of up to 10 records per request. Requires record IDs from previous list, get, o...

Comment, 4 operations

create_commentCreate commentPOSTCreates a new comment on an Airtable record. Supports @mentions using @[usrXXXXXXXXXXXXXX] format to notify specific users, and optional parentCommentId for threaded replies. Requires the data.recordComments:write scope on a Personal Access Token ...
delete_commentDelete commentDELETEPermanently deletes a comment from a record. Non-admin users can only delete their own comments. Enterprise Admins can delete any comment. Requires the data.recordComments:write scope on a Personal Access Token or OAuth token.
list_commentsList commentsGETLists all comments on a specific Airtable record, ordered from newest to oldest. Returns comment ID, author information, text content with mentions, and timestamps. Requires the data.recordComments:read scope on a Personal Access Token or OAuth to...
update_commentUpdate commentPATCHUpdates the text content of an existing comment. You can only update comments that you created. Requires the data.recordComments:write scope on a Personal Access Token or OAuth token.

Webhook, 4 operations

create_webhookCreate webhookPOSTCreates a new webhook for real-time notifications. Configure which events to track (record creates, updates, deletes) and optionally filter by table or view. Returns a unique MAC secret for validating payloads. Requires the webhook:manage scope on...
delete_webhookDelete webhookDELETEPermanently deletes a webhook, stopping all notifications. Use when an integration is no longer needed or to clean up unused webhooks. Requires the webhook:manage scope on a Personal Access Token or OAuth token.
list_webhooksList webhooksGETLists all webhooks configured for an Airtable base. Returns webhook IDs, notification URLs, specifications, and expiration times. Requires the webhook:manage scope on a Personal Access Token or OAuth token.
refresh_webhookRefresh webhookPOSTRefreshes a webhook to extend its expiration by 7 days from the current time. Webhooks automatically expire if not refreshed. Call this periodically to keep webhooks active. Requires the webhook:manage scope on a Personal Access Token or OAuth token.

Base, 2 operations

create_baseCreate basePOSTCreates a new Airtable base (workspace database) with initial tables and fields. You must specify the workspace, base name, and at least one table with one field. Returns the new base ID and complete schema.
list_basesList basesGETLists all Airtable workspaces (bases) you have access to. Returns each base's unique ID, display name, and your permission level (read, comment, edit, or create). Use this as your starting point to discover available databases before working with ...

Field, 2 operations

create_fieldCreate fieldPOSTCreates a new field (column) in an existing Airtable table. Supports all standard field types including text, number, select, date, checkbox, attachment, and linked records. Field type-specific options can be configured for select choices, number ...
update_fieldUpdate fieldPATCHUpdates an existing field's metadata and type-specific options. Allows renaming fields, updating descriptions, and modifying type-specific settings like select choices or number precision. Note: field type cannot be changed after creation.

Table, 2 operations

create_tableCreate tablePOSTCreates a new table within an Airtable base with a specified name, description, and field definitions. Define your initial schema with field types such as text, number, select dropdowns, dates, checkboxes, and linked records. Returns the complete ...
update_tableUpdate tablePATCHUpdates the name and/or description of an existing Airtable table. This operation only modifies metadata - it does not change the table schema, field definitions, or any data. Perfect for renaming tables, updating documentation, or maintaining con...

View, 2 operations

delete_viewDelete viewDELETEPermanently deletes a view from an Airtable table. This only removes the view configuration (filters, sorts, field visibility) - it does not delete any records or affect the underlying data. Use with caution as deleted views cannot be recovered vi...
list_viewsList viewsGETLists all views for a specific table in an Airtable base. Returns each view's ID, name, and type (grid, calendar, gallery, kanban, form, timeline, gantt). Use view IDs with list_records to apply saved filters and sorts.

Attachment, 1 operation

upload_attachmentUpload attachmentPOSTUploads a file (up to 5 MB) directly to an attachment cell on an Airtable record. Send the file as base64-encoded bytes along with its MIME type and filename. Returns the updated record with the attachment metadata. Requires the data.records:write...

Schema, 1 operation

get_base_schemaGet base schemaGETGets the complete structure of an Airtable base, showing all tables, their fields, field types, and configuration options. Essential for understanding your data structure before reading or writing records. Returns detailed information including se...

Sync, 1 operation

sync_csv_dataSync csv dataPOSTPushes raw CSV data into a table via Airtable's Sync API. Requires the table to already be configured as a 'Sync from API endpoint' source in the Airtable UI, which produces the apiEndpointSyncId. The Sync API supports up to 10k rows, 500 columns,...

Webhook payload, 1 operation

list_webhook_payloadsList webhook payloadsGETRetrieves the actual change data for webhook notifications. When Airtable sends a ping notification to your URL, call this endpoint to fetch the detailed payload with changed records, fields, and values. Requires the webhook:manage scope on a Pers...

OAuth scopes Airtable requires

Each operation declares the scopes Airtable requires for it.

data.records:writeneeded by sync_csv_data, upload_attachment
schema.bases:writeneeded by sync_csv_data

Use Airtable from Claude Code, Cursor or Codex

Connect Airtable in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Airtable operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Airtable

Create your workspace
Sign up free. Nothing to install.
Connect Airtable once
Add your Airtable connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

Airtable integration FAQ

What can you do with the Airtable integration?

LiveContext exposes 29 operations on Airtable, covering record, comment, webhook and base. Common uses include cleaning up unused views, correcting comment typos and dynamic schema evolution.

Which OAuth scopes does Airtable require?

It depends on the operation: each one declares the scopes Airtable requires for it. The most common are data.records:write (2 operations) and schema.bases:write (1 operation).