Airtable MCP by InsightfulPipe

Airtable MCP Server by Insightful Pipe

Connect Airtable to AI assistants: bases, tables, fields and records.

Part of the Insightful Pipe MCP Server Collection — use Airtable from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).

MCP Server URL

https://airtable.insightfulmcp.com/

What is Airtable MCP?

Airtable MCP is a remote Model Context Protocol server hosted by InsightfulPipe. List Airtable bases, inspect tables, and read records across your connected workspace. The PAT scopes you grant decide what's allowed.

Installation

Claude

1. Copy the MCP Server URL: https://airtable.insightfulmcp.com/
2. Open Claude Connectors Settings
3. Scroll to the bottom and click Add custom connector
4. Paste the URL and click Add
5. Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.

ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

1. Turn on Developer mode in ChatGPT settings
2. Create a new app for a remote MCP server and paste the URL: https://airtable.insightfulmcp.com/
3. Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code

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

Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

{
  "mcpServers": {
    "airtable": {
      "url": "https://airtable.insightfulmcp.com/"
    }
  }
}

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

24 actions: 10 read, 14 write.

Read Actions (10)

Action	Description
count_records	Count records matching a filter (paginates through, sums lengths)
describe_table	Return the schema of a single table from a base
get_record	Get a single record by id
list_bases	List bases the authorized user has access to
list_comments	List comments on a record
list_fields	List only the fields of a table (subset of describe_table)
list_records	List records from a table
list_tables	List tables (with full schema: fields, views) in a base
list_views	List only the views of a table (subset of describe_table)
search_records	Keyword search across one or more fields

Write Actions (14)

Action	Description
create_comment	Post a comment on a record
create_field	Add a new field to a table
create_record	Create a single record
create_records	Create up to 10 records in one call
create_table	Create a new table in a base
delete_comment	Delete a comment
delete_record	Delete a single record by id
delete_records	Delete up to 10 records by id in one call
update_comment	Edit a comment
update_field	Rename or re-describe an existing field
update_record	PATCH (merge) a single record
update_records	PATCH (merge) up to 10 records in one call
update_table	Update a table's name or description
upload_attachment	Upload an attachment to an attachment field on a record

Control What Your AI Can Do

You decide what AI agents can do with each connected account:

• Turn individual actions on or off for every connected account, so agents only see the actions you allow.
• Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
• Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
• Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.

Usage Examples

"List records in the Campaigns table where Status is Live"

"How many records are in the Leads table?"

"Create a record for a new lead"

Pricing

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 you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Explore More MCP Servers by Insightful Pipe

Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.

• Notion MCP
• Google Sheets MCP
• Slack MCP

View All MCP Servers →

Resources

• Documentation
• Video Tutorial
• InsightfulPipe Blog

Support

• Documentation: insightfulpipe.com/docs
• All MCP Servers: insightfulpipe.com/mcp-servers
• Email: [email protected]

---

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.