A
securityA
licenseA
qualityAllows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
Last updated -
870
MIT License
Provides comprehensive tools for interacting with Airtable databases, including base management, table operations, schema manipulation, and record management (query, create, update, delete).
Supports production deployment using PM2 for managing the Airtable MCP server process, with configuration examples provided for stable operation.
Airtable MCP
Connect your AI tools directly to Airtable. Query, create, update, and delete records using natural language. Features include base management, table operations, schema manipulation, record filtering, and data migration—all through a standardized MCP interface compatible with Cursor, Claude Code, Cline, Zed, and other Claude-powered editors.
This application is a powerful Airtable integration tool that enables AI-powered applications via Anthropic's Model Context Protocol (MCP) to access and manipulate Airtable data directly from your IDE.
Features
Base Management: List and select Airtable bases
Table Operations: Browse tables, fields, and records
Data Access: Read, create, update, and delete records
Schema Management: Export, compare, and update schemas
Command-line Configuration: Use API tokens directly through command-line parameters
NPX Compatible: Easy installation with a single command
Smithery Integration: One-click installation via Smithery
Architecture
There are two core components used to access and manipulate Airtable data:
Airtable MCP Server: A Python server that provides standardized tools for AI clients to interact with Airtable.
MCP Client: Any client that supports the Model Context Protocol (Cursor, Claude Desktop, Cline, Zed, etc.).
┌─────────────┐ ┌──────────────┐ ┌───────────────┐
│ MCP Client │ ──► │ Airtable │ ──► │ Airtable │
│ (e.g. │ ◄── │ MCP Server │ ◄── │ API │
│ Cursor) │ │ │ │ │
└─────────────┘ └──────────────┘ └───────────────┘
Model Context Protocol (MCP) is a capability supported by Anthropic AI models that allows you to create custom tools for any compatible client. MCP clients like Claude Desktop, Cursor, Cline, or Zed can run an MCP server which "teaches" these clients about new tools they can use.
Installation
Prerequisites
Node.js 14+
Python 3.10+ (automatically detected)
Airtable API token
A compatible MCP client (Cursor, Claude Desktop, etc.)
Smithery Installation (Recommended)
The easiest way to install:
Visit Smithery
Search for "@rashidazarang/airtable-mcp"
Click "Install" and follow the prompts
Quick Setup with NPX (Alternative)
Another fast way to get started:
# Install globally
npm install -g airtable-mcp
# Or run directly with npx
npx airtable-mcp --token "your_airtable_token" --base "your_base_id"
Configure Your MCP Client
For Cursor, update your ~/.cursor/mcp.json file:
{
"mcpServers": {
"airtable-tools": {
"command": "npx",
"args": [
"airtable-mcp",
"--token", "your_airtable_token",
"--base", "your_base_id"
]
}
}
}
Restart your MCP client to load the new tools.
Manual Installation (Advanced)
If you prefer to clone the repository and install manually:
Clone this repository:
git clone https://github.com/rashidazarang/airtable-mcp.git cd airtable-mcpInstall dependencies:
pip install -r requirements.txtRun the server:
python airtable_mcp/src/server.py --token "your_airtable_token" --base "your_base_id"
Usage
Once installed and configured, you can use natural language to interact with your Airtable data:
"Show me all the bases I have access to"
"List the tables in my current base"
"Show me the structure of the Customers table"
"Get the first 10 records from the Orders table"
"Create a new record in the Products table"
"Update record XYZ in the Inventory table"
"Export the schema of my current base"
Available Tools
Tool Name | Description |
| List all accessible Airtable bases |
| List all tables in the specified or default base |
| List records from a table with optional filtering |
| Get a specific record from a table |
| Create records in a table from JSON string |
| Update records in a table from JSON string |
| Delete records from a table by IDs |
| Export records from a table as JSON string |
| Import records to a table from JSON string |
| Create tables from a JSON schema |
| Update existing tables to match a JSON schema |
| Set the current Airtable base ID |
| Get detailed information about a table's structure and fields |
| Export the schema of the current base in JSON or CSV format |
| Compare the provided schema with the current base schema |
| Generate a field mapping between two tables |
| Migrate data from one table to another using the specified field mapping |
PM2 Configuration
For production use, you can use PM2 to manage the Airtable MCP server:
// ecosystem.config.js
module.exports = {
apps: [
{
name: 'airtable-mcp',
script: 'npx',
args: [
'airtable-mcp',
'--token', 'your_airtable_token',
'--base', 'your_base_id'
],
interpreter: '/usr/local/bin/node',
env: {
PATH: process.env.PATH,
},
},
],
};
Start with:
pm2 start ecosystem.config.js
Compatibility
Works with any MCP-compatible client
Primarily designed for Cursor IDE integration
Supports other AI editors and MCP clients
Detailed Documentation
For detailed installation instructions, troubleshooting, and advanced configurations, see INSTALLATION.md.
License
MIT
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Enables AI-powered applications to access and manipulate Airtable data directly from your IDE, supporting operations like querying, creating, updating, and deleting records through natural language commands.
Related MCP Servers
- -securityAlicense-qualityProvides code manipulation, execution, and version control capabilities. It allows AI assistants to read, write, and execute code while maintaining a history of changes.Last updated -9MIT License
- -securityFlicense-qualityEnables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.Last updated -67
- -securityAlicense-qualityConnects AI tools directly to Airtable, allowing users to query, create, update, and delete records using natural language.Last updated -7537MIT License