Airtable MCP

🚀 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 transformation, record filtering, and data migration—all through a standard MCP interface compatible with Claude Desktop and other Claude-powered editors.

🚀 Quick Start

Step 1: Obtain Your Airtable Credentials

• Get your Airtable API token from your account page.
• Extract the base ID from your Airtable base URL (format: appi7fWMQcB3BNzPs).

Step 2: 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 the file and restart Claude Desktop.

Step 3: Start Using the Airtable Tool

• Open Claude Desktop.
• Wait 30 seconds for the connection to be established.
• Start interacting with your Airtable data using 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: Interact with your Airtable data using plain English.

💻 Available Tools

🔧 Troubleshooting

Common Issues

Connection Issues

• Ensure Node.js is installed (node -v should show v14 or higher).
• Verify the correctness of your API token and base ID.
• Restart Claude Desktop after making configuration changes.

Data Issues

• Check for any spelling or formatting errors.
• Ensure you have sufficient permissions to access the target data.
• Try testing with different query parameters.

Performance Issues

• Optimize your queries to reduce complexity.
• Ensure your network connection is stable.
• Clean up unnecessary caches and temporary files.

Solutions

• Check Logs: View detailed error messages for more context.
• Reinstall Dependencies: Sometimes, reinstalling Node modules can resolve issues.
• Contact Support: Seek professional help if the problem persists.

👥 Contribution

Contributions are welcome! Please refer to the Contribution Guide to learn how to get involved.

📄 License

MIT License

📚 References

• Airtable API Documentation
• Claude Desktop Integration Guide