Airtable MCP by InsightfulPipe

com.insightfulpipe由 insightfulpipe.com 發布v1.0.0更新於 Oct 26, 2026

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

發布方自己的服務:Airtable

已驗證Streamable HTTP可網頁執行資料庫效率與工作流

概覽

AI 產生的概覽

託管的 Airtable MCP 伺服器,讓助理列出 base、資料表與欄位,讀取與搜尋記錄,並建立或修改記錄和留言。

可以做什麼
  • 列出 base、資料表、欄位與檢視,並查看資料表結構
  • 讀取、計數、依 ID 取得與關鍵字搜尋記錄,以及查看記錄留言
  • 批次建立、更新與刪除記錄(每次最多 10 筆),並上傳附件
  • 建立與修改資料表和欄位,以及張貼、編輯或刪除留言
適用情境
適合讓 AI 助理直接回答 Airtable 中的資料問題,或在對話中新增與維護記錄。適合希望使用託管連接器、依帳號開關個別操作,而不想自行執行本機伺服器的團隊。
執行需求
以 URL 加入的遠端 MCP 端點,不需本機套件或執行環境。需要 OAuth 登入服務商帳號,實際權限由所授予的 Airtable 個人存取權杖範圍決定。7 天試用後需付費的 InsightfulPipe 訂閱。ChatGPT 需開啟開發人員模式且方案支援。
安裝前請注意
此伺服器具備寫入能力:24 個操作中有 14 個會建立、更新、刪除或上傳資料,包括刪除記錄與留言。破壞性操作預設關閉,但管理員可開啟,應確認每個帳號啟用了哪些操作。唯讀連線可將代理限制為唯讀操作。存取權限取決於所授予的 Airtable 權杖範圍,資料會經過第三方託管服務,且需付費訂閱。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 Airtable MCP by InsightfulPipe,將其新增到工作區。
  2. 連接 所需的 憑證。它們會被私密儲存,絕不會在公開頁面上展示。
  3. 為需要使用其工具的對話啟用該服務。

Web executable,透過 Streamable HTTP。 遠端服務在工作區中設定後即可從網頁執行環境執行。

交給代理程式安裝

把這段提示詞貼上到 Claude Code、Codex、Cursor 等代理程式,或 SourceWeft 對話中。代理程式會讀取該伺服器的安裝指南,先向你展示發布者、端點和登入方式,經你同意後再把它新增到你的客戶端。金鑰不會寫進任何命令。

閱讀 https://sourceweft.com/mcp/com.insightfulpipe%2Fairtable/install.md,並按其中說明把這個 MCP 伺服器接入我的客戶端。修改任何設定之前,先告訴我它的發布者、端點和登入方式,等我確認。不要把 API 金鑰寫進命令或我會提交的檔案;問我金鑰應從哪裡取得。

檢視代理程式所依據的安裝指南

其他 MCP 客戶端

把它新增到你客戶端的 mcpServers 設定中。 客戶端會在首次連接時完成 OAuth 登入。

{
  "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.

來源:README.md,提交 e0a430b

工具

0
該伺服器需要登入,因此 SourceWeft 無法在沒有帳號的情況下讀取其工具,也未收錄。已連接帳號所能看到的內容可能因帳號及其權限而異。

版本歷史

1
  1. v1.0.0最新Oct 21, 2026

評分

已滿足適用檢查項的 85%

該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通必需25 分
  • 已宣告認證方式必需10 分
  • 已列出工具15 分

    請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。

  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分

其他 Airtable 整合