Airtable MCP

Integrations

  • Provides tools for Airtable data management, including base and table operations, record creation, reading, updating, and deletion, schema management, and data filtering—all accessible through natural language commands.

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

  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 NameDescriptionExample Usage
list_basesList all accessible Airtable bases"Show me all my Airtable bases"
list_tablesList all tables in the current base"What tables are in this base?"
list_recordsList records with optional filtering"Show me all records in the Projects table"
get_recordGet a specific record"Get record ABC123 from Tasks table"
create_recordsCreate new records"Create a new record in Contacts with name John"
update_recordsUpdate existing records"Update status to Complete in record XYZ"
set_base_idSwitch 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.

-
security - not tested
A
license - permissive license
-
quality - not tested

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.

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

  1. Quick Start
    1. Features
      1. Available Tools
        1. Troubleshooting
          1. Common Issues
          2. Need Help?
        2. Contributing
          1. License

            Related MCP Servers

            • A
              security
              A
              license
              A
              quality
              Allows 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 -
              1
              360
              Python
              MIT License
              • Linux
              • Apple
            • -
              security
              F
              license
              -
              quality
              Enables 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 -
              9
              JavaScript
              • Apple
            • -
              security
              F
              license
              -
              quality
              Enables AI assistants to interact with Metabase, providing access to dashboards, questions, databases, and tools for executing queries and viewing data through natural language.
              Last updated -
              JavaScript
              • Apple
            • -
              security
              A
              license
              -
              quality
              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.
              Last updated -
              MIT License

            View all related MCP servers

            ID: 51ao9m042v