The Airtable MCP server provides an AI-powered interface to your Airtable databases, allowing you to perform operations like querying data, managing tables, and setting up webhooks using natural language through Claude or other MCP clients.
Create a Personal Access Token at Airtable Account with these scopes:
data.records:read
- Read records from tablesdata.records:write
- Create, update, delete recordsschema.bases:read
- View table schemasschema.bases:write
- Create/modify tables and fieldswebhook:manage
- (Optional) For webhook featuresFind your Base ID in the URL of your Airtable base:
https://airtable.com/[BASE_ID]/...
# Install with TypeScript support
npm install -g @rashidazarang/airtable-mcp
# For development with types
npm install --save-dev typescript @types/node
npm install -g @rashidazarang/airtable-mcp
Create a .env
file in your project directory:
AIRTABLE_TOKEN=your_personal_access_token_here
AIRTABLE_BASE_ID=your_base_id_here
Add the following to your Claude Desktop configuration file:
MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"@rashidazarang/airtable-mcp",
"--token",
"YOUR_AIRTABLE_TOKEN",
"--base",
"YOUR_BASE_ID"
]
}
}
}
For a more secure setup using environment variables:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["@rashidazarang/airtable-mcp"],
"env": {
"AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
"AIRTABLE_BASE_ID": "YOUR_BASE_ID"
}
}
}
}
After configuration, restart Claude Desktop to load the Airtable server.
Once configured, you can interact with your Airtable data using natural language:
You can ask Claude:
You can manage your database structure:
For more efficient operations:
For real-time integrations:
The server includes AI-powered capabilities:
"Connection Refused" Error
"Invalid Token" Error
"Base Not Found" Error
Port Conflicts If port 8010 is in use:
lsof -ti:8010 | xargs kill -9
To add this MCP server to Claude Code, run this command in your terminal:
claude mcp add-json "airtable-mcp" '{"command":"npx","args":["@smithery/cli","run","@rashidazarang/airtable-mcp","--token","YOUR_AIRTABLE_TOKEN","--base","YOUR_BASE_ID"]}'
See the official Claude Code MCP documentation for more details.
There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json
file so that it is available in all of your projects.
If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json
file.
To add a global MCP server go to Cursor Settings > Tools & Integrations and click "New MCP Server".
When you click that button the ~/.cursor/mcp.json
file will be opened and you can add your server like this:
{
"mcpServers": {
"airtable-mcp": {
"command": "npx",
"args": [
"@smithery/cli",
"run",
"@rashidazarang/airtable-mcp",
"--token",
"YOUR_AIRTABLE_TOKEN",
"--base",
"YOUR_BASE_ID"
]
}
}
}
To add an MCP server to a project you can create a new .cursor/mcp.json
file or add it to the existing one. This will look exactly the same as the global MCP server example above.
Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.
The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.
You can also explicitly ask the agent to use the tool by mentioning the tool name and describing what the function does.
To add this MCP server to Claude Desktop:
1. Find your configuration file:
~/Library/Application Support/Claude/claude_desktop_config.json
%APPDATA%\Claude\claude_desktop_config.json
~/.config/Claude/claude_desktop_config.json
2. Add this to your configuration file:
{
"mcpServers": {
"airtable-mcp": {
"command": "npx",
"args": [
"@smithery/cli",
"run",
"@rashidazarang/airtable-mcp",
"--token",
"YOUR_AIRTABLE_TOKEN",
"--base",
"YOUR_BASE_ID"
]
}
}
}
3. Restart Claude Desktop for the changes to take effect