Airtable MCP server for AI agents
Read the schema of Airtable bases and list, create, update and delete records in their tables.
- Auth
- Access token · OAuth 2.0 (sign in with the app)
- Tools
- 7
- Triggers
- 0
- Category
- Productivity, Spreadsheets
Tools and triggers
List bases
AIRTABLE_LIST_BASES
Lists the bases the token can access, with their ids and permission levels.read-only
Get a base's tables and fields
AIRTABLE_GET_BASE_SCHEMA
Returns the tables of a base with their ids, fields (name, type, options) and views. Read this before writing records.read-only
List records
AIRTABLE_LIST_RECORDS
Lists records of a table. Filter with a formula (e.g. {Status}='Open'), pick a view, sort and limit. Up to 100 per page; use `offset` to continue.read-only
Get a record
AIRTABLE_GET_RECORD
Returns one record by id (rec…) with all its field values.read-only
Create records
AIRTABLE_CREATE_RECORDS
Adds up to 10 records to a table in one call. Use Get a base's tables and fields first to learn field names and types.
Update records
AIRTABLE_UPDATE_RECORDS
Changes up to 10 existing records. Only the fields given are changed; other fields keep their values.
Delete a record
AIRTABLE_DELETE_RECORD
Permanently deletes one record by id.destructive
Connect via MCP
Create an MCP server for Airtable in the dashboard, then add its URL to your client. This is the Claude Code command; the client guide has the others.
claude mcp add --transport http airtable \
"https://www.prompt-tm.com/mcp/<server id>?user_id=<your user>" \
--header "x-api-key: ptm_…"Connect via REST
Run a tool with one request. The response is { data, error, successful, log_id } for every tool.
curl -X POST https://www.prompt-tm.com/api/v3/tools/execute/AIRTABLE_LIST_BASES \
-H "x-api-key: $PROMPT_TM_KEY" -H "content-type: application/json" \
-d '{ "user_id": "alice", "arguments": {} }'
