Airtable MCP by InsightfulPipe

com.insightfulpipePublished by insightfulpipe.comv1.0.0Updated Oct 26, 2026

Hosted Airtable MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

The publisher's own server: Airtable

VerifiedStreamable HTTPWeb executableDatabasesProductivity & Workflow

Overview

AI-generated overview

Hosted Airtable MCP server that lets an assistant list bases, tables and fields, read and search records, and create or edit records and comments.

What you can do
  • List bases, tables, fields and views, and describe table schemas
  • Read, count, get and keyword-search records, and list record comments
  • Create, update and delete records in batches of up to 10, and upload attachments
  • Create and modify tables and fields, and post, edit or delete comments
When to use it
Useful when you want an AI assistant to answer questions about data in Airtable bases or to add and maintain records without leaving the chat. Suited to teams that prefer a hosted connector with per-account action toggles over running a local server.
Requirements
A remote MCP endpoint added by URL; no local package or runtime. OAuth sign-in to the provider is required, and the Airtable personal access token scopes you grant determine what is allowed. A paid InsightfulPipe plan is needed after a 7-day trial. ChatGPT requires developer mode and a plan that supports it.
Before you install
The server can write: 14 of 24 actions create, update, delete or upload data, including deleting records and comments. Destructive actions are off by default and can be enabled by an admin, so check which actions are enabled per account. Read-only connections limit agents to read actions. Access is governed by the Airtable token scopes you grant, and data passes through a third-party hosted service that requires a paid subscription.

Installation

In SourceWeft

  1. Open Airtable MCP by InsightfulPipe in the dashboard and add it to a workspace.
  2. Connect the required credentials. They are stored privately and never shown on public pages.
  3. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/com.insightfulpipe%2Fairtable/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config. The client completes OAuth sign-in on first connect.

{
  "mcpServers": {
    "airtable-by-insightfulpipe": {
      "type": "http",
      "url": "https://airtable.insightfulmcp.com/"
    }
  }
}

README

Airtable MCP Server by Insightful Pipe

[MCP Compatible] [Insightful Pipe] [License]

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).

[Airtable MCP Server]

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

bash
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):

json
{  "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)

ActionDescription
count_recordsCount records matching a filter (paginates through, sums lengths)
describe_tableReturn the schema of a single table from a base
get_recordGet a single record by id
list_basesList bases the authorized user has access to
list_commentsList comments on a record
list_fieldsList only the fields of a table (subset of describe_table)
list_recordsList records from a table
list_tablesList tables (with full schema: fields, views) in a base
list_viewsList only the views of a table (subset of describe_table)
search_recordsKeyword search across one or more fields

Write Actions (14)

ActionDescription
create_commentPost a comment on a record
create_fieldAdd a new field to a table
create_recordCreate a single record
create_recordsCreate up to 10 records in one call
create_tableCreate a new table in a base
delete_commentDelete a comment
delete_recordDelete a single record by id
delete_recordsDelete up to 10 records by id in one call
update_commentEdit a comment
update_fieldRename or re-describe an existing field
update_recordPATCH (merge) a single record
update_recordsPATCH (merge) up to 10 records in one call
update_tableUpdate a table's name or description
upload_attachmentUpload 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.

View All MCP Servers →

Resources

Support


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

License

MIT License - see LICENSE for details.

Source: README.md at commit e0a430b

Tools

0
This server asks you to sign in, so SourceWeft could not read its tools without an account and has not indexed them. What a connected account sees can depend on that account and its permissions.

Version history

1
  1. v1.0.0LatestOct 21, 2026

Score

85% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts

Other Airtable integrations