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.