Summary
The Airtable MCP Server provides read and write access to Airtable databases through the Model Context Protocol, enabling LLMs to inspect database schemas and perform CRUD operations on records. It exposes tools for querying and modifying Airtable bases after authenticating with a personal access token, solving the problem of integrating Airtable data directly into AI workflows without manual data transfer. The server supports multiple client implementations including Claude Desktop, Cursor, and Cline, with flexible installation options ranging from browser extensions to manual configuration.
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 →
Connect Claude to +800M contacts, +150M companies. Find & Enrich leads in chat.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →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
airtable-mcp-server
A Model Context Protocol server that provides read and write access to Airtable databases. This server enables LLMs to inspect database schemas, then read and write records.
https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944
Installation
Step 1: Create an Airtable personal access token by clicking here. Details:
- Name: Anything you want e.g. 'Airtable MCP Server Token'.
- Scopes:
schema.bases:read,data.records:read, and optionallyschema.bases:write,data.records:write,data.recordComments:read, anddata.recordComments:write. - Access: The bases you want to access. If you're not sure, select 'Add all resources'.
Keep the token handy, you'll need it in the next step. It should look something like pat123.abc123 (but longer).
Step 2: Follow the instructions below for your preferred client:
Claude Desktop
(Recommended) Via the extensions browser
- Open Claude Desktop and go to Settings → Extensions
- Click 'Browse Extensions' and find 'Airtable MCP Server'
- Click 'Install' and paste in your API key
(Advanced) Alternative: Via manual .mcpb installation
- Find the latest mcpb build in the GitHub Actions history (the top one)
- In the 'Artifacts' section, download the
airtable-mcp-server-mcpbfile - Rename the
.zipfile to.mcpb - Double-click the
.mcpbfile to open with Claude Desktop - Click "Install" and configure with your API key
(Advanced) Alternative: Via JSON configuration
- Install Node.js
- Open Claude Desktop and go to Settings → Developer
- Click "Edit Config" to open your
claude_desktop_config.jsonfile - Add the following configuration to the "mcpServers" section, replacing
pat123.abc123with your API key:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}
- Save the file and restart Claude Desktop
Cursor
(Recommended) Via one-click install
- Click
- Edit your
mcp.jsonfile to insert your API key
(Advanced) Alternative: Via JSON configuration
Create either a global (~/.cursor/mcp.json) or project-specific (.cursor/mcp.json) configuration file, replacing pat123.abc123 with your API key:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}
Cline
(Recommended) Via marketplace
- Click the "MCP Servers" icon in the Cline extension
- Search for "Airtable" and click "Install"
- Follow the prompts to install the server
(Advanced) Alternative: Via JSON configuration
- Click the "MCP Servers" icon in the Cline extension
- Click on the "Installed" tab, then the "Configure MCP Servers" button at the bottom
- Add the following configuration to the "mcpServers" section, replacing
pat123.abc123with your API key:
{
"mcpServers": {
"airtable": {
"type": "stdio",
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}
Components
Tools
-
list_records
- Lists records from a specified Airtable table
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the table to querymaxRecords(number, optional): Maximum number of records to return. Defaults to 100.filterByFormula(string, optional): Airtable formula to filter records
-
search_records
- Search for records containing specific text
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the table to querysearchTerm(string, required): Text to search for in recordsfieldIds(array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.maxRecords(number, optional): Maximum number of records to return. Defaults to 100.
-
list_bases
- Lists all accessible Airtable bases
- No input parameters required
- Returns base ID, name, and permission level
-
list_tables
- Lists all tables in a specific base
- Input parameters:
baseId(string, required): The ID of the Airtable basedetailLevel(string, optional): The amount of detail to get about the tables (tableIdentifiersOnly,identifiersOnly, orfull)
- Returns table ID, name, description, fields, and views (to the given
detailLevel)
-
describe_table
- Gets detailed information about a specific table
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the table to describedetailLevel(string, optional): The amount of detail to get about the table (tableIdentifiersOnly,identifiersOnly, orfull)
- Returns the same format as list_tables but for a single table
- Useful for getting details about a specific table without fetching information about all tables in the base
-
get_record
- Gets a specific record by ID
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablerecordId(string, required): The ID of the record to retrieve
-
create_record
- Creates a new record in a table
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablefields(object, required): The fields and values for the new record
-
update_records
- Updates one or more records in a table
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablerecords(array, required): Array of objects containing record ID and fields to update
-
delete_records
- Deletes one or more records from a table
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablerecordIds(array, required): Array of record IDs to delete
-
create_table
- Creates a new table in a base
- Input parameters:
baseId(string, required): The ID of the Airtable basename(string, required): Name of the new tabledescription(string, optional): Description of the tablefields(array, required): Array of field definitions (name, type, description, options)
-
update_table
- Updates a table's name or description
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablename(string, optional): New name for the tabledescription(string, optional): New description for the table
-
create_field
- Creates a new field in a table
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablename(string, required): Name of the new fieldtype(string, required): Type of the fielddescription(string, optional): Description of the fieldoptions(object, optional): Field-specific options
-
update_field
- Updates a field's name or description
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablefieldId(string, required): The ID of the fieldname(string, optional): New name for the fielddescription(string, optional): New description for the field
-
create_comment
- Creates a comment on a record
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablerecordId(string, required): The ID of the recordtext(string, required): The comment textparentCommentId(string, optional): Parent comment ID for threaded replies
- Returns the created comment with ID, author, creation time, and text
-
list_comments
- Lists comments on a record
- Input parameters:
baseId(string, required): The ID of the Airtable basetableId(string, required): The ID of the tablerecordId(string, required): The ID of the recordpageSize(number, optional): Number of comments to return (max 100, default 100)offset(string, optional): Pagination offset for retrieving additional comments
- Returns comments array with author, text, timestamps, reactions, and mentions
- Comments are returned from newest to oldest
HTTP Transport
The server can also run in HTTP mode for use with remote MCP clients:
MCP_TRANSPORT=http PORT=3000 npx airtable-mcp-server
This starts a stateless HTTP server at http://localhost:3000/mcp. Note: HTTP transport has no built-in authentication - only use behind a reverse proxy or in a secured environment.
Contributing
Pull requests are welcomed on GitHub! To get started:
- Install Git and Node.js
- Clone the repository
- Install dependencies with
npm install - Run
npm run testto run tests - Build with
npm run build
- You can use
npm run build:watchto automatically build after editingsrc/index.ts. This means you can hit save, reload Claude Desktop (with Ctrl/Cmd+R), and the changes apply.
Releases
Versions follow the semantic versioning spec.
To release:
- Use
npm version <major | minor | patch>to bump the version - Run
git push --follow-tagsto push with tags - Wait for GitHub Actions to publish to the NPM registry.
Featured
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 →Connect Claude to +800M contacts, +150M companies. Find & Enrich leads in chat.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Configuration
AIRTABLE_API_KEY*secretAirtable personal access token (e.g., pat123.abc123). Create at https://airtable.com/create/tokens/new with scopes: schema.bases:read, data.records:read, and optionally schema.bases:write and data.records:write.
Categories
Registryactive
Packageairtable-mcp-server
TransportSTDIO
AuthRequired
UpdatedMar 7, 2026
