airtable-mcp-server
An MCP server for Airtable: the agent inspects base schemas, searches, creates, updates and deletes records, and handles fields and comments
Install
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Config from the install-mcp generator; replace the token with yours.
This is third-party code. Review the repository files before installing.
What it does
The server connects the agent to Airtable bases with a personal access token. The agent first lists bases, tables and fields, then reads records with a formula filter or searches by text. It can create and bulk-update records, delete them, add tables and fields, and rename or describe them. It also reads and creates record comments, including threaded replies.
Who it is for. For teams that keep data in Airtable and want to query and edit it through an agent.
Good fit when
- You need to find and update records by condition without manual filtering
- You need to design a new table with fields from a description
- You need a summary of data in an Airtable base
Not a fit when
- Your data is not in Airtable
- You need an HTTP server for remote clients without your own authenticating gateway
Example request
Find all deals in the CRM base with status pending older than a month and add a comment to eachLimitations
Requires an Airtable personal access token with schema and record read scopes, plus write scopes for changes. HTTP mode has no built-in auth; the author warns about DNS rebinding and recommends stdio for local use. Airtable availability from Russia is not guaranteed.
How to disable. Remove the airtable block from the MCP config and revoke the token on Airtable's tokens page.
MCP
- Transport
- stdio, http
- Authentication
- API key
| Environment variables | |
|---|---|
| AIRTABLE_API_KEY required, secret | Airtable personal access token. |
Security check
- Creates, modifies and deletes records and tables in an external service
- Uses an Airtable access token
README in short
The README points to the install-mcp config generator for various clients and explains how to create an Airtable personal access token with the right scopes. It lists tools for bases, tables, fields, records and comments with parameters. HTTP mode and its risks are covered separately. The project is TypeScript, published to npm, MIT licensed.
FAQ
Which token scopes do I need?
schema.bases:read and data.records:read for reading. Add schema.bases:write and data.records:write for changes and the data.recordComments scopes for comments.
Can it run over HTTP?
Yes, with MCP_TRANSPORT=http, but only behind an authenticating proxy, otherwise anyone reaching the port can call the tools.
Related
166 skills for scientific work: bioinformatics, cheminformatics, clinical data, geospatial analysis and 100+ databases
Google's open-source MCP server for databases: ready tools for Postgres, MySQL, BigQuery, Spanner and more, plus custom tools in tools.yaml
Official Hugging Face skills: Hub operations via the hf CLI, datasets, model training, Spaces, evals and deployment
A token-lean MCP server for PostgreSQL, MySQL, MariaDB, SQL Server and SQLite with a read-only mode