Airtable MCP

Airtable

AI

13 minutes

Airtable MCP: connect ChatGPT, Claude and your AI agents in 2026

Airtable now has an official MCP server that allows ChatGPT, Claude, and other compatible assistants to interact directly with your bases. It is no longer just used to search for or modify records: since 2026, an agent can also understand your schema, create tables and fields, build Interface pages, and set up automations. The potential is significant, but MCP does not replace a good Airtable architecture, automations, or the API. The main challenge is understanding what should actually be delegated to AI — and what is better kept deterministic.

Nadir BOUSSETTA

Updated on

LinkedIn

What is the Airtable MCP Server?

MCP, which stands for Model Context Protocol, is a standard that allows an AI assistant to access data and actions exposed by a software application.

In the case of Airtable, how it works can be summarized like this:

ChatGPT / Claude / AI agent → Airtable MCP server → your Airtable base

The assistant can discover the bases you have access to, understand their tables and fields, search for records, and then use authorized actions.

The benefit is different from a traditional API. With an API, a developer defines precisely which queries need to be executed. With MCP, you can simply ask:

Which projects are late this week and require action from me?

The assistant then determines on its own which Airtable tools are needed to respond.

Airtable now maintains its own official server at this address:

https://mcp.airtable.com/mcp
https://mcp.airtable.com/mcp
https://mcp.airtable.com/mcp

The server is included in Airtable plans at no extra charge, although its use remains subject to the platform's usual limits. Airtable significantly expanded its capabilities in August 2026 to allow assistants to build not only the data, but also parts of the application itself.

What Airtable MCP Can Actually Do in 2026

The MCP server is now much more than just a read layer.

Capability

Airtable MCP

Discover bases, tables, and fields

Read and filter records

Create and modify records

Create tables and fields

Understand relationships between tables

Create Interface pages

Publish Interface pages

Modify an existing Interface

❌ currently

Create automations

Read and draft automation changes

Create or modify a "Run a script" action

❌ currently

Turn on a new automation

❌ from MCP

The difference compared to the early versions of the server is significant.

An assistant can now start from a relatively broad prompt such as:

Create a project tracking tool for me with Clients, Projects, Tasks, and Collaborators. Each client can have multiple projects, and each task must have an owner.

It can create the necessary tables, relationships, and fields.

Airtable also notes that field creation is schema-aware: the agent can understand existing relationships to correctly build fields like lookups, counts, or rollups.

But there is an essential nuance:

Being able to build an architecture does not mean being able to automatically choose the best architecture.

The AI can go in the wrong direction very quickly as well.

Building a First Version of a Base with AI

This is probably one of the most impressive use cases of MCP.

Instead of manually creating:

  • tables;

  • fields;

  • relationships;

  • certain rollups;

  • the initial records;

you can simply describe the desired system.

For example:

I want to manage my media campaigns. A campaign belongs to a client and has several media plan lines. Each line can generate multiple deliverables. Create a simple Airtable structure to track the campaign from planning to delivery.

The agent can build an initial structure and then let you adjust it.

But this is precisely where we must remain pragmatic.

A business system is not just a collection of tables. You have to decide:

  • which entities actually deserve a table;

  • which details can remain as fields;

  • which relationships are necessary;

  • which statuses accurately reflect the business process;

  • which data needs to be calculated;

  • which information should be visible to each user.

An AI can significantly speed up the execution of these decisions. It does not necessarily exempt you from making them.

This is the same logic as Omni, which we detail in our guide on Airtable and AI.

Creating Airtable Interfaces from Claude or ChatGPT

Perhaps the most interesting new feature is MCP's ability to build the user layer.

An assistant can now create Interface pages based on the existing system. Airtable itself gives the example of a marketing calendar from which the agent then builds a dashboard with Calendar, Kanban, and Timeline views.

You could therefore ask:

Create an Interface for project managers with a home page, their active projects, their overdue tasks, and approvals that require their attention.

This is very powerful for speeding up a first version.

But the same UX principles still apply.

An automatically generated Interface should not simply replicate tables. It must still be designed by role, display only useful information, and limit available actions to what the user actually needs.

Another important limitation to keep in mind: Airtable currently states that MCP cannot modify an existing Interface page. It can create pages and manage their publication cycle, but editing an already built page must still be done within Airtable.

We detail these design principles in our Airtable Interfaces guide.

Building Airtable Automations with MCP

MCP can also build and manage a portion of your automations.

For example, you can ask:

When a new form is submitted, check the request priority, assign an owner, and notify the correct Slack channel.

The agent can configure the trigger, actions, dynamic data, conditional groups, and even repeating groups.

Airtable currently fully supports several common triggers via MCP: record created or updated, conditions met, scheduled time, form submitted, or entering a view. Fully supported actions include Create record, Update record, Find records, email, Slack, and structured AI generation actions.

An Important Safeguard: The Automation Starts Turned Off

A new automation created via MCP starts paused.

The agent builds the scenario, then provides you with access to review it in Airtable before turning it on.

I find this approach highly sensible:

AI builds → human reviews → Airtable executes.

On an already active automation, MCP can also draft changes, but these do not immediately replace the version currently in production.

"Run a Script" Remains a Limitation

As of today, MCP cannot create or modify a custom Run a script action.

This is important because scripts remain necessary for advanced logic, API calls, or JavaScript transformations.

The workflow may therefore look like this:

MCP builds 80% of the automation → the builder manually adds the necessary script → test → activate.

Our guide on Airtable automation explains exactly when to stay native, when to write a script, and when to use Make, n8n, or an API.

Airtable Skills: Teaching the Agent How to Build Properly

The second major update concerns Skills.

Airtable now offers a library of skills that agents can use. Some teach them the fundamental principles of the platform, such as airtable-overview or airtable-filters.

Others are business-oriented:

  • sales-ops;

  • marketing-ops;

  • product-ops.

The objective is interesting.

Instead of only giving the AI the technical tools to create a table, we also provide it with conventions to understand the type of system it needs to build.

An agent equipped with a Marketing Ops skill can thus more naturally understand how to structure an editorial calendar, campaigns, or a launch process. Airtable also accompanies these skills with ready-to-use prompts.

This gradually shifts Airtable toward a logic of:

describing the desired system rather than systematically starting from a rigid template.

But a generic skill remains different from knowing your specific company. Your customer lifecycle, your exceptions, your roles, and your way of working must still be integrated into the model.

Querying Airtable from ChatGPT or Claude

MCP is also useful without building anything.

Take a base containing:

  • Clients;

  • Projects;

  • Tasks;

  • Invoices.

You can ask:

Which projects are delayed and still have an uncreated invoice?

or:

Summarize what happened this week with client Acme.

or even:

Which owners have more than five overdue tasks?

The assistant retrieves the necessary Airtable data directly and then uses it in the context of the conversation.

This can save you from having to build a view or a dashboard for every single question.

The AI then becomes a new interface for accessing structured data, complementary to traditional views and Interfaces.

Connecting Airtable MCP to ChatGPT

Airtable already offers a dedicated application in ChatGPT, and its official MCP server can also be connected in environments that allow custom MCPs.

For a custom MCP server, OpenAI currently indicates that full MCP capabilities, including write actions, are available on ChatGPT Business and Enterprise/Edu on the web. ChatGPT Pro can use MCPs in Developer mode with more limited read/search capabilities. These terms are evolving rapidly and should therefore be verified at the time of deployment.

The setup process then remains the same:

  1. enable the environment that allows apps/MCP;

  2. add the server https://mcp.airtable.com/mcp;

  3. authenticate with Airtable;

  4. authorize only the necessary bases;

  5. test the available actions before rolling them out to the team.

In a corporate setting, I recommend treating this connection as a true business integration, rather than a simple plugin enabled individually by each user.

What about Claude?

Claude is one of the assistants explicitly mentioned by Airtable as compatible with its MCP server. The setup again consists of adding the remote Airtable server and authenticating.

Once connected, Claude can discover the available schema before choosing the appropriate tool for the request.

This becomes particularly valuable when Claude is already being used to:

  • write or analyze documents;

  • work on files;

  • prepare meetings;

  • develop code;

  • brainstorm processes.

Airtable data can then serve as structured operational context directly available within that conversation.

Permissions: MCP Does Not Open Your Entire Base to the AI

This is an important point.

The MCP server respects the permissions of the connected Airtable account. The agent cannot simply browse all the bases in the organization just because it is connected to Airtable. Airtable also notes that administrators can control third-party integrations at the organization level.

There is even a particularly interesting case with Interface Designer.

For individuals who only have access to an Interface, Airtable exposes MCP tools to discover authorized pages and view the records visible on those pages. The server thus respects this scope rather than automatically requiring full access to the backend base.

We can therefore imagine:

Central Base

→ Sales Interface
→ sales reps
→ AI assistant on accessible sales data

→ Production Interface
→ Ops team
→ AI assistant on accessible operational data

This is a great architecture for integrating AI without unnecessarily exposing the entire backend layer to every user.

On the other hand, certain building operations naturally require more permissions. For example, Airtable currently restricts creating or modifying automations via MCP to Base owners and creators.

MCP, Omni, Field Agents, Automations, or API: Which to Choose?

These features are complementary.

Need

Recommended Tool

Build or modify Airtable from within Airtable

Omni

Work on Airtable from Claude or an external assistant

MCP

Query data occasionally in natural language

MCP / Omni

Automatically process every record with AI

Field Agents

Execute an action after an event

Automation

Execute custom JavaScript logic

Run a script

Sync two systems deterministically

API

Build a robust application integration

API

The most important difference is probably between MCP and Automation.

MCP comes into play when the agent decides which tools to use to fulfill an intent.

An automation comes into play when a specific event must always trigger the exact same sequence of actions.

For example:

"Analyze my projects and tell me which ones need my attention."

→ MCP.

"Every morning, automatically send a summary of overdue projects."

→ Automation.

The same reasoning applies to the API: MCP does not replace a deterministic integration that must run predictably thousands of times.

For more technical integrations, check out our Airtable API guide.

5 Interesting Use Cases for Airtable MCP

Quickly building a V1

Describe a process → generate tables and relationships → create the first Interfaces → adjust with users.

Evolving an existing system

Ask, for example, to add contract management to an existing CRM, along with the associated relationships and fields.

Generating an automation

Describe the business action in natural language, then review the configuration before turning it on.

Analyzing activity without building a new dashboard

Directly query projects, clients, opportunities, or operational data based on immediate needs.

Giving each role an assistant for their specific scope

Map Airtable permissions and Interfaces to AI usage to avoid exposing the entire backend unnecessarily.

Limitations of Airtable MCP to Keep in Mind

MCP greatly reduces technical friction, but it does not solve several fundamental problems.

Poorly structured data will still be difficult to use. Ambiguous statuses will remain ambiguous. A base full of duplicates will not become reliable just because an LLM can query it.

It is also important to keep in mind that the agent can perform many actions quickly. Major operations should therefore still be reviewed, especially when modifying schemas or processing a large number of records.

Some capabilities also remain incomplete:

  • existing Interface pages are not yet editable via MCP;

  • Run a script cannot yet be created or modified;

  • not all automation actions have the same level of support;

  • new automations must still be turned on manually;

  • available capabilities depend on the MCP client used.

MCP therefore does not turn Airtable into an autonomous system that can be left unsupervised.

Above all, it reduces the cost of building and interacting with the system.

What MCP Really Changes for Airtable

In the end, the most interesting change is not being able to write:

Add this client to Airtable.

That was already possible in other ways.

What changes is that the building layer itself is gradually becoming accessible in natural language:

data → model → Interfaces → automations.

This can dramatically speed up a skilled builder's workflow.

But it also makes system design even more important.

If creating a table, a field, or an automation takes only a few seconds, the value shifts toward asking the right questions:

Should we really create this table?
Is this status useful?
Does this automation actually simplify the process?
What information needs to be shown to this user?
Which decision must remain human?

AI is gradually reducing the difficulty of how to build.

It does not automatically solve what to build and why.

Need to Integrate AI into Your Airtable Processes?

HyperOps designs and evolves Airtable systems where AI is integrated only when it brings concrete value: data structuring, qualification, search, automations, agents, or connection via MCP.

The goal remains to build a simple, reliable system that teams can actually use—with or without AI.

Explore our Airtable implementation and consulting services, our automation and AI services, or our Airtable business tools.

Frequently Asked Questions about Airtable MCP

Does Airtable have an official MCP server?

Yes. Airtable maintains its own MCP server at https://mcp.airtable.com/mcp. It allows compatible assistants to interact with data and several Airtable builder functions.

Can we connect Airtable to ChatGPT with MCP?

Yes, but the available capabilities currently depend on the ChatGPT plan and configuration. Airtable also offers its own app for ChatGPT.

Can Airtable data be modified from Claude?

Yes, if the connected account has the necessary permissions and if the MCP client allows the corresponding actions. MCP respects the user's Airtable permissions.

Can Airtable MCP create Interfaces and automations?

Yes. It can now create Interface pages and build automations. However, editing existing Interfaces and creating "Run a script" actions currently remain limited.

Does MCP replace Make, n8n, or the Airtable API?

No. MCP is particularly suited for agent-driven interactions. Automations, Make, n8n, or an API integration remain more suitable for repeatable processes that need to run automatically and deterministically.

Need to go further on this topic?

Explain to us how you operate and the difficulties you are facing. No need for specifications: a few pieces of context are enough to get started.