▌BestMCPTools.org
Airtable MCP logo

Airtable MCP

Read and write Airtable bases with AI

DatabaseOpen SourceAll ModelsEasy
Visit Tool458 stars

Last verified: September 6, 2026

Own Airtable MCP? Boost it to the top.✦ Upgrade to Featured

Maintenance status

Active
Last code update: September 9, 2026License: MITChecked September 28, 2026

How to Install Airtable MCP

$npx -y airtable-mcp-server

Requires Claude Desktop, Cursor, Windsurf, or another MCP-compatible client.

Setup by client

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "airtable-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ]
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "airtable-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ]
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "airtable-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ]
    }
  }
}

Claude Code (terminal)

claude mcp add airtable-mcp -- npx -y airtable-mcp-server

Add any API keys or environment variables the server's README lists.

About Airtable MCP

Treat any Airtable base as a queryable backend for your AI agent.

Airtable MCP is a Database MCP server designed for developers, analysts, and data teams. It enables querying and managing databases from an AI assistant by exposing schema introspection and SQL execution as MCP tools. Key capabilities include schema introspection across tables and views, parameterised sql execution, read-only and read/write modes, and structured tool calls that work cleanly inside an LLM context. It integrates with Postgres, MySQL, SQLite, MongoDB, Redis, BigQuery, and Snowflake, and is best suited for developers, analysts, and data teams who need ad-hoc analytics without a bi tool.

Key Features

  • airtable
  • no-code
  • data
  • Schema introspection across tables and views
  • Parameterised SQL execution
  • Read-only and read/write modes

Pricing

Open Source: from Free

Pros & Cons

Pros

  • Lets the assistant write and run real queries instead of guessing
  • Read-only mode is safe to point at production-shaped data
  • Skips most ORM and CSV-shuffling boilerplate

Cons

  • Misconfigured permissions can expose sensitive data
  • Long-running queries need explicit timeouts
  • Schema drift requires reconnecting or refreshing context

Best For

  • Ad-hoc analytics without a BI tool
  • Drafting migrations and reviewing query plans
  • Letting non-SQL teammates ask questions of a database
  • Bootstrapping internal admin workflows

Our Take on Airtable MCP

Handy for ops teams whose source of truth lives in Airtable.

Alternatives to Airtable MCP

Supabase MCPDatabase

Connects AI tools to your Supabase projects

View Supabase MCP →

Frequently Asked Questions

Tags

#Database#airtable#no-code#data