airtable-mcp-server
An MCP server for Airtable: the agent inspects base schemas, searches, creates, updates and deletes records, and handles fields and comments
- 456 ★ on the repository
- Last commit
- MIT
Broad access
Why this level
- Creates, modifies and deletes records and tables in an external service
- Uses an Airtable access token
Install
- Works in
Manual 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.
Access and checks
How we reviewBroad accessThe tool can change data, run commands or handle secrets.
- Creates, modifies and deletes records and tables in an external service
- Uses an Airtable access token
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 eachMCP
- Transport
- stdio, http
- Authentication
- API key
Environment variables
AIRTABLE_API_KEYrequired, secret- Airtable personal access token.
Limitations
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.
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.
Discussion
No questions or reviews yet.
Related
MCP serversMCP server that gives an agent access to MySQL: schema inspection and queries, read-only by default, writes behind flags
A Python MCP server for MySQL: listing tables, reading data, running SQL and inspecting schema through a controlled interface
MCP server for Google Sheets and Google Drive: an agent reads, edits and creates spreadsheets, tabs and charts
Official Tableau MCP server: the agent finds data sources, sends queries to them and opens dashboards and Pulse metrics
A free MCP server for a working 1C infobase: the agent reads data from plain requests and gets the metadata structure of any configuration
Official MongoDB MCP server: queries and aggregations, index management, Atlas clusters and local deployments
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.