Loading...
List bases, read table records, create rows, and filter views in Airtable via the REST API. Supports rich field types.
85+ deploysclaude mcp add airtable --url https://datafaucet.dev/api/mcp/t/airtable
Run this command in your terminal · most users connect in under 60s
GET endpoints
list_bases
List all accessible bases with ID, name, and permissionLevel (owner/editor/commenter/read). Use base ID (appXXXXXXXX) in all other Airtable endpoints. Personal access tokens scope to specific bases.
https://api.airtable.com/v0/meta/bases
list_records
List records with all field values (text, number, date, attachments, linked records). Filter with 'filterByFormula' (e.g. {Status}='Done'), sort with 'sort[0][field]' and 'sort[0][direction]' (asc/desc). Paginate with 'offset' from response. Max 100 per request.
https://api.airtable.com/v0/{base_id}/{table_name}?maxRecords=20
list_tables
List all tables in a base. Each table includes: name, id (tblXXX), fields array (id, name, type like singleLineText/number/multipleSelects/linkedRecords), and views array (id, name, type). Use field names in create/update calls.
https://api.airtable.com/v0/meta/bases/{base_id}/tables
get_record
Get a single record by ID (recXXXXXXXX). Returns id, createdTime, and fields object with all field values including attachments (url, filename, size), linked records (array of IDs), and computed fields.
https://api.airtable.com/v0/{base_id}/{table_name}/{record_id}
POST endpoints
create_record
Create up to 10 records in one call. Each record needs a 'fields' object matching table column names exactly (case-sensitive). Linked records use record IDs in array. Returns created records with IDs (recXXXXXXXX) and createdTime.
https://api.airtable.com/v0/{base_id}/{table_name}
PATCH endpoints
update_record
Update up to 10 records by ID. Only fields included in the 'fields' object are modified (partial update). Omitted fields keep their current value. Pass record ID (recXXXXXXXX) from list_records. Returns updated records with all field values.
https://api.airtable.com/v0/{base_id}/{table_name}
DELETE endpoints
delete_record
Delete up to 10 records by ID. Pass record IDs as repeated 'records[]' query params. Returns array of {id, deleted: true} objects. Deletion is permanent and cannot be undone via API.
https://api.airtable.com/v0/{base_id}/{table_name}?records[]={record_id}
Run this in your terminal:
claude mcp add airtable https://datafaucet.dev/api/mcp/t/airtable
Connect Airtable to your AI agent in under 60 seconds. No account required.
{notion_token}) with your real credentialsNeed API keys? Try our free sandbox templates first to see MCP in action with zero setup.
Replace these placeholders with your real values before deploying:
{airtable_token}API settings page{base_id}Resource identifier{record_id}Resource identifier{record_name}Your value{record_notes}Your value{table_name}Your valuePreview:
GET https://api.airtable.com/v0/meta/bases Authorization: Bearer {airtable_token}
claude mcp add airtable --url https://datafaucet.dev/api/mcp/t/airtableWhat your AI agent sees
I have access to 7 tools from Airtable: list_bases, list_records, create_record, and 4 more.
“List all accessible bases with ID, name, and permissionLevel (owner/editor/commenter/read). Use base ID (appXXXXXXXX) in all other Airtable endpoints. Personal access tokens scope to specific bases.”
Calling list_bases... Done. Here are the results.
Try these prompts
“List all records in the Projects base sorted by due date”
Copy“Create a new record in the Contacts table with name and email”
Copy“Find all records where status is 'Blocked' and show the assignee”
CopyClick any prompt to copy, then paste into your AI client.