Airtable MCP server

Connect Airtable to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Airtable MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the upsert records tool in Airtable
  • Use the list bases tool in Airtable
  • Use the manage field tool in Airtable
  • Use the get base schema tool in Airtable
  • Use the list records tool in Airtable
  • Use the manage comment tool in Airtable

Supported Tools

upsert_records

Upsert Records

Find, create, or update records in a single operation. Records are matched using the specified merge fields. If a matching record is found it will be updated; otherwise a new record is created. This is useful for syncing data from external sources.

list_bases

List Bases

List all Airtable bases the authenticated user has access to. Useful for discovering available bases and their IDs.

manage_field

Manage Field

Create a new field or update an existing field in a table within the specified Airtable base. Airtable's metadata API requires table and field IDs for this operation.

get_base_schema

Get Base Schema

Retrieve the full schema of the specified Airtable base, including all tables, their fields (with types and options), and views. Useful for understanding the structure of a base before querying or modifying data.

list_records

List Records

List records from a table in the specified Airtable base. Supports filtering with Airtable formulas, sorting by fields, scoping to a specific view, selecting specific fields, and pagination.

manage_comment

Manage Comment

List, create, update, or delete comments on a record in the specified Airtable base. Use this to read the conversation thread on a record or add new comments.

get_record

Get Record

Retrieve a single record by its ID from a table in the specified Airtable base. Returns all field values for the specified record.

update_records

Update Records

Update one or more existing records in a table in the specified Airtable base. By default performs a partial update (PATCH) that only modifies specified fields. Set **replaceAllFields** to true to perform a full replacement (PUT) which clears unspecified fields.

create_records

Create Records

Create one or more records in a table in the specified Airtable base. Provide field values for each record. Enable typecast to automatically convert string values to the appropriate field types.

manage_table

Manage Table

Create a new table or update an existing table in the specified Airtable base. When creating, provide the table name and initial fields. When updating, provide the table ID and new name or description.

delete_records

Delete Records

Delete one or more records from a table in the specified Airtable base. This action is **irreversible** and permanently removes the specified records.

upload_attachment

Upload Attachment

Upload a base64-encoded file directly into an Airtable attachment field on an existing record.

Connect Airtable to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Airtable in Metorial. In your Metorial portal, enable the Airtable MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Airtable tools.

Run Airtable through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Airtable and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Airtable tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Airtable

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Microsoft Outlook

Send, read, reply to, forward, and manage email messages in user mailboxes. Organize messages into folders, apply categories, flags, and importance levels. Manage file and item attachments. Create, update, delete, and respond to calendar events and meetings. Find available meeting times, manage attendees, handle recurrence, and work with shared or delegated calendars. Create, read, update, and delete contacts, organize them into contact folders, and manage contact photos. Manage tasks and task lists via Microsoft To Do, including due dates, reminders, recurrence, and checklist items. Subscribe to webhook notifications for changes to messages, calendar events, and contacts. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Linear

Create, read, update, and delete issues across teams with support for priorities, labels, assignees, due dates, and workflow states. Manage projects that group related issues, and organize work into time-boxed cycles (sprints). Create and manage documents, comments, and file attachments. Search issues using vector similarity or rich filters. Configure teams, workflow states, and labels. Track customers and link them to issues.

Technical notes for Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Frequently asked questions

Common questions about connecting Airtable to AI agents with Metorial.

  1. How many tools does the Airtable MCP server have?
    The Airtable MCP server exposes 12 tools, including Upsert Records, List Bases, Manage Field. Each one is governed and traced through Metorial.
  2. Airtable exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Airtable MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Airtable and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Airtable MCP server yourself or use the hosted gateway.

Connect Airtable to production AI agents

See how Metorial gives your team governed access to Airtable, with tracing and security controls built in.