Use This MCP server To

Query Airtable records using natural language commands Create and update Airtable records via AI tools Manage Airtable bases and tables programmatically Filter Airtable data dynamically through AI queries Migrate data between Airtable bases using AI workflows Integrate Airtable with Claude Desktop for enhanced data access Automate Airtable schema changes through natural language Enable AI-driven data management in Airtable-powered apps

README

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 Claude Desktop and other Claude-powered editors.

Quick Start

Get Your Airtable Credentials
- Get your Airtable API token from your account page
- Get your base ID from your Airtable base URL (format: appi7fWMQcB3BNzPs)

Configure Claude Desktop

Open ~/Library/Application Support/Claude/claude_desktop_config.json
Add the following configuration:

{
  "mcpServers": {
    "airtable-mcp": {
      "command": "npx",
      "args": [
        "@smithery/cli",
        "run",
        "@rashidazarang/airtable-mcp",
        "--token",
        "YOUR_AIRTABLE_TOKEN",
        "--base",
        "YOUR_BASE_ID"
      ]
    }
  }
}

Replace YOUR_AIRTABLE_TOKEN and YOUR_BASE_ID with your actual credentials
Save and restart Claude Desktop

Start Using Airtable Tools
- Open Claude Desktop
- Wait 30 seconds for the connection to establish
- Start using Airtable commands in natural language

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
Natural Language Interface: Use plain English to interact with your Airtable data

Available Tools

Tool Name	Description	Example Usage
`list_bases`	List all accessible Airtable bases	"Show me all my Airtable bases"
`list_tables`	List all tables in the current base	"What tables are in this base?"
`list_records`	List records with optional filtering	"Show me all records in the Projects table"
`get_record`	Get a specific record	"Get record ABC123 from Tasks table"
`create_records`	Create new records	"Create a new record in Contacts with name John"
`update_records`	Update existing records	"Update status to Complete in record XYZ"
`set_base_id`	Switch to a different base	"Switch to base appi7fWMQcB3BNzPs"

Troubleshooting

Common Issues

Connection Issues
- Make sure Node.js is installed (node -v should show v14 or higher)
- Verify your API token and base ID are correct
- Restart Claude Desktop after configuration changes
JSON Parsing Errors
- Double-check the JSON format in your configuration file
- Avoid using extra backslashes or escape characters
- Use the simplified configuration format shown above
Command Not Found
- Install Node.js if not already installed
- Run npm install -g npm@latest to update npm
- Try running npx @smithery/cli --version to verify the installation

Need Help?

Check the Issues page
Join our Discord community
Email support at support@example.com

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

MIT

For detailed setup instructions with other MCP clients, see CLAUDE_INTEGRATION.md.

airtable-mcp FAQ

How do I authenticate the airtable-mcp server with my Airtable account?

You authenticate by providing your Airtable API token and base ID, which you can obtain from your Airtable account page and base URL respectively.

Can I use airtable-mcp with AI models other than Anthropic's Claude?

Yes, airtable-mcp is compatible with any MCP-compliant client, including those using OpenAI, Claude, and Gemini models.

What operations can I perform on Airtable data using airtable-mcp?

You can query, create, update, delete records, manage bases and tables, manipulate schemas, filter records, and migrate data.

Is airtable-mcp compatible with Claude Desktop?

Yes, it is designed to integrate seamlessly with Claude Desktop and other Claude-powered editors.

How do I configure airtable-mcp for use with Claude Desktop?

You add the airtable-mcp server configuration to the claude_desktop_config.json file with your Airtable credentials and base ID.

Does airtable-mcp support schema manipulation in Airtable?

Yes, it supports schema changes such as adding or modifying tables and fields via natural language commands.

Can airtable-mcp handle data migration between Airtable bases?

Yes, it facilitates data migration workflows between different Airtable bases.

What security measures are in place for airtable-mcp?

Authentication uses your Airtable API token, and all operations are scoped to your authorized bases, ensuring secure access.