An MCP server implementation that provides read and write access to Airtable databases, enabling Claude to interact with your Airtable bases.
npm install @microagents/server-airtable
# or
yarn add @microagents/server-airtable
# Set your API token and run
AIRTABLE_API_KEY=pat123.abc123 npx @microagents/server-airtable
Add this to your claude_desktop_config.json
:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["@microagents/server-airtable"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}
To use this server, you'll need an Airtable Personal Access Token:
- Go to your Airtable account page
- Navigate to the "API" section
- Create a Personal Access Token with the following permissions:
-
schema.bases:read
- Required to read base and table schemas -
data.records:read
- Required to read records -
data.records:write
- Required to create or update records (optional)
-
- Copy the generated token (it starts with "pat")
- Schema Exploration: Inspect Airtable base and table schemas
- Record Management: Read, create, and update records in Airtable tables
- View Integration: Access data through different Airtable views
-
list_bases
: List all accessible Airtable bases -
get_base_schema
: Get schema information for a specific base -
get_table_schema
: Get schema information for a specific table
-
list_records
: List records from a table, with optional filtering -
get_record
: Get a specific record by ID -
create_record
: Create a new record in a table -
update_record
: Update an existing record -
delete_record
: Delete a record from a table
MIT
Based on the original MCP server by Adam Jones (domdomegg): domdomegg/airtable-mcp-server