Summary
Wraps the Airtable REST API v0 with five core operations: list and get records, create new records, list bases, and fetch base schemas. You get filtering by formula, full CRUD on table data, and schema introspection so you can understand field types before writing. Hosted by Pipeworx as a streamable HTTP endpoint, so no local setup. The ask_pipeworx wrapper lets you query in plain English instead of calling tools directly. Reach for this when you need Claude to read from or write to Airtable bases, whether you're syncing data, building records from conversation, or exploring what tables and fields exist in a workspace.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Tools
Public tool metadata for what this MCP can expose to an agent.
18 tools
airtable_list_recordsList 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.9 params
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.
Parameters* required
sortarrayArray of sort objects: [{"field": "Name", "direction": "asc"}]
viewstringView name or ID to use for pre-filtering
fieldsarrayArray of field names to include in the response
offsetstringPagination token from previous response
base_idstringAirtable base ID (e.g., "appXXXXXXXXXXXXXX")
page_sizenumberNumber of records per page (1-100, default: 100)
max_recordsnumberMaximum total records to return
table_id_or_namestringTable ID (e.g., "tblXXX") or table name (e.g., "Tasks")
filter_by_formulastringAirtable formula to filter records (e.g., "{Status}='Active'")
airtable_get_recordGet a single record by its ID. Returns the record with all fields.3 params
Get a single record by its ID. Returns the record with all fields.
Parameters* required
base_idstringAirtable base ID
record_idstringRecord ID (e.g., "recXXXXXXXXXXXXXX")
table_id_or_namestringTable ID or name
airtable_create_recordsCreate 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.4 params
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.
Parameters* required
base_idstringAirtable base ID
recordsarrayArray of record objects (max 10). Each: {"fields": {"Name": "value", "Status": "Open"}}
typecastbooleanAuto-convert field values to correct type (default: false)
table_id_or_namestringTable ID or name
airtable_update_recordsUpdate specific fields in one or more records (PATCH — partial update, max 10 per request). Only specified fields are changed; other fields remain untouched.4 params
Update specific fields in one or more records (PATCH — partial update, max 10 per request). Only specified fields are changed; other fields remain untouched.
Parameters* required
base_idstringAirtable base ID
recordsarrayArray of record objects (max 10). Each: {"id": "recXXX", "fields": {"Status": "Done"}}
typecastbooleanAuto-convert field values to correct type (default: false)
table_id_or_namestringTable ID or name
airtable_delete_recordsDelete one or more records by their IDs (max 10 per request). This action is irreversible.3 params
Delete one or more records by their IDs (max 10 per request). This action is irreversible.
Parameters* required
base_idstringAirtable base ID
record_idsarrayArray of record IDs to delete (max 10)
table_id_or_namestringTable ID or name
airtable_upsert_recordsUpdate 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.5 params
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.
Parameters* required
base_idstringAirtable base ID
recordsarrayArray of record objects. Each: {"fields": {"Email": "user@example.com", "Name": "John"}}
typecastbooleanAuto-convert field values to correct type (default: false)
table_id_or_namestringTable ID or name
fields_to_merge_onarrayField names to match existing records on (e.g., ["Email"])
airtable_list_basesList all bases accessible to the authenticated user. Returns base ID, name, and permission level.1 params
List all bases accessible to the authenticated user. Returns base ID, name, and permission level.
Parameters* required
offsetstringPagination token from previous response
airtable_get_base_schemaGet the complete schema of a base — all tables with their fields (name, type, options) and views. Essential for understanding the data structure before querying.1 params
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.
Parameters* required
base_idstringAirtable base ID (e.g., "appXXXXXXXXXXXXXX")
airtable_create_baseCreate a new base in a workspace. Requires at least one table with at least one field.3 params
Create a new base in a workspace. Requires at least one table with at least one field.
Parameters* required
namestringName for the new base
tablesarrayArray of table definitions. Each: {"name": "Tasks", "fields": [{"name": "Name", "type": "singleLineText"}]}
workspace_idstringWorkspace ID (e.g., "wspXXXXXXXXXXXXXX")
airtable_create_tableCreate a new table in a base. Requires at least one field. Field types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, checkbox, email, url, etc.4 params
Create a new table in a base. Requires at least one field. Field types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, checkbox, email, url, etc.
Parameters* required
namestringTable name
fieldsarrayArray of field definitions. Each: {"name": "Status", "type": "singleSelect", "options": {"choices": [{"name": "Open"}]}}
base_idstringAirtable base ID
descriptionstringTable description
airtable_update_tableUpdate a table name or description.4 params
Update a table name or description.
Parameters* required
namestringNew table name
base_idstringAirtable base ID
table_idstringTable ID (e.g., "tblXXXXXXXXXXXXXX")
descriptionstringNew table description
airtable_create_fieldAdd a new field to a table. Common types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, dateTime, checkbox, email, url, multipleAttachments, multipleRecordLinks.6 params
Add a new field to a table. Common types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, dateTime, checkbox, email, url, multipleAttachments, multipleRecordLinks.
Parameters* required
namestringField name
typestringField type (e.g., "singleLineText", "number", "singleSelect")
base_idstringAirtable base ID
optionsobjectField options (e.g., for singleSelect: {"choices": [{"name": "High", "color": "redBright"}]})
table_idstringTable ID
descriptionstringField description
airtable_update_fieldUpdate a field name or description. Cannot change field type.5 params
Update a field name or description. Cannot change field type.
Parameters* required
namestringNew field name
base_idstringAirtable base ID
field_idstringField ID (e.g., "fldXXXXXXXXXXXXXX")
table_idstringTable ID
descriptionstringNew field description
airtable_create_webhookCreate 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.3 params
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.
Parameters* required
base_idstringAirtable base ID
specificationobjectWebhook specification with filters (e.g., {"options": {"filters": {"dataTypes": ["tableData"], "recordChangeScope": "tblXXX"}}})
notification_urlstringHTTPS URL to receive webhook notifications
airtable_list_webhooksList all webhooks for a base. Shows webhook IDs, enabled status, notification URLs, and expiration times.1 params
List all webhooks for a base. Shows webhook IDs, enabled status, notification URLs, and expiration times.
Parameters* required
base_idstringAirtable base ID
airtable_refresh_webhookExtend a webhook expiration time by 7 days from now. Webhooks expire after 7 days — call this periodically to keep them active.2 params
Extend a webhook expiration time by 7 days from now. Webhooks expire after 7 days — call this periodically to keep them active.
Parameters* required
base_idstringAirtable base ID
webhook_idstringWebhook ID (e.g., "achXXXXXXXXXXXXXX")
airtable_list_webhook_payloadsGet pending webhook notification payloads. Returns changed records, fields, and tables since the last cursor position.4 params
Get pending webhook notification payloads. Returns changed records, fields, and tables since the last cursor position.
Parameters* required
limitnumberNumber of payloads to return (1-100, default: 100)
cursornumberCursor position from previous response for pagination
base_idstringAirtable base ID
webhook_idstringWebhook ID
airtable_delete_webhookDelete a webhook. Stops all notifications for this webhook.2 params
Delete a webhook. Stops all notifications for this webhook.
Parameters* required
base_idstringAirtable base ID
webhook_idstringWebhook ID to delete
mcp-airtable
Airtable MCP Pack — wraps the Airtable REST API v0
Part of Pipeworx — an MCP gateway connecting AI agents to 673+ live data sources.
Tools
| Tool | Description |
|---|---|
airtable_list_records | Fetch records from an Airtable table with optional filtering by formula (e.g., "{Status} = 'Done'"). Returns record IDs, field values, and metadata. |
airtable_get_record | Retrieve a single record by ID from an Airtable table. Returns all field values and record metadata. |
airtable_create_record | Add a new record to an Airtable table with specified field values. Returns the created record ID and full record data. |
airtable_list_bases | List all Airtable bases you have access to. Returns base IDs, names, and workspace info. Use to explore available databases. |
airtable_get_base_schema | Get the structure of an Airtable base—all tables, field names, field types, and configurations. Use first to understand available data before querying or creating records. |
Quick Start
Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):
{
"mcpServers": {
"airtable": {
"url": "https://gateway.pipeworx.io/airtable/mcp"
}
}
}
Or connect to the full Pipeworx gateway for access to all 673+ data sources:
{
"mcpServers": {
"pipeworx": {
"url": "https://gateway.pipeworx.io/mcp"
}
}
}
Using with ask_pipeworx
Instead of calling tools directly, you can ask questions in plain English:
ask_pipeworx({ question: "your question about Airtable data" })
The gateway picks the right tool and fills the arguments automatically.
More
License
MIT
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
