Skip to content
MCP Shelf

Airtable MCP Server

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

View on GitHub
  • Needs your setup first
  • ★ 456 GitHub stars
  • 2.1K downloads a week
  • Last commit 25 Oct 2026

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.

Tools
15
Runs on
Your computer
Licence
MIT
GitHub stars
456

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

You'll need

  • 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
Works withClaude CodeCursorClaude DesktopVS CodeCodexWindsurfEach has a ready-made config on the Install tab, built from the README.

Needs your setup firstIt 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

Once it is installed, ask your assistant things like:

  • 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, not the README · tested on 10 Nov 2026

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.

Airtable MCP Server in more detail

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)
Latest version
1.14.0 (27 Jul 2026)
Downloads
2.1K a week
Last commit
25 Oct 2026
Setup checked
10 Nov 2026
Page updated
10 Nov 2026

What's in the pod

What tools does Airtable MCP Server have?

We found 15 tools in its source code on 10 Nov 2026. 7 only read. The rest can change things, so keep your app's "ask before each tool call" setting on for them.

How we tested it: Read from the source and README of airtable-mcp-server 1.14.0. Each call needs a real Airtable personal access token.

Changes things8 tools · Can create, edit, send or delete.

ToolWhat it is for
create_commentComments on a record, or replies in a comment thread.
create_fieldAdds a field of a given type, with its options, to a table.
create_recordAdds a record with the field values given.
create_tableCreates a table with a name, description and list of fields.
delete_recordsDeletes one or more records by id.
update_fieldRenames a field or changes its description.
update_recordsChanges fields on one or more records at once.
update_tableRenames a table or changes its description.

Only reads7 tools · Looks things up and changes nothing.

ToolWhat it is for
describe_tableThe same detail for one table, without fetching the whole base.
get_recordReads one record by its id.
list_basesLists every base the token can reach, with its id, name and your permission level.
list_commentsReads a record's comments, newest first, with authors, reactions and mentions.
list_recordsLists a table's records, 100 by default, optionally filtered with an Airtable formula.
list_tablesLists the tables in a base, with their fields and views, at the level of detail asked for.
search_recordsFinds records that contain some text, in chosen fields or in every text field.

Grouped and described by us. The README on GitHub lists the inputs each tool takes.

How do I install Airtable MCP Server?

Quick install

Pick your app and paste this in. It follows the README's own install steps below.

Where it goes: Your terminal, in the project folder

Claude Code
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.

Codex, Windsurf, ChatGPT and more →

Install steps from the Airtable MCP Server README

The project's own instructions, copied from its README on GitHub on 10 Nov 2026 under its MIT licence. They are the source of truth; the ready-made configs further down are built from them. The full README is on GitHub.

Installation

Follow the instructions on install-mcp, 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 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

Add Airtable MCP Server to your app

Pick your app for a ready-to-paste snippet and where it goes, built from the steps above.

Where it goes: Your terminal, in the project folder

Claude Code
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.

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: domdomegg/airtable-mcp-server README, www.npmjs.com/package/airtable-mcp-server.

Did this work for you?

Projects change their install steps often. If Airtable MCP Server did not install, or something here no longer matches the project, tell us and we will check it against the README and fix the page.

New to this? See the setup guides for Claude Code, Cursor, Claude Desktop, VS Code, Codex and ChatGPT. If it will not start, test it in MCP Inspector and look up the error in Fixing MCP server errors.

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.

How do I configure Airtable MCP Server?

Names are exactly as the project spells them. Required ones are marked.

SettingWhat it does
AIRTABLE_API_KEYEnvironment variable · requiredYour 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.pat123.abc123
MCP_TRANSPORT and PORTEnvironment variableSet 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.http

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.

Two peas, one chat

Chat with AI about Airtable

Opens a chat primed with Airtable’s README and setup docs from this page, or add it in Cursor to use its tools.

The Cursor button opens Cursor and asks before it adds the server. Fill in any keys it needs in Cursor’s MCP settings.

Peas in a pod

What are the alternatives to Airtable MCP Server?

How Airtable MCP Server lines up against its neighbours on the shelf. See every knowledge and work apps server.

  • Airtable MCP ServerThis pea

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

    Tools
    15
    Runs on
    Your computer
    Licence
    MIT
    Stars
    456
  • Notion

    Notion's own server: search, read and update pages and databases.

    Tools
    24
    Runs on
    Hosted or your computer
    Licence
    MIT
    Stars
    4.7K
  • MCP Atlassian (Jira and Confluence)

    Jira issues and Confluence pages, Cloud or self-hosted.

    Tools
    98
    Runs on
    Your computer
    Licence
    MIT
    Stars
    6.1K
  • Basic Memory

    Long-term memory as plain Markdown files you own.

    Tools
    27
    Runs on
    Your computer
    Licence
    AGPL-3.0-or-later
    Stars
    4.4K
  • LinkedIn MCP Server

    Read LinkedIn profiles, companies and job posts with your own login.

    Tools
    20
    Runs on
    Your computer
    Licence
    Apache-2.0
    Stars
    4K
  • arXiv MCP Server

    Search arXiv, download papers and read them in full.

    Tools
    19
    Runs on
    Your computer
    Licence
    Apache-2.0
    Stars
    3.2K
Full docs on GitHubdomdomegg/airtable-mcp-server

Something wrong on this page? Tell us.

For bots & AI agents

Machine-readable versions of Airtable MCP Server and MCP Shelf. Fetch these instead of parsing this page.

This listing (.md)llms.txtllms-full.txtai.txtFull catalog (.md)API specMCP serverMCP manifestDeveloper docs