---
title: "Airtable MCP Server: Read and Write Bases from Claude"
url: "https://mcpshelf.co/servers/airtable"
description: "airtable-mcp-server lets an assistant read your Airtable schemas, search, create and update records, add fields and comments. Token scopes and npx setup."
updated: "2026-11-10"
site: "MCP Shelf"
---

# Airtable MCP Server

> Read schemas, search and edit records, and comment in your Airtable bases.

Source: https://mcpshelf.co/servers/airtable  
Markdown: https://mcpshelf.co/servers/airtable.md  
Generated: 2026-11-22T13:57:57.114Z

## Facts

- **Name:** Airtable MCP Server
- **Tagline:** Read schemas, search and edit records, and comment in your Airtable bases.
- **Description:** Airtable MCP Server (airtable-mcp-server) is a community server by Adam Jones that lets an AI assistant read Airtable base schemas and search, create, update and delete records and comments.
- **Repository:** https://github.com/domdomegg/airtable-mcp-server
- **Package:** airtable-mcp-server 1.14.0 (npm)
- **Install:** `claude mcp add airtable -e AIRTABLE_API_KEY=pat123.abc123 -- npx -y airtable-mcp-server`
- **Transport:** stdio (local)
- **Auth:** Needs `AIRTABLE_API_KEY`
- **Tools exposed:** 15: `list_bases`, `list_tables`, `describe_table`, `list_records`, `search_records`, `get_record`, `create_record`, `update_records`, `delete_records`, `create_table`, `update_table`, `create_field`, `update_field`, `create_comment`, `list_comments`
- **Category:** Knowledge and work apps (https://mcpshelf.co/categories/knowledge-and-work)
- **Stats:** 456 GitHub stars, 2.1K downloads a week, last commit 25 Oct 2026, 0 upvotes on MCP Shelf
- **Install check:** Needs your setup first
- **Listed:** 2026-11-10
- **Page updated:** 2026-11-10

## Full description

### What is Airtable MCP Server?

**Airtable MCP Server (airtable-mcp-server) is a community server by Adam Jones that lets an AI assistant read Airtable base schemas and search, create, update and delete records and comments.**

Adam Jones maintains this widely used community server for Airtable. It starts by looking: list the bases a token can see, then the tables, fields and views in each, so the model knows the real field names before it touches anything. From there it can list and filter records with an Airtable formula, search text across fields, and create, update or delete records.

It can also change structure, creating tables and fields and renaming them, and it reads and writes record comments. What it is allowed to do depends on the scopes you give the personal access token, so a token with only the two read scopes gives you a server that cannot change anything.

|  |  |
| --- | --- |
| Made by | Adam Jones (domdomegg/airtable-mcp-server) |
| GitHub | https://github.com/domdomegg/airtable-mcp-server |
| Licence | MIT |
| npm package | [airtable-mcp-server](https://www.npmjs.com/package/airtable-mcp-server) 1.14.0 (27 Jul 2026) |
| GitHub stars | 456 |
| Downloads | 2.1K a week |
| Last commit | 25 Oct 2026 |
| Tools | 15 |
| Runs on | Your computer |
| Install check | Needs your setup first |
| Category | [Knowledge and work apps](https://mcpshelf.co/categories/knowledge-and-work) |
| Works with | Claude Code, Cursor, Claude Desktop, VS Code, Codex, Windsurf |
| Setup checked | 10 Nov 2026 |
| Page updated | 10 Nov 2026 |

**Our check:** It needs something our Linux test machine does not have (an account, a desktop app, a Mac or a running service), so on 10 Nov 2026 we read its tools from the source code instead of running this config.

#### Try asking Airtable MCP Server

- "What tables are in my CRM base, and what fields does each have?"
- "Find all leads in Airtable with status "Contacted" and no follow-up date."
- "Add a record to Tasks: "Book venue", owner Sam, due next Friday."

#### MCP Shelf take

> Airtable needs something our Linux test machine does not have (an account, an app or a service), so on 10 Nov 2026 we read its source and counted 15 tools. 7 of the 15 only read; the other 8 can change things. It sits 17th of 17 in its category on our shelf by GitHub stars (456, with 2.1K downloads a week).

— MCP Shelf tests (numbers from our own runs), tested on 10 Nov 2026

### What tools does Airtable MCP Server have?

We listed 15 tools on 10 Nov 2026. 7 only read; the rest can change things or run commands.

| Tool | Kind | What it is for |
| --- | --- | --- |
| `list_bases` | reads | Lists every base the token can reach, with its id, name and your permission level. |
| `list_tables` | reads | Lists the tables in a base, with their fields and views, at the level of detail asked for. |
| `describe_table` | reads | The same detail for one table, without fetching the whole base. |
| `list_records` | reads | Lists a table's records, 100 by default, optionally filtered with an Airtable formula. |
| `search_records` | reads | Finds records that contain some text, in chosen fields or in every text field. |
| `get_record` | reads | Reads one record by its id. |
| `create_record` | changes | Adds a record with the field values given. |
| `update_records` | changes | Changes fields on one or more records at once. |
| `delete_records` | changes | Deletes one or more records by id. |
| `create_table` | changes | Creates a table with a name, description and list of fields. |
| `update_table` | changes | Renames a table or changes its description. |
| `create_field` | changes | Adds a field of a given type, with its options, to a table. |
| `update_field` | changes | Renames a field or changes its description. |
| `create_comment` | changes | Comments on a record, or replies in a comment thread. |
| `list_comments` | reads | Reads a record's comments, newest first, with authors, reactions and mentions. |

### How do I install Airtable MCP Server?

#### Install steps from the Airtable MCP Server README

Copied from the project's [README on GitHub](https://github.com/domdomegg/airtable-mcp-server#readme) on 10 Nov 2026 under its MIT licence.

##### Installation

Follow the instructions on [install-mcp](https://adamjones.me/install-mcp/?config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsImFpcnRhYmxlLW1jcC1zZXJ2ZXIiXSwibmFtZSI6ImFpcnRhYmxlIiwiZW52Ijp7IkFJUlRBQkxFX0FQSV9LRVkiOiJwYXQxMjMuYWJjMTIzIn19), which generates the right config for your MCP client (Claude Code, Claude Desktop, Cursor, Cline, VS Code, and more).

You'll need an Airtable personal access token — [create one here](https://airtable.com/create/tokens/new) with scopes `schema.bases:read` and `data.records:read` (and optionally `schema.bases:write`, `data.records:write`, `data.recordComments:read`, `data.recordComments:write`), and access to the bases you want to use. It looks something like `pat123.abc123` (but longer). Set it as `AIRTABLE_API_KEY` (replacing the placeholder in the generated config).

#### What you need first

- Node.js 18 or newer
- An Airtable personal access token with schema.bases:read and data.records:read, plus write scopes if you want edits

#### Claude Code

Where: Your terminal, in the project folder

```bash
claude mcp add airtable -e AIRTABLE_API_KEY=pat123.abc123 -- npx -y airtable-mcp-server
```

claude mcp add airtable -e AIRTABLE_API_KEY=your-token -- npx -y airtable-mcp-server adds it by hand, with your own token in place of the placeholder.

#### Cursor

Where: ~/.cursor/mcp.json, or .cursor/mcp.json in a project

```json
{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}
```

#### Claude Desktop

Where: claude_desktop_config.json (Settings → Developer → Edit Config)

```json
{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}
```

#### VS Code

Where: .vscode/mcp.json in your project

```json
{
  "servers": {
    "airtable": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}
```

#### Codex

Where: ~/.codex/config.toml, shared by the Codex CLI, IDE extension and ChatGPT desktop app

```
[mcp_servers.airtable]
command = "npx"
args = ["-y", "airtable-mcp-server"]

[mcp_servers.airtable.env]
AIRTABLE_API_KEY = "pat123.abc123"
```

Or run: `codex mcp add airtable --env AIRTABLE_API_KEY=pat123.abc123 -- npx -y airtable-mcp-server`

#### Windsurf

Where: ~/.codeium/windsurf/mcp_config.json

```json
{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}
```

#### ChatGPT

Where: Not supported

ChatGPT on the web only connects to servers by URL. This one runs on your computer: the ChatGPT desktop app can start it from its MCP servers settings, with the same config as the Codex tab.

Replace the placeholder with your own token and give it access only to the bases you want the assistant to see. Leave out the write scopes for a read-only start.

Checked against the project's own install docs on 10 Nov 2026: https://github.com/domdomegg/airtable-mcp-server#readme, https://www.npmjs.com/package/airtable-mcp-server

### How do I configure Airtable MCP Server?

| Setting | Kind | Required | What it does |
| --- | --- | --- | --- |
| `AIRTABLE_API_KEY` | env | yes | Your Airtable personal access token. It needs schema.bases:read and data.records:read, plus access to the bases you want; add the write and comment scopes only if you want those tools to work. Example: `pat123.abc123` |
| `MCP_TRANSPORT and PORT` | env | no | Set MCP_TRANSPORT=http to serve over HTTP at localhost:PORT/mcp instead of stdio. It has no authentication of its own, so keep it behind a proxy that checks a credential. Example: `http` |

### What can Airtable MCP Server read and change?

**It can read**

- The names, tables, fields and views of every base the token can see
- Records and their comments in those bases

**It can change**

- Records, including deletes, with data.records:write
- Tables and fields, with schema.bases:write
- Record comments, with data.recordComments:write

**Safer setup:** Give the token only schema.bases:read and data.records:read, and only the bases you want explored. Without the write scopes, Airtable refuses every change the server tries.

### Good for

- Asking questions of a base without building a view or a formula first
- Bulk-updating records from a list in the chat
- Setting up a new table with the right fields from a description

### Airtable MCP Server not working? Common fixes

**Errors saying the token is not authorised, or a base is missing**
Personal access tokens need both the scopes and access to each base. Edit the token at airtable.com/create/tokens and add the base or workspace under Access.

**Creating or updating records fails but reading works**
The token only has the read scopes. Add data.records:write, and schema.bases:write if you also want tables and fields changed.

**Comments cannot be read or added**
Comments need their own scopes, data.recordComments:read and data.recordComments:write, on the token.

**list_records stops at 100 records**
That is the default maxRecords. Ask for a higher limit, or narrow the list with a filter formula so the model is not reading the whole table.

**Worried about running it in HTTP mode**
The README warns that HTTP mode has no authentication and that a web page can reach localhost through DNS rebinding. Use the default stdio transport for a local client.

### What are the alternatives to Airtable MCP Server?

| Server | What it does | Tools | Runs on | Licence | Stars |
| --- | --- | --- | --- | --- | --- |
| [Airtable MCP Server](https://mcpshelf.co/servers/airtable) | Read schemas, search and edit records, and comment in your Airtable bases. | 15 | Your computer | MIT | 456 |
| [Notion](https://mcpshelf.co/servers/notion) | Notion's own server: search, read and update pages and databases. | 24 | Hosted or your computer | MIT | 4.7K |
| [MCP Atlassian (Jira and Confluence)](https://mcpshelf.co/servers/atlassian) | Jira issues and Confluence pages, Cloud or self-hosted. | 98 | Your computer | MIT | 6.1K |
| [Basic Memory](https://mcpshelf.co/servers/basic-memory) | Long-term memory as plain Markdown files you own. | 27 | Your computer | AGPL-3.0-or-later | 4.4K |
| [LinkedIn MCP Server](https://mcpshelf.co/servers/linkedin) | Read LinkedIn profiles, companies and job posts with your own login. | 20 | Your computer | Apache-2.0 | 4K |
| [arXiv MCP Server](https://mcpshelf.co/servers/arxiv) | Search arXiv, download papers and read them in full. | 19 | Your computer | Apache-2.0 | 3.2K |

### Airtable MCP Server FAQ

#### Is the Airtable MCP Server made by Airtable?

No. airtable-mcp-server is a community server by Adam Jones (domdomegg on GitHub), published on npm under the MIT licence. It is one of the most used Airtable servers and calls Airtable's official Web API.

#### Which token scopes does it need?

schema.bases:read and data.records:read to look around. Add data.records:write and schema.bases:write for edits, and data.recordComments:read and write for comments.

#### Can I make it read-only?

Yes, through the token. Create a personal access token with only the two read scopes and Airtable itself refuses every write the assistant tries.

#### How do I limit it to one base?

When you create the personal access token, add only that base under Access. list_bases then shows just that one, and nothing else in your workspace is reachable.

#### Can it change the structure of my base?

With schema.bases:write it can create tables and fields and rename them or change their descriptions. It cannot delete tables or fields.

#### How does it search my records?

search_records looks for text across all text fields, or the fields you name. For anything more precise, list_records takes an Airtable formula, which the model can write for you.

#### Does it work with remote clients over HTTP?

It can run in HTTP mode with MCP_TRANSPORT=http, but there is no built-in login. Only do that behind a gateway that requires a credential, and use stdio otherwise.

#### What does it cost?

The server is free and open source. Airtable's API limits, such as five requests per second per base, apply to your plan as usual.

#### How do I add Airtable MCP Server to Cursor?

In ~/.cursor/mcp.json, or .cursor/mcp.json for one project, add an entry named airtable that runs npx -y airtable-mcp-server, with AIRTABLE_API_KEY set under env. Save, and the tools show up in Agent chat.

#### Can I use Airtable MCP Server in VS Code?

Yes, through GitHub Copilot. In .vscode/mcp.json, add a server named airtable with type stdio that runs npx -y airtable-mcp-server, with AIRTABLE_API_KEY set under env. Then switch Copilot Chat to Agent mode to use its tools.

#### Does Airtable MCP Server work with Codex?

Yes. Run codex mcp add airtable --env AIRTABLE_API_KEY=pat123.abc123 -- npx -y airtable-mcp-server in a terminal, or add an [mcp_servers.airtable] table to ~/.codex/config.toml, which the Codex CLI and IDE extension share.

Full docs on GitHub: https://github.com/domdomegg/airtable-mcp-server

## Notes for agents

Fetch these instead of parsing the HTML page:

- llms.txt: https://mcpshelf.co/llms.txt
- llms-full.txt: https://mcpshelf.co/llms-full.txt
- ai.txt: https://mcpshelf.co/ai.txt
- Full catalog (.md): https://mcpshelf.co/catalog.md
- API spec: https://mcpshelf.co/openapi.json
- MCP server: https://mcpshelf.co/mcp
- MCP manifest: https://mcpshelf.co/.well-known/mcp.json
- Developer docs: https://mcpshelf.co/developers

MCP endpoint (Streamable HTTP, no key): https://mcpshelf.co/mcp. REST API: https://mcpshelf.co/api/v1.

