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).

LiveContext

All integrations

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.

29 toolsOAuthAPI docs

Connect Airtable How integrations work

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

POSTcreate_records
Creates 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 ...
DELETEdelete_record
Permanently 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.
DELETEdelete_records
Permanently 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...
GETget_record
Retrieves 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...
GETlist_records
Retrieves 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 ...
PUTreplace_record
Completely 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.
PUTreplace_records
Completely 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 ...
PATCHupdate_record
Partially 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.
PATCHupdate_records
Partially 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

POSTcreate_comment
Creates 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 ...
DELETEdelete_comment
Permanently 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.
GETlist_comments
Lists 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...
PATCHupdate_comment
Updates 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

POSTcreate_webhook
Creates 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...
DELETEdelete_webhook
Permanently 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.
GETlist_webhooks
Lists 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.
POSTrefresh_webhook
Refreshes 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

POSTcreate_base
Creates 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.
GETlist_bases
Lists 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

POSTcreate_field
Creates 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 ...
PATCHupdate_field
Updates 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

POSTcreate_table
Creates 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 ...
PATCHupdate_table
Updates 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

DELETEdelete_view
Permanently 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...
GETlist_views
Lists 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

POSTupload_attachment
Uploads 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

GETget_base_schema
Gets 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

POSTsync_csv_data
Pushes 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

GETlist_webhook_payloads
Retrieves 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).