
Airtable MCP Server
Read schemas, search and edit records, and comment in your Airtable bases.
- 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
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).
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)
- npm package
- airtable-mcp-server
- 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.
| Tool | What it is for |
|---|---|
create_comment | Comments on a record, or replies in a comment thread. |
create_field | Adds a field of a given type, with its options, to a table. |
create_record | Adds a record with the field values given. |
create_table | Creates a table with a name, description and list of fields. |
delete_records | Deletes one or more records by id. |
update_field | Renames a field or changes its description. |
update_records | Changes fields on one or more records at once. |
update_table | Renames a table or changes its description. |
Only reads7 tools · Looks things up and changes nothing.
| Tool | What it is for |
|---|---|
describe_table | The same detail for one table, without fetching the whole base. |
get_record | Reads one record by its id. |
list_bases | Lists every base the token can reach, with its id, name and your permission level. |
list_comments | Reads a record's comments, newest first, with authors, reactions and mentions. |
list_records | Lists a table's records, 100 by default, optionally filtered with an Airtable formula. |
list_tables | Lists the tables in a base, with their fields and views, at the level of detail asked for. |
search_records | Finds 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 mcp add airtable -e AIRTABLE_API_KEY=pat123.abc123 -- npx -y airtable-mcp-serverclaude 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.
Where it goes: ~/.cursor/mcp.json, or .cursor/mcp.json in a project
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Where it goes: claude_desktop_config.json (Settings → Developer → Edit Config)
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Where it goes: .vscode/mcp.json in your project
{
"servers": {
"airtable": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}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 mcp add airtable -e AIRTABLE_API_KEY=pat123.abc123 -- npx -y airtable-mcp-serverclaude 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.
Where it goes: ~/.cursor/mcp.json, or .cursor/mcp.json in a project
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Where it goes: claude_desktop_config.json (Settings → Developer → Edit Config)
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Where it goes: .vscode/mcp.json in your project
{
"servers": {
"airtable": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Where it goes: ~/.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
Where it goes: ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Where it goes: 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: 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.
| Setting | What it does |
|---|---|
AIRTABLE_API_KEYEnvironment variable · required | 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.pat123.abc123 |
MCP_TRANSPORT and PORTEnvironment variable | 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.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'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

Long-term memory as plain Markdown files you own.
- Tools
- 27
- Runs on
- Your computer
- Licence
- AGPL-3.0-or-later
- Stars
- 4.4K

Read LinkedIn profiles, companies and job posts with your own login.
- Tools
- 20
- Runs on
- Your computer
- Licence
- Apache-2.0
- Stars
- 4K

Search arXiv, download papers and read them in full.
- Tools
- 19
- Runs on
- Your computer
- Licence
- Apache-2.0
- Stars
- 3.2K
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