Airtable
MCP server for Airtable API — manage records, bases, tables, fields, and webhooks.
Community: Submitted by a user or imported; check the owner before granting accessOnlineAPI key requiredGlobalFreeCan modify data
What it can do
- Airtable List Records: 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
- Airtable Get Record: Get a single record by its ID. Returns the record with all fields.
- Airtable Create Records: 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 corr
What data it sees
Do you need an account
An API key from the service settings is required
MCP server for Airtable API — manage records, bases, tables, fields, and webhooks.
Features
- Full CRUD for records with filtering, sorting, and pagination
- Upsert records (update-or-create by matching fields)
- Base and table schema management (create tables, add fields)
- Webhook lifecycle (create, list, refresh, payloads, delete)
- Batch operations (up to 10 records per request)
18 Tools
Records: list, get, create, update, delete, upsert Bases & Schema: list bases, get schema, create base, create table, update table, create field, update field Webhooks: create, list, refresh, list payloads, delete
Configuration
- AIRTABLE_PAT — Personal Access Token from https://airtable.com/create/tokens
Server tool list (18)
Raw names from tools/list. Only developers need these.
| airtable_list_records | 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. |
| airtable_get_record | Get a single record by its ID. Returns the record with all fields. |
| airtable_create_records | 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. |
| airtable_update_records | Update specific fields in one or more records (PATCH — partial update, max 10 per request). Only specified fields are changed; other fields remain untouched. |
| airtable_delete_records | Delete one or more records by their IDs (max 10 per request). This action is irreversible. |
| airtable_upsert_records | 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. |
| airtable_list_bases | List all bases accessible to the authenticated user. Returns base ID, name, and permission level. |
| airtable_get_base_schema | 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. |
| airtable_create_base | Create a new base in a workspace. Requires at least one table with at least one field. |
| airtable_create_table | Create a new table in a base. Requires at least one field. Field types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, checkbox, email, url, etc. |
| airtable_update_table | Update a table name or description. |
| airtable_create_field | Add a new field to a table. Common types: singleLineText, multilineText, number, singleSelect, multipleSelects, date, dateTime, checkbox, email, url, multipleAttachments, multipleRecordLinks. |
| airtable_update_field | Update a field name or description. Cannot change field type. |
| airtable_create_webhook | 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. |
| airtable_list_webhooks | List all webhooks for a base. Shows webhook IDs, enabled status, notification URLs, and expiration times. |
| airtable_refresh_webhook | Extend a webhook expiration time by 7 days from now. Webhooks expire after 7 days — call this periodically to keep them active. |
| airtable_list_webhook_payloads | Get pending webhook notification payloads. Returns changed records, fields, and tables since the last cursor position. |
| airtable_delete_webhook | Delete a webhook. Stops all notifications for this webhook. |