Airtable
MCP server for Airtable API — manage records, bases, tables, fields, and webhooks.
What it can do
- Airtable List Records: List records from an Airtable table. Supports filtering with formulas, sorting, field selection, views, and pagination (max 100 per page). Use the offset token from the response
- Airtable Get Record: Get a single record by its ID. Returns the record with all fields.
- Airtable Create Records: Create one or more records in a table (max 10 per request). Each record needs a "fields" object with field name-value pairs. Enable typecast to auto-convert values to the corr
What data it sees
Do you need an account
An API key from the service settings is required
MCP server for Airtable API — manage records, bases, tables, fields, and webhooks.
Features
- Full CRUD for records with filtering, sorting, and pagination
- Upsert records (update-or-create by matching fields)
- Base and table schema management (create tables, add fields)
- Webhook lifecycle (create, list, refresh, payloads, delete)
- Batch operations (up to 10 records per request)
18 Tools
Records: list, get, create, update, delete, upsert Bases & Schema: list bases, get schema, create base, create table, update table, create field, update field Webhooks: create, list, refresh, list payloads, delete
Configuration
- AIRTABLE_PAT — Personal Access Token from https://airtable.com/create/tokens
How to connect
How to connect Airtable to Claude
The server address to paste into Claude settings:
https://airtable--node2flow.run.tools
- Open Claude (claude.ai or the desktop app).
- Go to Settings → Connectors.
- Click Add custom connector.
- Paste the server address copied below into Remote MCP server URL and click Add.
- In a chat, click + → Connectors and switch the new connector on.
Custom connectors are available on Free, Pro, Max, Team and Enterprise plans (Free is limited to one). On Team and Enterprise an organization Owner adds the connector first under Organization settings → Connectors.
Authorization
After you click Add, a sign-in window for the service opens. Sign in with your own account and approve access. Claude never sees your password.
How to connect Airtable to ChatGPT
The server address to paste into ChatGPT settings:
https://airtable--node2flow.run.tools
- Open ChatGPT in a browser (chatgpt.com). A Plus, Pro, Business, Enterprise or Edu plan is required.
- Turn on developer mode once: Settings → Apps → Advanced settings → Developer mode.
- Open Settings → Connectors and click Create.
- Fill in the form: Name (anything), Description (one line about what the service does), MCP server URL (copy it below).
- Under Authentication choose OAuth if the service requires sign-in, otherwise None. Click Create.
- In a new chat open + → Apps/Connectors and enable the connector.
OpenAI has renamed this section before (Connectors → Apps/Plugins). If the label differs, search settings for "developer mode". On Business/Enterprise workspaces an admin must allow custom connectors first.
Authorization
On first use ChatGPT opens the service's sign-in window. Sign in and approve access.
How to connect Airtable to Cursor
The server address to paste into Cursor settings:
https://airtable--node2flow.run.tools
Fastest: click Open in Cursor below and confirm the prompt.
Manually:
- In Cursor open Settings → Cursor Settings → MCP and click Add new global MCP server.
- Paste the JSON copied below into
~/.cursor/mcp.json(per project:.cursor/mcp.jsonin the repo root). - Save the file. The server appears in the MCP list; authorize it there if asked.
Authorization
If the service needs sign-in, an authorize button appears next to the server in the MCP list.
Server tool list (18)
Raw names from tools/list. Only developers need these.
| airtable_list_records | List records from an Airtable table. Supports filtering with formulas, sorting, field selection, views, and pagination (max 100 per page). Use the offset token from the response to get the next page. |
| airtable_get_record | Get a single record by its ID. Returns the record with all fields. |
| airtable_create_records | Create one or more records in a table (max 10 per request). Each record needs a "fields" object with field name-value pairs. Enable typecast to auto-convert values to the correct field type. |
| airtable_update_records | Update specific fields in one or more records (PATCH — partial update, max 10 per request). Only specified fields are changed; other fields remain untouched. |
| airtable_delete_records | Delete one or more records by their IDs (max 10 per request). This action is irreversible. |
| airtable_upsert_records | Update existing records or create new ones based on matching fields. Specify fields_to_merge_on to match existing records — matched records are updated, unmatched are created. |
| airtable_list_bases | List all bases accessible to the authenticated user. Returns base ID, name, and permission level. |
| airtable_get_base_schema | Get the complete schema of a base — all tables with their fields (name, type, options) and views. Essential for understanding the data structure before querying. |
| airtable_create_base | Create a new base in a workspace. Requires at least one table with at least one field. |
| airtable_create_table | Create a new table in a base. Requires at least one field. Field types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, checkbox, email, url, etc. |
| airtable_update_table | Update a table name or description. |
| airtable_create_field | Add a new field to a table. Common types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, dateTime, checkbox, email, url, multipleAttachments, multipleRecordLinks. |
| airtable_update_field | Update a field name or description. Cannot change field type. |
| airtable_create_webhook | Create a webhook to receive notifications when data changes in a base. Webhooks expire after 7 days — use airtable_refresh_webhook to extend. Returns a MAC secret for verifying payloads. |
| airtable_list_webhooks | List all webhooks for a base. Shows webhook IDs, enabled status, notification URLs, and expiration times. |
| airtable_refresh_webhook | Extend a webhook expiration time by 7 days from now. Webhooks expire after 7 days — call this periodically to keep them active. |
| airtable_list_webhook_payloads | Get pending webhook notification payloads. Returns changed records, fields, and tables since the last cursor position. |
| airtable_delete_webhook | Delete a webhook. Stops all notifications for this webhook. |