# Airtable MCP by InsightfulPipe

> Airtable MCP by InsightfulPipe is an MCP server for productivity. Hosted Airtable server with 24 actions for records, tables, fields and comments. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Free trial
- **Starting price:** $29.99 a month
- **Platforms:** API, CLI, Web
- **Website:** https://insightfulpipe.com/mcp-servers/airtable
- **Repository:** https://github.com/insightful-pipe/airtable-mcp-server
- **MCP Registry name:** com.insightfulpipe/airtable
- **Categories:** productivity, databases
- **Listing updated:** 2026-11-14

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://airtable.insightfulmcp.com/
```

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## Tools

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

## 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

- [Ha MCP](https://ai-powered.com/mcp/ha-mcp): Ha MCP is an open-source MCP server for productivity.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [note1](https://ai-powered.com/mcp/note1): note1 is an MCP server for productivity.
- [CalderFlow](https://ai-powered.com/mcp/calderflow): CalderFlow is a free MCP server for design and media.
- [nicemails](https://ai-powered.com/mcp/nicemails): nicemails is a freemium MCP server for communication.
- [ConvertAudioToText](https://ai-powered.com/mcp/convertaudiototext): ConvertAudioToText is a freemium MCP server for design and media.
- [MeetBetr](https://ai-powered.com/mcp/meetbetr): MeetBetr is a free MCP server for productivity.

---
Source: https://ai-powered.com/mcp/airtable-mcp-by-insightfulpipe
