Is this the official Airtable MCP server?

No. Airtable runs its own MCP server. InsightfulPipe is an independent, hosted server that connects to the Airtable Web API through Airtable OAuth. InsightfulPipe is not affiliated with Airtable.

Which AI assistants does it work with?

Any AI client that supports remote MCP servers. The setup guide on this page covers Claude, ChatGPT, Claude Code, Cursor, Gemini CLI and Codex. You can also work with the same connected accounts from the terminal with the InsightfulPipe CLI.

Is there a Claude connector for Airtable?

Yes. In Claude, add https://airtable.insightfulmcp.com/ as a custom connector and authorize your InsightfulPipe account. You can also add InsightfulPipe from the Claude Directory, which connects all of your linked accounts at once.

Can I use the Airtable MCP server with ChatGPT?

Yes. Add the server URL as a custom connector in ChatGPT Developer mode, or add InsightfulPipe from the ChatGPT app directory to connect all of your linked accounts. Developer mode availability depends on your ChatGPT plan.

What Airtable data can my AI access?

The bases you grant access to, their tables, fields and views, records with filtering, sorting and field selection, keyword search and record counts, and comments on records.

Can it change records and tables?

Yes, on connections with Read & Write access. It can create, update and delete records (up to 10 per call), create tables and fields, rename and describe tables and fields, add, edit and delete comments, and upload attachments.

Is it safe to let AI edit Airtable?

You control the risk. Read-only connections request only Airtable read scopes, and on Read & Write connections you choose exactly which actions are allowed. Deleting records and comments stays off until an owner, admin or operator enables it. Updating records overwrites the fields you send and is a regular write action.

Can I connect multiple Airtable accounts?

Yes. Each connection is one Airtable account with the bases it grants, and you can connect several accounts. Each connected account counts as one connection on your plan.

How does authentication work?

You sign in with Airtable OAuth, which uses PKCE, and grant access to bases. Read-only and Read & Write connections use different scope sets. InsightfulPipe stores and refreshes the tokens securely, and your AI client signs in to the MCP server with your InsightfulPipe account, not your Airtable login.

What are the limitations?

Record creates, updates and deletes are limited to 10 records per call. There are no actions for webhooks, automations, interfaces or creating bases. Airtable API rate limits apply, and the server waits and retries when Airtable asks it to slow down.

How much does the Airtable MCP server cost?

The Airtable MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month and include a trial. See insightfulpipe.com/pricing for current plans.

Airtable MCPProductivity24 actions

Airtable MCP Server

Let your AI agents run Airtable for you, safely.

A hosted Airtable MCP server for Claude, ChatGPT, Cursor and CLI agents. Paste one server URL into your AI client to use its 24 actions. There is nothing to install.

Enable or disable every action, per account. Block your agent from doing dangerous actions.
Ask in plain English. Pull reports, find insights and take action in Airtable.
24 read and write actions. Every Airtable task your agent needs, from reporting to making changes.
Built for teams. Invite your team and share one connected account.

Start a trial View all 24 actions

Works with

ChatGPT

Claude

Claude Code

Codex

Gemini CLI

Cursor

Mistral

OpenClaw

HermesPerplexityGrokn8nWindsurfVS CodeZed

ChatGPT

connected to Airtable MCP

Online

Actions

Available Actions

24 actions available to automate your Airtable workflows.

24 actions

Read

Count Records

Count records matching a filter (paginates through, sums lengths). Cheaper than fetching full rows when you only need the total.

Update a table's name or description.

Write

Upload Attachment

Upload an attachment to an attachment field on a record. Provide either contentType+file (base64) or simply url.

Compare

Airtable MCP servers compared: hosted vs official

Airtable runs its own MCP server with records, schema, interfaces and automations. It is a good fit if you only need Airtable and want permissions to follow your base roles. InsightfulPipe is a hosted alternative with Read-only connections, per-action controls and Airtable next to your other platforms.

What you operate	InsightfulPipe MCP server	Airtable MCP server (Airtable)
Hosting	Hosted by InsightfulPipe: paste one URL	Hosted by Airtable at mcp.airtable.com
Authentication	Airtable OAuth with PKCE	OAuth or a personal access token
Capabilities	24 actions for bases, tables, fields, views, records, comments and attachments	Records, base schema, bases, interfaces and automations
Permissions	Read-only connections with read scopes, per-action switches, deleting records and comments off by default	Follows your base permissions
Plans	Included in InsightfulPipe plans from $29.99/month, with a trial	Available to all users on all Airtable plans
Other platforms	Ads, analytics, e-commerce and data platforms in the same workspace, plus a CLI	Airtable only

Overview

Add records for new ideas, update progress and read a view as a weekly summary.

See all Airtable actions

24

actions

one server URL

10

read actions

reports, audits, research

14

write actions

create, update, manage

Setup

How to connect the Airtable MCP server

Add the server URL to your AI client, then sign in with your InsightfulPipe account to authorize access. The server is hosted, so there is nothing to install.

MCP server URL

https://airtable.insightfulmcp.com/

Connect Airtable to Claude

Fastest: add InsightfulPipe from the Claude Directory

One click connects the full InsightfulPipe MCP with all your connected accounts. To add a server scoped to Airtable only, follow the steps below.

Open Claude Directory

Or add the Airtable server manually:

01
Copy the server URL:
```
https://airtable.insightfulmcp.com/
```
02
Open Claude connector settings (Customize > Connectors), click + and then Add custom connector.
03
Paste the URL and click Add.
04
Click Connect, then click Authorize access in the browser.

Start a new chat, click +, open Connectors and turn the connector on to use it.

The Free plan can add one custom connector. On Team and Enterprise plans, an Owner first adds it under Organization settings > Connectors, then each member clicks Connect in Customize > Connectors.

Connect Airtable to ChatGPT

Fastest: add InsightfulPipe from the ChatGPT app directory

One click connects the full InsightfulPipe MCP with all your connected accounts. To add a server scoped to Airtable only, follow the steps below.

Open in ChatGPT

Or add the Airtable server manually. Custom MCP servers need ChatGPT's Developer mode, which OpenAI offers on Plus, Pro, Business, Enterprise and Education accounts on the web.

01
Copy the server URL:
```
https://airtable.insightfulmcp.com/
```
02
In ChatGPT, open Settings → Security and login and turn on Developer mode.
03
Go to ChatGPT Plugins and select the + button.
04
Enter a name, paste the URL under Connection and create the connection.
05
When the sign-in opens, click Authorize access in the browser.
06
In a new chat, choose Developer mode from the + menu and select the app. Select it again in each new chat.

See OpenAI's Developer mode guide.

Connect Airtable to Claude Code

01

Add the server:

claude mcp add --transport http airtable-mcp https://airtable.insightfulmcp.com/

02
In Claude Code, run /mcp, select airtable-mcp and choose Authenticate.
03
Sign in to InsightfulPipe in the browser window and click Authorize access.

Connect Airtable to Cursor

01
Add the Airtable MCP server to Cursor, or add it to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):
```
{
  "mcpServers": {
    "airtable-mcp": {
      "url": "https://airtable.insightfulmcp.com/"
    }
  }
}
```
02
The server shows Needs authentication. Click Connect, then Open.
03
Sign in to InsightfulPipe and click Authorize access.

Connect Airtable to Gemini CLI

01

Add the server:

gemini mcp add --transport http airtable-mcp https://airtable.insightfulmcp.com/

02
In Gemini CLI, run /mcp auth airtable-mcp.
03
Sign in to InsightfulPipe in the browser window and click Authorize access.

Connect Airtable to Codex CLI

Using the Codex app? Add InsightfulPipe from the OpenAI app directory

The listed app connects the full InsightfulPipe MCP with all your connected accounts, in both ChatGPT and Codex.

Open the app listing

01
Add the server. When Codex detects OAuth support, it starts sign-in right away:
```
codex mcp add airtable-mcp --url https://airtable.insightfulmcp.com/
```
02
A browser window opens. Sign in to InsightfulPipe and click Authorize access. If no browser opens, run codex mcp login airtable-mcp.

Watch the setup tutorial

Works everywhere

Bring Airtable into the AI tools you already use

One hosted server URL, any MCP-compatible client. Pick yours to see the setup steps, or paste the URL into anything that speaks MCP.

Playbook

Prompts and skills that run on the Airtable MCP

Copy a prompt into any connected client, or install a Claude skill that chains the actions for you.

Prompt

“How many records in Leads have Status set to Qualified?”

Counts records matching a formula

View prompt

Prompt

“Find records in Campaigns that mention Black Friday”

Searches across text fields

View prompt

Prompt

“List the records in the This Week view of Tasks”

Lists records from a view

View prompt

Prompt

“Set Status to Published on these eight records”

Updates records in one batch

View prompt

Prompt

“Add a Budget currency field to the Campaigns table”

Creates a new field

View prompt

Prompt

“Attach this image link to the Creative field on the Spring Sale record”

Uploads an attachment from a URL

View prompt

Prompt

“Comment on the Spring Sale record asking Maya to approve it”

Adds a record comment

View prompt

Browse the prompt library All Claude skills

HAVE QUESTIONS?

Frequently asked questions

An Airtable MCP server connects Airtable to AI assistants through the Model Context Protocol (MCP), an open standard for giving AI tools access to data and actions. Once connected, you can ask Claude, ChatGPT or Cursor to find, count and update records or change tables in plain English.

Airtable's server signs in with OAuth or a personal access token, works with records, base schema, bases, interfaces and automations, follows your base permissions and is available on all Airtable plans. InsightfulPipe focuses on records, tables, fields, comments and attachments, and adds Read-only connections with read scopes only, per-action controls, deletes off by default and your other platforms in the same workspace.

Airtable MCP Server

Available Actions

Count Records

Create Comment

Create Field

Create Record

Create Records

Create Table

Delete Comment

Delete Record

Delete Records

Describe Table

Get Record

List Bases

List Comments

List Fields

List Records

List Tables

List Views

Search Records

Update Comment

Update Field

Update Record

Update Records

Update Table

Upload Attachment

Airtable MCP servers compared: hosted vs official

What you can do with the Airtable MCP

Answer questions about a base

Clean data in batches

Run content and campaign trackers

How to connect the Airtable MCP server

MCP server URL

Connect Airtable to Claude

Connect Airtable to ChatGPT

Connect Airtable to Claude Code

Connect Airtable to Cursor

Connect Airtable to Gemini CLI

Connect Airtable to Codex CLI

Watch the setup tutorial

Bring Airtable into the AI tools you already use

ChatGPT

Claude

Claude Code

Codex

Cursor

Gemini CLI

Mistral

OpenClaw

Hermes

OpenAI Agents SDK

Claude Agents SDK

Google ADK

Perplexity

Grok

n8n

Windsurf

VS Code

Zed

OpenCode

CLI

Prompts and skills that run on the Airtable MCP

Frequently asked questions

What is an Airtable MCP server?

Is this the official Airtable MCP server?

How is it different from Airtable's official MCP server?

Which AI assistants does it work with?

Is there a Claude connector for Airtable?

Can I use the Airtable MCP server with ChatGPT?

What Airtable data can my AI access?

Can it change records and tables?

Is it safe to let AI edit Airtable?

Can I connect multiple Airtable accounts?

How does authentication work?

What are the limitations?

How much does the Airtable MCP server cost?

Explore more MCP servers

Ready to connect your data?