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.