Public

airtable-mcp

See in Github

2025-03-26

Airtable integration for AI-powered applications via Anthropic's Model Context Protocol (MCP). Connect your AI tools directly to Airtable for seamless data access and management.

1

Github Watches

2

Github Forks

16

Github Stars

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