Loading...
Airtable MCP server enables natural language interaction with Airtable data, offering CRUD operations, schema management, webhooks, and AI-powered analytics, secured with governance controls.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
Airtable MCP server enables natural language interaction with Airtable data, offering CRUD operations, schema management, webhooks, and AI-powered analytics, secured with governance controls.
The Airtable MCP server offers extensive functionality but requires careful configuration to mitigate risks. It is relatively safe for read-only operations and data analysis. Risky operations like deleting records or modifying schemas should be carefully reviewed and governed.
Performance depends on Airtable API limits and network latency. Batch operations are recommended for improved efficiency. Consider caching frequently accessed data.
Airtable charges based on API usage and storage. Monitor API call volume and data storage to avoid unexpected costs. AI features may incur additional costs.
npm install -g @rashidazarang/airtable-mcp{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "@rashidazarang/airtable-mcp"],
"env": {
"AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
"AIRTABLE_BASE_ID": "YOUR_BASE_ID"
}
}
}
}MCP_HTTP_PORTlist_basesLists all accessible Airtable bases with associated permissions.
Read-only operation, no data modification.
describeDescribes the schema of a specified Airtable base or table.
Read-only operation, no data modification.
queryQueries records from an Airtable table based on specified filters and sorting.
Read-only operation, no data modification.
search_recordsPerforms an advanced search for records using Airtable formulas.
Read-only operation, no data modification.
list_recordsLists records from an Airtable table with field selection and pagination.
Read-only operation, no data modification.
get_recordRetrieves a single record from an Airtable table by its ID.
Read-only operation, no data modification.
createCreates a new record in an Airtable table.
Creates new data, requires dryRun diff review.
updateUpdates an existing record in an Airtable table.
Modifies existing data, requires dryRun diff review.
delete_recordDeletes a record from an Airtable table.
Destructive operation, permanently removes data.
upsertUpdates or creates records based on merge fields.
Modifies or creates data based on merge conditions.
batch_upsert_recordsPerforms batch upsert operations with merge-on fields.
Batch modification or creation of data based on merge conditions.
list_tablesRetrieves all tables within a specified Airtable base, including schema information.
Read-only operation, no data modification.
get_base_schemaRetrieves the complete schema for a specified Airtable base.
Read-only operation, no data modification.
list_field_typesProvides a reference guide for available field types in Airtable.
Read-only operation, no data modification.
get_table_viewsLists all views associated with a specified table.
Read-only operation, no data modification.
create_tableCreates a new table within an Airtable base with custom field definitions.
Modifies the structure of the Airtable base.
update_tableModifies the name and description of an existing table.
Modifies the structure of the Airtable base.
delete_tableDeletes a table from an Airtable base.
Destructive operation, permanently removes a table.
create_fieldAdds a new field to an existing table.
Modifies the structure of the Airtable base.
update_fieldModifies the properties and options of an existing field.
Modifies the structure of the Airtable base.
delete_fieldDeletes a field from an Airtable table.
Destructive operation, permanently removes a field.
batch_create_recordsCreates up to 10 records at once in a specified table.
Creates new data in batches.
batch_update_recordsUpdates up to 10 records simultaneously in a specified table.
Modifies existing data in batches.
batch_delete_recordsDeletes up to 10 records in one operation from a specified table.
Destructive operation, permanently removes multiple records.
list_webhooksLists all configured webhooks in the Airtable base.
Read-only operation, no data modification.
create_webhookSets up real-time notifications for changes in the Airtable base.
Creates a webhook that can trigger external actions.
delete_webhookRemoves a webhook configuration from the Airtable base.
Removes a webhook configuration.
get_webhook_payloadsRetrieves the notification history for a specified webhook.
Read-only operation, no data modification.
refresh_webhookExtends the expiration of a specified webhook.
Modifies the expiration of a webhook.
create_viewCreates a new view (grid, form, calendar, etc.) in a specified table.
Creates a new view.
get_view_metadataRetrieves metadata for a specified view, including filters.
Read-only operation, no data modification.
upload_attachmentAttaches files from URLs to a specified record.
Uploads attachments to a record.
create_baseCreates a new Airtable base with an initial structure.
Creates a new Airtable base.
list_collaboratorsLists collaborators and their permissions for a specified Airtable base.
Read-only operation, no data modification.
list_sharesLists shared views and configurations for a specified Airtable base.
Read-only operation, no data modification.
list_commentsLists comments on a specified record.
Read-only operation, no data modification.
create_commentAdds a new comment to a specified record.
Adds a new comment.
update_commentEdits an existing comment on a specified record.
Modifies an existing comment.
delete_commentDeletes a comment from a specified record.
Deletes a comment.
whoamiRetrieves the current user's identity and scopes.
Read-only operation, no data modification.
list_governanceReturns governance allow-lists and PII masking policies.
Read-only operation, no data modification.
list_exceptionsLists recent exceptions and remediation proposals.
Read-only operation, no data modification.
API Key
cloud
data.records:readdata.records:writedata.recordComments:readdata.recordComments:writeschema.bases:readschema.bases:writeuser.email:readwebhook:manageThe Airtable MCP server offers extensive functionality but requires careful configuration to mitigate risks. It is relatively safe for read-only operations and data analysis. Risky operations like deleting records or modifying schemas should be carefully reviewed and governed.
Autonomy is configurable but defaults to requiring dry-run review for destructive operations. Rollback is not natively supported; implement data backups for critical bases.
Production Tip
Implement robust error handling and monitoring to ensure data integrity and system stability.
The token needs data.records:read, data.records:write, data.recordComments:read, data.recordComments:write, schema.bases:read, schema.bases:write, user.email:read, and optionally webhook:manage.
The Base ID is in the URL when viewing your base: https://airtable.com/[BASE_ID]/...
Use PII masking and governance controls. Avoid storing highly sensitive data in Airtable without encryption.
Yes, the server supports multi-base discovery and operation.
Set the LOG_LEVEL environment variable to 'debug'.
Yes, with the `webhook:manage` scope, you can create and manage webhooks.
Fork the repository on GitHub and submit a pull request with your changes.