Airtable MCP

Airtable MCP

Connects AI tools directly to Airtable, allowing users to query, create, update, and delete records using natural language.

rashidazarang

Remote Shell Execution
Database Interaction
AI Integration Systems
Data & App Analysis
Visit Server

README

Airtable MCP

Airtable smithery badge

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

  1. Get Your Airtable Credentials

    • Get your Airtable API token from your account page
    • Get your base ID from your Airtable base URL (format: appi7fWMQcB3BNzPs)
  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 and restart Claude Desktop
  3. 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

  1. 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
  2. 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
  3. 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?

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.

Recommended Servers

playwright-mcp

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official
Featured
TypeScript
VeyraX MCP

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official
Featured
Local
E2B

E2B

Using MCP to run code via e2b.

Official
Featured
Neon Database

Neon Database

MCP server for interacting with Neon Management API and databases

Official
Featured
Exa Search

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official
Featured
Qdrant Server

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official
Featured
AIO-MCP Server

AIO-MCP Server

🚀 All-in-one MCP server with AI search, RAG, and multi-service integrations (GitLab/Jira/Confluence/YouTube) for AI-enhanced development workflows. Folk from

Featured
Local
Persistent Knowledge Graph

Persistent Knowledge Graph

An implementation of persistent memory for Claude using a local knowledge graph, allowing the AI to remember information about users across conversations with customizable storage location.

Featured
Local
Hyperbrowser MCP Server

Hyperbrowser MCP Server

Welcome to Hyperbrowser, the Internet for AI. Hyperbrowser is the next-generation platform empowering AI agents and enabling effortless, scalable browser automation. Built specifically for AI developers, it eliminates the headaches of local infrastructure and performance bottlenecks, allowing you to

Featured
Local
React MCP

React MCP

react-mcp integrates with Claude Desktop, enabling the creation and modification of React apps based on user prompts

Featured
Local