What is the Airtable MCP server?
The Airtable MCP server is an MIT licensed TypeScript server that lets an MCP client inspect Airtable schemas and then read and write records. It has fifteen tools for bases, tables, fields, records and comments, and runs over stdio by default with an optional HTTP mode.
It is a Model Context Protocol server that gives an AI client structured access to Airtable. The agent first looks at which bases and tables exist, then reads or changes records, so it works from your real schema.
Many sites keep content calendars, product lists, leads or directory data in Airtable. This server lets an agent query that data in plain language instead of exporting a spreadsheet.
What an agent can do with it
- List bases and tables, and describe a table at three levels of detail.
- List, search, get, create, update and delete records.
- Create tables and fields, and rename or redescribe them.
- Read and write comments on a record, including threaded replies.
- Filter with an Airtable formula to narrow what comes back.
Who it is for
Best for
- Marketers who track content, campaigns or leads in Airtable and want quick answers.
- Developers who feed a website from an Airtable base and need to inspect or fix rows.
- Ops teams doing repeat record edits.
Not for
- Read only reporting on shared bases where nobody should hold write scopes.
- Remote use without a gateway. The README warns that HTTP mode has no built in authentication.
Use it with UiChemy
Airtable can hold the copy and data behind a site. Once the content is ready, UiChemy's Composer writes HTML, CSS and JS for Elementor or Gutenberg pages in WordPress. Click Get Started on uichemy.com.
Connect Airtable MCP Server: Read and Write Bases With AI to your AI client
npx -y airtable-mcp-serverCreate a personal access token
In Airtable create a token with the schema.bases:read and data.records:read scopes, plus any write scopes you really need, and limit it to the bases you want to use.
Generate the config
The README points to an install helper that produces the right config for your client. Or paste the block above.
Set the key
Put the token in AIRTABLE_API_KEY in place of the placeholder.
Begin read only
Grant write scopes only after you have tried listing bases and searching records.
Optional HTTP mode
Start with MCP_TRANSPORT=http and PORT=3000 for a stateless server at the /mcp path, but only behind a gateway that requires credentials.
Client configuration
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}Endpoints and ports
pat123.abc123Personal access token. Set it as an environment variable.httpOptional. Switches from stdio to HTTP.3000Optional. Port for HTTP mode.What you can do with it
- Schema firstThe agent can inspect bases, tables, fields and views before it reads any record.
- Formula filteringPass an Airtable formula to list only matching records.
- Text searchSearch all text fields, or limit the search to field IDs you name.
- Table and field changesCreate tables and fields and edit their names and descriptions.
- Threaded commentsCreate and list comments on a record, with parent comment support.
- Scoped tokenWrite scopes are optional, so the same server can run read only.
- HTTP transportAn optional stateless HTTP mode serves remote clients, with a security warning in the README.
Tools it exposes
list_bases
Lists accessible bases with ID, name and permission level.
list_tables / describe_table
Return tables, fields and views at a chosen detail level.
list_records
Reads records, with maxRecords and an optional filterByFormula.
search_records
Finds records containing a search term in chosen fields.
get_record
Reads one record by ID.
create_record / update_records
Add a record or change several.
delete_records
Removes one or more records.
create_table / update_table
Create a table or change its name and description.
create_field / update_field
Add a field or change its name and description.
create_comment / list_comments
Write and read comments on a record.
Frequently asked questions
What is the Airtable MCP server?
It is an open source Model Context Protocol server that gives an AI client read and write access to Airtable. It can inspect schemas, then list, search, create, update and delete records, change tables and fields, and handle record comments. The licence is MIT.
How do I install the Airtable MCP server?
Run it with npx and the package name airtable-mcp-server, and set AIRTABLE_API_KEY to a personal access token. The README links an install helper that builds the config for several MCP clients, so you can also paste the generated block.
Which Airtable token scopes does it need?
At minimum schema.bases:read and data.records:read, plus access to the bases you want. The README lists schema.bases:write, data.records:write and the comment read and write scopes as optional additions. Grant only what the job needs.
Can it delete Airtable records?
Yes. There is a delete_records tool that removes one or more records by ID, and update tools that change field values. Leave the write scopes off the token if you want a read only setup, and try changes on a copy of the base.
Is the HTTP mode safe?
The README warns that HTTP mode has no built in authentication and that a malicious website could reach a localhost port through DNS rebinding. Use the default stdio transport on one machine, or place HTTP mode behind a gateway that requires a credential.
How many tools does it have?
The README documents fifteen tools: 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 and list_comments. Together they cover schema inspection, record work, structural changes and record comments in one server.
Can I filter records with Airtable formulas?
Yes. The list_records tool accepts a filterByFormula string and a maxRecords limit that defaults to 100. The search_records tool does text matching across text fields, or only across the field IDs you give it.
Which tools pair well with it for WordPress?
For content on WordPress, see WP MCP Ultimate. Store data lives behind the WooCommerce MCP server, and layouts in MCP Abilities Elementor if you build with Elementor. Choose by the system holding the data you need.


