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.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →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
base_idstringAirtable base ID (e.g., "appXXXXXXXXXXXXXX")
fieldsarrayArray of field names to include in the response
filter_by_formulastringAirtable formula to filter records (e.g., "{Status}='Active'")
max_recordsnumberMaximum total records to return
offsetstringPagination token from previous response
page_sizenumberNumber of records per page (1-100, default: 100)
sortarrayArray of sort objects: [{"field": "Name", "direction": "asc"}]
table_id_or_namestringTable ID (e.g., "tblXXX") or table name (e.g., "Tasks")
viewstringView name or ID to use for pre-filtering
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"}}
table_id_or_namestringTable ID or name
typecastbooleanAuto-convert field values to correct type (default: false)
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"}}
table_id_or_namestringTable ID or name
typecastbooleanAuto-convert field values to correct type (default: false)
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
fields_to_merge_onarrayField names to match existing records on (e.g., ["Email"])
recordsarrayArray of record objects. Each: {"fields": {"Email": "user@example.com", "Name": "John"}}
table_id_or_namestringTable ID or name
typecastbooleanAuto-convert field values to correct type (default: false)
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
base_idstringAirtable base ID
descriptionstringTable description
fieldsarrayArray of field definitions. Each: {"name": "Status", "type": "singleSelect", "options": {"choices": [{"name": "Open"}]}}
namestringTable name
airtable_update_tableUpdate a table name or description.4 params
Update a table name or description.
Parameters* required
base_idstringAirtable base ID
descriptionstringNew table description
namestringNew table name
table_idstringTable ID (e.g., "tblXXXXXXXXXXXXXX")
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
base_idstringAirtable base ID
descriptionstringField description
namestringField name
optionsobjectField options (e.g., for singleSelect: {"choices": [{"name": "High", "color": "redBright"}]})
table_idstringTable ID
typestringField type (e.g., "singleLineText", "number", "singleSelect")
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
base_idstringAirtable base ID
descriptionstringNew field description
field_idstringField ID (e.g., "fldXXXXXXXXXXXXXX")
namestringNew field name
table_idstringTable ID
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
notification_urlstringHTTPS URL to receive webhook notifications
specificationobjectWebhook specification with filters (e.g., {"options": {"filters": {"dataTypes": ["tableData"], "recordChangeScope": "tblXXX"}}})
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
base_idstringAirtable base ID
cursornumberCursor position from previous response for pagination
limitnumberNumber of payloads to return (1-100, default: 100)
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 1476+ 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 | Fetch a single Airtable record by its record ID (recXXXXXXXXXXXX) from a specified base and table. Returns all field values and record metadata including created/modified timestamps. |
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 the provided personal access token can access. Returns base IDs, names, and workspace info — use to discover baseId values needed by other airtable tools. |
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"
}
}
}
What this endpoint actually serves
tools/list at https://gateway.pipeworx.io/airtable/mcp returns the tools in the table
above plus the shared Pipeworx meta-tools — ask_pipeworx,
discover_tools, search_within, remember/recall and the rest of the
gateway-wide set. So the tool count you see is larger than this table: a
single-pack endpoint currently lists roughly 30 shared tools alongside the
pack's own. The connection's initialize response states its exact scope, and
is the authoritative answer for a given day.
This is deliberate, not multiplexing by accident. The meta-tools are what let a
scoped connection answer a question this pack does not cover — via
ask_pipeworx, which routes across the whole catalog — without you adding a
second MCP server. There is currently no way to mount a pack endpoint without
them; if the extra schemas cost you more context than the routing is worth,
connect to the full gateway once rather than to several pack endpoints.
Or connect to the full Pipeworx gateway to get every pack's tools listed directly, instead of just this one's:
{
"mcpServers": {
"pipeworx": {
"url": "https://gateway.pipeworx.io/mcp"
}
}
}
Both URLs reach the same gateway and the same 1476+ data sources. The
only difference is which pack's tools are listed directly; ask_pipeworx
reaches all of them from either one.
Using with ask_pipeworx
Instead of calling tools directly, you can ask questions in plain English — this works on the pack endpoint above as well as on the full gateway:
ask_pipeworx({ question: "your question about Airtable data" })
The gateway picks the right tool and fills the arguments automatically.
More
License
MIT
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
