Analytics and Data

Airtable

Low-code platform that combines the flexibility of a spreadsheet with the power of a database to build custom workflows and applications.

Airtable MCP, Integrations & Automations for Enterprise AI Agents

Connect your AI agents to Airtable MCP in minutes. No field mapping. No code required. Adopt AI's zero-shot API discovery means your agents understand Airtable's schema on first contact - and can act on it instantly.

Generate MCP URL

What Your AI Agents Can Do

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Airtable Get Record on Airtable

Retrieves a single Airtable record by its record ID (starts with 'rec'). Returns all field values for that record. Use when you know the exact record ID. To search by field value use AIRTABLE_SEARCH_RECORDS.

Airtable Discover Base on Airtable

Lists all accessible Airtable bases and optionally fetches the complete schema for a matching base in one call. Use as a starting point when you don't know the base ID or table structure. Returns base IDs, table names, and field names ready to use in other tools.

Airtable Search Records on Airtable

Searches Airtable records by field value without writing Airtable formula syntax. Automatically builds the filterByFormula string. Use when you need to find records matching a value. For complex filters use AIRTABLE_LIST_RECORDS with filterByFormula directly.

Airtable Find Duplicate Records on Airtable

Scans an Airtable table and identifies records that have duplicate values in a specified field. Returns groups of duplicate records with their IDs and field values. Use for data quality checks and deduplication workflows.

Airtable Create Comment on Airtable

Adds a new comment to an Airtable record. Comments appear in the record's activity feed and can notify collaborators. Use for adding notes, feedback, or status updates to specific records.

Airtable Create Record on Airtable

Creates a single new record in an Airtable table with the provided field values. Returns the created record with its new record ID. For creating multiple records at once use AIRTABLE_CREATE_MULTIPLE_RECORDS.

Airtable List Records on Airtable

Lists records from an Airtable table with optional filtering, sorting, and field selection. Returns up to 100 records per page with an offset for pagination. Use filterByFormula for conditional filtering e.g. '{Status}="Active"'. For fetching ALL records use AIRTABLE_LIST_ALL_RECORDS.

Airtable Update Field on Airtable

Renames a field or updates its description in an Airtable table. Note: field type cannot be changed via API. To change field type, delete and recreate the field. Returns the updated field object.

Airtable Upsert Record on Airtable

Creates a new record OR updates an existing one based on a matching field value. First searches by match_field=match_value, if found updates that record, otherwise creates a new one. Use for data sync workflows where you don't know if a record already exists.

Airtable Update Record on Airtable

Partially updates an existing Airtable record — only the fields you provide are changed, others remain untouched. Use for targeted field updates. For replacing all fields use AIRTABLE_REPLACE_RECORD.

Airtable Create Webhook on Airtable

Creates a webhook subscription for an Airtable base to receive real-time notifications on record changes, table changes, or field changes. Returns a MAC secret for payload verification. Webhooks expire after 7 days — use AIRTABLE_REFRESH_WEBHOOK to extend. Use AIRTABLE_LIST_WEBHOOK_PAYLOADS to retrieve change details.

Airtable Update Multiple Records on Airtable

Partially updates up to 10 records in a single API call. Each record needs an id and fields object with only the fields to change. More efficient than individual updates for batch operations.

Airtable Create Field on Airtable

Adds a new field to an Airtable table. Supported types: singleLineText, multilineText, number, checkbox, singleSelect, multipleSelects, date, dateTime, email, url, phoneNumber, currency, percent, duration, rating, formula, rollup, count, lookup, attachment, multipleRecordLinks, createdTime, lastModifiedTime, autoNumber.

Airtable List Comments on Airtable

Lists all comments on a specific Airtable record with author info, text content, and timestamps. Returns newest comments first. Use to review discussion and feedback on a record before adding your own comment.

Airtable List All Records on Airtable

Retrieves ALL records from an Airtable table by automatically handling pagination with offset. Returns complete dataset. Use when you need every record in a table. For large tables this may make multiple API calls. For partial fetching with control use AIRTABLE_LIST_RECORDS.

Airtable Filter By Formula on Airtable

Filters Airtable records using a raw Airtable formula for advanced queries. Supports all Airtable formula functions. Examples: 'AND({Status}="Active",{Priority}="High")' or 'IS_AFTER({Date},TODAY())'. For simple field matching use AIRTABLE_SEARCH_RECORDS instead.

Airtable List Bases on Airtable

Lists all Airtable bases accessible to the authenticated user with base IDs, names, and permission levels. Use this as a discovery tool before working with specific bases — you need the base ID for most other operations. Returns bases paginated with offset.

Airtable Delete Webhook on Airtable

Permanently removes a webhook subscription from an Airtable base. The webhook will stop sending notifications immediately. Returns empty response on success.

Airtable Update Comment on Airtable

Edits the text of an existing comment on an Airtable record. Only the comment author can edit their own comments. Returns the updated comment object with revised text.

Airtable Sync Records From Csv on Airtable

Imports records from CSV-formatted data into an Airtable table. Automatically parses the CSV, maps columns to fields, and creates or upserts records in batches of 10. Handles rate limiting automatically. Use for bulk data imports from spreadsheets or external systems.

Airtable Update Table on Airtable

Renames an existing Airtable table or updates its description. Requires the table ID from AIRTABLE_GET_BASE_SCHEMA. Only name and description can be changed — to modify fields use AIRTABLE_UPDATE_FIELD.

Airtable Delete Multiple Records on Airtable

Permanently deletes up to 10 records in one API call. Pass an array of record IDs. More efficient than individual deletes. This action is irreversible — deleted records cannot be recovered via API.

Airtable Get Table Records Summary on Airtable

Returns a human-readable summary of an Airtable table including field names, types, and a sample of records. Combines schema and record data in one call. Use when you want to understand a table's structure and data at a glance before performing operations.

Airtable Get Current User on Airtable

Returns the authenticated user's Airtable ID, email, and the permission scopes granted to the current token. Use at session start to verify authentication and check which operations are permitted with the current token's scopes.

Airtable List Webhook Payloads on Airtable

Retrieves change notification payloads from an Airtable webhook cursor. Use after receiving a webhook ping to get the actual change details. Always pass the returned cursor in the next call to avoid reprocessing the same payloads.

Airtable List Workspace Collaborators on Airtable

Returns all members and collaborators in an Airtable workspace with their roles and permission levels. Use for workspace access management and onboarding/offboarding workflows.

Airtable Create Base on Airtable

Creates a new Airtable base in the specified workspace with initial tables and field definitions. Returns the new base ID. Field types supported: singleLineText, multilineText, number, checkbox, singleSelect, multipleSelects, date, email, url, phoneNumber, currency, percent.

Airtable Refresh Webhook on Airtable

Extends an Airtable webhook's expiration by 7 days from now. Webhooks expire after 7 days without refresh and stop sending notifications. Set up a daily schedule to call this and prevent webhook expiration.

Airtable List Base Collaborators on Airtable

Returns all collaborators with access to an Airtable base including their user IDs, names, emails, and permission levels (owner, create, editor, commenter, read). Use for access audits and understanding who can modify base data.

Airtable Copy Records To Table on Airtable

Copies records from one Airtable table to another, optionally filtering which records to copy and remapping field names. Handles pagination for large tables. Use for data migration, backup, or cross-base sync workflows.

Airtable Replace Record on Airtable

Fully replaces an Airtable record — ALL fields not included in the request will be cleared/emptied. Use only when you intend to reset the entire record. For partial updates use AIRTABLE_UPDATE_RECORD.

Airtable Delete Comment on Airtable

Permanently deletes a comment from an Airtable record. Only the comment author can delete their own comments. This action is irreversible. Use to remove outdated or incorrect comments.

Airtable Count Records By Field on Airtable

Counts how many records have each unique value for a specified field. Returns {value: count} object. Example: {Active: 45, Inactive: 12, Pending: 8}. Use for quick analytics and status summaries without exporting data.

Airtable Delete Record on Airtable

Permanently deletes a single record from an Airtable table. This action is irreversible. Returns the deleted record ID and deleted=true. For deleting multiple records use AIRTABLE_DELETE_MULTIPLE_RECORDS.

Airtable Get Base Schema on Airtable

Returns the complete schema of an Airtable base including all tables, their fields with types and options, views, and primary field. Use before creating or querying records to understand the base structure. Essential for knowing available field names and types.

Airtable Create Multiple Records on Airtable

Creates up to 10 records in a single API call. More efficient than calling AIRTABLE_CREATE_RECORD multiple times. Each record needs a fields object. Returns array of created records with their IDs.

Airtable Create Table on Airtable

Creates a new table in an existing Airtable base with specified fields. Returns the new table ID. Every table automatically gets a primary Name field. Additional fields must specify type and options. Use AIRTABLE_GET_BASE_SCHEMA first to check existing tables.

Airtable Archive Old Records on Airtable

Finds records older than a specified number of days based on a date field and either marks them as archived (sets a boolean field) or deletes them. Use for automated data lifecycle management and keeping active tables clean.

Airtable List Base Shares on Airtable

Lists all public share links and shared views for an Airtable base with their share IDs, types, and URLs. Use to audit what data is publicly accessible and manage sharing settings.

Airtable List Webhooks on Airtable

Lists all webhooks registered for an Airtable base including webhook IDs, endpoint URLs, event types, and expiration dates. Webhooks expire after 7 days without refresh. Use to audit or manage existing webhook subscriptions.

Airtable Bulk Upsert Records on Airtable

Creates or updates multiple records based on a matching field. For each record, searches by match_field value — updates if found, creates if not. Handles batching and rate limiting automatically. Use for syncing external data into Airtable without creating duplicates.

Airtable Get Records By View on Airtable

Retrieves records as displayed in a specific Airtable view, preserving that view's filters, sort order, and hidden fields. Use when you want records filtered exactly as a particular view shows them. Views include Grid, Gallery, Kanban, Calendar, Gantt views.

Airtable Get Records Grouped By Field on Airtable

Retrieves all records from a table and returns them grouped by a specified field value as a dictionary. Useful for organizing data like {status: [records], priority: [records]}. Great for generating summaries and dashboards without complex formulas.

Connect Airtable MCP using Adopt AI in 3 Simple Steps

Run a single command in your terminal to install the Airtable MCP server locally, no complex setup, no cloud dependency.
A browser window opens automatically, where you can securely authenticate with your Airtable account with one click.
Restart your AI client, and your agents instantly have full access to bases, tables, records, and every Airtable object, ready to read, write, and automate.

Use Cases for Airtable MCP

1. Automated Data Entry & Enrichment

AI agents automatically populate Airtable records with data from connected apps, enrich entries with additional context, and keep everything up to date.

2. Custom Workflow Automation

Build automated workflows triggered by Airtable record changes � AI agents can send notifications, update linked records, and sync data across tools.

3. Content Calendar Management

AI agents manage editorial calendars in Airtable, tracking content status, assigning writers, and coordinating publication schedules across channels.

4. Inventory & Asset Tracking

AI agents monitor Airtable inventory bases, flag low stock levels, auto-generate purchase orders, and sync quantities with e-commerce platforms.

5. Reporting & Dashboard Generation

AI agents aggregate data from Airtable bases to generate summary reports, trend analyses, and visual dashboards for leadership review.

Explore Other Apps

Frequently Asked Questions

Do I need my own developer credentials to use Airtable MCP with Adopt AI?

No, you can get started immediately using Adopt AI's built-in Airtable integration. For production use, we recommend configuring your own API credentials for greater control and security.

‍

Can I connect Airtable with other apps through Adopt AI?

Yes! Adopt AI supports multi-app workflows, so your AI agents can seamlessly move data between Airtable and CRMs, spreadsheets, messaging platforms, and more.

‍

Is Adopt AI secure?

Absolutely. Adopt AI is SOC 2 Type 2 certified and ISO/IEC 27001 compliant, and adheres to EU GDPR, CCPA, and HIPAA standards. All data is encrypted in transit and at rest, ensuring the confidentiality, integrity, and availability of your data. Learn more here.

‍

What happens if the Airtable API changes?

Adopt AI maintains and updates all integrations automatically, so your agents always work with the latest API versions, no manual maintenance required.

‍

Do I need coding skills to set up the Airtable integration?

Not at all. Adopt AI's zero-shot API discovery means your agents understand Airtable's schema on first contact. Setup takes minutes with no code required.

‍

How do I set up custom Airtable MCP in Adopt AI?

For a step-by-step guide on creating and configuring your own Airtable API credentials with Adopt AI, see here.