Skip to content
MCP server

Airtable MCP by InsightfulPipe

Hosted Airtable server with 24 actions for records, tables, fields and comments

Install
Pricing
Free trial
Platforms
API, CLI, Web
Runs
Remotely
Version
1.0.0
Listing updated
3 days ago

About Airtable MCP by InsightfulPipe

Airtable MCP by InsightfulPipe is an MCP server for productivity. It runs as a hosted remote server, so there is nothing to install locally.

Batch limits are built into the action list: create, update and delete work on up to 10 records per call, and count_records pages through a filter to return only a total instead of full rows. list_records accepts filterByFormula, view, sort, fields and paging options, while search_records builds a SEARCH() formula across the fields you name.

Beyond records, the server can list bases, describe tables with their fields and views, create or rename tables and fields, post, edit and delete comments, and upload an attachment by base64 or URL. You sign in with Airtable OAuth (PKCE), choose Read-only or Read & Write, and grant specific bases. Deleting records and comments is off by default, and each action can be switched per account.

InsightfulPipe's own comparison table positions it as a hosted alternative to Airtable's server, which also covers interfaces and automations and follows base permissions.

Install

Run in a terminal

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

Add to Settings → Connectors → Add custom connector

https://airtable.insightfulmcp.com/
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "airtable": {
      "url": "https://airtable.insightfulmcp.com/"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "airtable": {
      "type": "http",
      "url": "https://airtable.insightfulmcp.com/"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Tools this server provides (9)

Taken from the project documentation; the running server may differ.

count_records
Count records matching a filter.
list_records
List records with formula, view, sort and paging.
search_records
Keyword search across fields.
create_records
Create up to 10 records in one call.
update_records
Patch up to 10 records in one call.
delete_records
Delete up to 10 records by id.
describe_table
Return a table's schema.
list_bases
List accessible bases.
upload_attachment
Upload an attachment to a record field.

What it does

Record queries
List, get, search and count with formula, view, sort and paging.
Batch writes
Create, update or delete up to 10 records per call.
Schema tools
Describe tables, list fields and views, create and update tables and fields.
Comments
List, create, edit and delete record comments.
Attachment upload
Add a file by base64 or URL.
Read-only mode
Read-only connections cannot enable write actions.

Good for

  • Count qualified leads in a base without pulling every row
  • Search a table by keyword across chosen fields
  • Add a field to a table from a chat
  • Update several records in one call

Pricing

Free trial, from $29.99 a month

Included in InsightfulPipe plans from $29.99 a month, with a trial

Prices change. Check insightfulpipe.com before you buy.

Airtable MCP by InsightfulPipe FAQ

How do I sign in?

With Airtable OAuth using PKCE.

Can I stop it deleting?

Yes. Deleting records and comments is off by default and each action can be disabled.

How many records per write?

Up to 10 per call.

What does it cost?

Included in InsightfulPipe plans from $29.99 a month, with a trial.

Is Airtable MCP by InsightfulPipe free?

Airtable MCP by InsightfulPipe is a paid product with a free trial. Paid plans start at $29.99 a month.

How do I add Airtable MCP by InsightfulPipe to Claude Code?

Run this command in your terminal: claude mcp add --transport http airtable https://airtable.insightfulmcp.com/

What are the best alternatives to Airtable MCP by InsightfulPipe?

The closest alternatives to Airtable MCP by InsightfulPipe are Ha MCP, Concord MCP, Midplane, note1 and CalderFlow.

Alternatives to Airtable MCP by InsightfulPipe

  1. Ha MCP

    MCP server

    MCP server for managing and automating Home Assistant from AI assistants

    Runs locally
    • 8 tools
    • Open source
    • 7.9K GitHub stars
    • Productivity
  2. Concord MCP

    MCP server

    Local-first MCP server for messaging and shared work-state between coding agents

    Runs locally
    • Freemium
    • 1.3K GitHub stars
    • Developer tools
  3. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  4. note1

    MCP server

    MCP server giving AI assistants search and summaries across your note1 meetings

    • 4 tools
    • Remote
    • Free trial
    • 1 GitHub star
    • Productivity
  5. CalderFlow

    MCP server

    Turn notes or specs into editable flowcharts, timelines and funnels from an AI assistant

    • 10 tools
    • Remote
    • Free
    • Design and media
  6. nicemails

    MCP server

    Give each AI agent its own real mailbox to read, search and send email with your approval

    • 8 tools
    • Remote
    • Freemium
    • Communication