Airtable MCP (LobeChat Plugin)

Airtable MCP is a LobeChat plugin that proxies the Airtable Web API through a controlled gateway. It requires an access token for plugin users and uses a single server-side PAT.

Features

List, get, create, update, and delete records (batch supported)
CSV import/export helpers for records
List bases and tables, and fetch a single table schema by id or name
Manage record comments (list/create/update/delete)
Upload attachments to attachment fields
Manage webhooks (list/create/delete/refresh/enable notifications/list payloads)

Production URLs

Manifest: https://airtable.4spotconsulting.com/manifest.json
OpenAPI: https://airtable.4spotconsulting.com/openapi.json
Gateway: https://airtable.4spotconsulting.com/api/gateway

Required Environment Variables

Set these on the server hosting the plugin:

AIRTABLE_PAT=your-personal-access-token
PLUGIN_ACCESS_TOKEN=your-access-token

Plugin Settings (LobeChat)

When installing the plugin, provide:

access_token: your-access-token

The Airtable PAT is read from the server env and is not entered in the plugin UI.

Supported API Endpoints

Schema:

bases_list
tables_list
tables_get
tables_create

Records:

records_list
records_get
records_create
records_update
records_delete
records_exportCsv
records_importCsv

Comments:

comments_list
comments_create
comments_update
comments_delete

Attachments:

attachments_upload

Webhooks:

webhooks_list
webhooks_create
webhooks_delete
webhooks_refresh
webhooks_enableNotifications
webhooks_listPayloads

Local Development

npm install
npm run dev

The dev manifest is available at http://localhost:3400/manifest-dev.json

CSV Import Notes

records_importCsv can create a new table when createTable=true.
If tableIdOrName is omitted, an auto table name like CSV Import YYYY-MM-DD HHMMSS is used.

Airtable MCP