Airtable MCP
MCP server giving AI clients governed read and write access to Airtable bases
Airtable MCP is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
- Pricing
- Open source
- Platforms
- CLI, API, Self-hosted
- Runs
- Locally
- Version
- 5.1.0
- Listing updated
Similar MCP servers
Install
Run in a terminal
claude mcp add airtable-mcp --env AIRTABLE_TOKEN='<AIRTABLE_TOKEN>' -- npx -y @rashidazarang/airtable-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"airtable-mcp": {
"command": "npx",
"args": [
"-y",
"@rashidazarang/airtable-mcp"
],
"env": {
"AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"airtable-mcp": {
"command": "npx",
"args": [
"-y",
"@rashidazarang/airtable-mcp"
],
"env": {
"AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"airtable-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@rashidazarang/airtable-mcp"
],
"env": {
"AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"airtable-mcp": {
"command": "npx",
"args": [
"-y",
"@rashidazarang/airtable-mcp"
],
"env": {
"AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"airtable-mcp": {
"command": "npx",
"args": [
"-y",
"@rashidazarang/airtable-mcp"
],
"env": {
"AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
AIRTABLE_TOKENAirtable personal access token from https://airtable.com/create/tokens. Grant data.records, data.recordComments and schema.bases (read and write) and user.email:read.RequiredAIRTABLE_BASE_IDDefault base ID. When set, other bases are refused unless listed in AIRTABLE_ALLOWED_BASES. Leave unset to use every base the token can reach.AIRTABLE_ALLOWED_BASESComma-separated base IDs the server may use. Unset allows every base the token can reach.AIRTABLE_ALLOWED_TABLESComma-separated baseId:tableName pairs. In a base listed here, only the listed tables are allowed.AIRTABLE_TOOLSETTools to register: full (all tools), core (18 record tools, for clients that cap enabled tools) or a comma-separated list of tool names.AIRTABLE_GOVERNANCE_PATHPath to a governance JSON file (allow-lists, allowed operations, PII field policies). Defaults to config/governance.json in the working directory, if present.LOG_LEVELLog level. Logs go to stderr.EXCEPTION_QUEUE_SIZEHow many recent errors the list_exceptions tool keeps.
About Airtable MCP
The README describes this as a local Model Context Protocol server that connects AI clients such as Claude Desktop, Claude Code, Cursor, Codex, Windsurf and VS Code to Airtable through a personal access token. It covers records, schema, field and table management, record comments, webhooks and user identity, exposing these as tools the assistant can call from natural language requests.
A notable part of the design is governance. Environment variables let an operator restrict the server to specific base IDs or baseId:table pairs, and a governance JSON file can define allowed operations and PII field masking. Errors are kept in a queue that a list_exceptions tool can read back, and logs are written to stderr so stdio traffic stays clean.
The package is aimed at people who already use Airtable as a database and want an assistant to query, update or restructure it, particularly where access needs to be limited. The site and README state the project is MIT licensed and installed via npx, with an optional HTTP transport for hosted deployments.
Tools this server provides (42)
Taken from the project documentation; the running server may differ.
- list_bases
- List all accessible bases with permissions
- describe
- Describe base or table schema (supports detail levels)
- query
- Query records with filtering, sorting, and pagination
- search_records
- Advanced search with Airtable formulas
- list_records
- List records with field selection and pagination
- get_record
- Retrieve a single record by ID
- create
- Create new records (requires dryRun diff review)
- update
- Update existing records (requires dryRun diff review)
- delete_record
- Remove a record from a table
- upsert
- Update or create records based on merge fields
- batch_upsert_records
- Batch upsert with merge-on fields
- list_tables
- Get all tables in a base with schema info
- get_base_schema
- Get complete schema for any base
- list_field_types
- Reference guide for available field types
- get_table_views
- List all views for a table
- create_table
- Create tables with custom field definitions
- update_table
- Modify table names and descriptions
- delete_table
- Remove tables (requires confirmation)
- create_field
- Add fields to existing tables
- update_field
- Modify field properties and options
- delete_field
- Remove fields (requires confirmation)
- batch_create_records
- Create up to 10 records at once
- batch_update_records
- Update up to 10 records simultaneously
- batch_delete_records
- Delete up to 10 records in one operation
- list_webhooks
- View all configured webhooks
- create_webhook
- Set up real-time notifications
- delete_webhook
- Remove webhook configurations
- get_webhook_payloads
- Retrieve notification history
- refresh_webhook
- Extend webhook expiration
- create_view
- Create views (grid, form, calendar, etc.)
- get_view_metadata
- Get view details including filters
- upload_attachment
- Attach files from URLs
- create_base
- Create new bases with initial structure
- list_collaborators
- View collaborators and permissions
- list_shares
- List shared views and configurations
- list_comments
- List comments on a record
- create_comment
- Add a comment to a record
- update_comment
- Edit an existing comment
- delete_comment
- Remove a comment
- whoami
- Get current user identity and scopes
- list_governance
- Return governance allow-lists and PII masking policies
- list_exceptions
- List recent exceptions and remediation proposals
What it does
- Record read and write tools
- Lists, queries, searches, creates, updates, deletes and upserts Airtable records, with batch operations capped at 10 records.
- Schema inspection and editing
- Describes bases and tables and can create or modify tables, fields and views.
- Base and table allow-lists
- Environment variables restrict which bases and tables the server may touch.
- PII masking policies
- A governance file can define field-level masking and allowed operations.
- Record comments
- Lists, creates, edits and deletes comments on individual records.
- Webhook management
- Creates, lists, refreshes and deletes webhooks and retrieves payload history.
- Toolset selection
- A core profile of 18 record tools or a custom list can be chosen for clients that cap enabled tools.
Good for
- Letting an AI assistant read and update task or project records in Airtable
- Setting up Airtable tables and fields from a natural language description
- Restricting an assistant to specific bases or tables for shared workspaces
- Bulk updating or deleting Airtable records through an agent workflow
- Monitoring Airtable changes with webhooks from an AI client
Pricing
Open source
Free and MIT licensed; no paid plan is described.
Prices change. Check airtablemcp.com before you buy.
Airtable MCP FAQ
Does Airtable MCP run locally?
The registry entry lists stdio transport for local use, and the README shows installation through npx. An HTTP transport is available when PORT or MCP_HTTP_PORT is set.
What does the Airtable token need?
The README lists scopes for records, record comments, schema bases (read and write), user email and optional webhook management.
Is Airtable MCP free?
The site says it is free forever under the MIT license, and the README confirms the MIT license.
Can I limit which bases Airtable MCP accesses?
Yes. AIRTABLE_BASE_ID, AIRTABLE_ALLOWED_BASES and AIRTABLE_ALLOWED_TABLES restrict access.
How do I add Airtable MCP to Claude Code?
Run this command in your terminal: claude mcp add airtable-mcp --env AIRTABLE_TOKEN='<AIRTABLE_TOKEN>' -- npx -y @rashidazarang/airtable-mcp
What are the best alternatives to Airtable MCP?
The closest alternatives to Airtable MCP are Airtable, Airtable MCP by InsightfulPipe, Baserow, Fastmcp Sqltools and TableThis.
Where this comes from
- Description: written from the project's README, the project's website and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.