Loading...
Bases, tables, records, views — structured data with rich field types over REST
85+ deploysYour AI agent gets 5 capabilities in one connection. Deploy once, use from any client.
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
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}
Connect Airtable to Claude Code with one command:
claude mcp add airtable https://datafaucet.dev/api/mcp/t/airtable{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/airtable
Paste into your client's MCP configuration file · most users connect in under 60s
claude mcp add airtable --url https://datafaucet.dev/api/mcp/t/airtableWhat your AI agent sees
I have access to 5 tools from Airtable: list_bases, list_records, create_record, and 2 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 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”
Copy“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”
Copy“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”
CopyClick any prompt to copy, then paste into your AI client.