⚡ Airtable Full-Stack MCP (airtable-fullstack-mcp)

The World's First Tri-Engine Model Context Protocol (MCP) Server for Airtable.

Programmatically orchestrate Airtable's Schema/Data APIs, Interface Designer (Dashboards, Kanbans, Field Locks, and Publishing), and the Automation Cloud Engine (In-Base Script Code Deployment, Pre-Flight Script Linting, Step Testing, and 10 Enterprise Script Archetypes) through natural language in Claude Desktop, Cursor, or Antigravity.

🚀 The Unsolved Problem

• Standard Airtable MCPs fall short: Existing open-source Airtable tools only support simple record CRUD (list_records, create_record).
• Zero Public API for Interfaces: Airtable provides no public API to create or configure Interface Designer pages, dashboards, Kanban stacks, or column inline edit permissions.
• Zero API for Automations: Airtable's official API provides no way to create, deploy, or update In-Base Automation scripts. Developers and AI agents are traditionally forced to copy-paste code manually into the Airtable UI.
• The Solution: airtable-fullstack-mcp bridges all gaps via a Unified Tri-Engine architecture:
  1. Engine 1 (Official REST & Metadata APIs + Webhooks): Creates bases, tables, custom fields, links, batch upserts records, manages real-time webhooks, and handles full record CRUD.
  2. Engine 2 (Chrome CDP Interface Designer): Connects to your running Chrome session via Chrome DevTools Protocol to build live Interface pages, group Kanbans by stages, lock sensitive audit columns, and publish changes.
  3. Engine 3 (Automation Cloud Engine - CDP & Static Analysis): Programmatically injects and publishes In-Base scripts directly into Airtable Automations, runs pre-flight static code linting against Airtable runtime constraints, discovers workflows, and captures execution test logs.

flowchart TD
    Prompt["User Prompt: 'Build a merchant portal, lock billing, and deploy an intake automation with duplicate detection'"] --> Agent["Claude / Cursor / AI Agent"]
    Agent --> MCP["airtable-fullstack-mcp (v1.2.0)"]
    
    subgraph TriEngine["Tri-Engine Execution"]
        MCP -->|REST & Metadata API| E1["Engine 1: Schema & Data\n• Base & Tables Creation\n• 10-batch Upsert & CRUD\n• Real-Time Webhooks API"]
        MCP -->|Headless Chrome CDP| E2["Engine 2: Interface Designer\n• KPI Dashboards & Charts\n• Kanban Stacking by Stage\n• Field Locks & Permissions\n• Interface Publishing"]
        MCP -->|CDP + Static Analysis| E3["Engine 3: Automation Cloud Engine (NEW)\n• In-Base Script Code Deployment\n• Pre-flight Script Linter\n• Automation Discovery & Testing\n• 10 Enterprise Script Archetypes"]
    end
    
    E1 --> LiveBase["Airtable Production Base"]
    E2 --> LiveBase
    E3 --> LiveBase

🛠️ Complete MCP Tool Suite (18 Production Tools)

1. Schema & Metadata Engine (Official Metadata API)

| Tool Name | Key Arguments | Description | | :--- | :--- | :--- | | airtable_create_base_schema | base_id, tables: [] | Provisions tables, fields, choices, currencies, and linked relationships. | | airtable_list_schema | base_id | Inspects all existing tables, field types, field IDs, and view structures. | | airtable_modify_schema | base_id, table_id_or_name, action, field_config | Adds new custom fields, renames columns, or updates table descriptions. |

2. Record & Data Engine (Official REST API)

| Tool Name | Key Arguments | Description | | :--- | :--- | :--- | | airtable_batch_upsert | base_id, table_name_or_id, records: [] | Ingests data with automatic 10-record chunking and 5 req/sec rate-limit backoff. | | airtable_query_records | base_id, table_name_or_id, filter_by_formula | Queries records server-side with formula filters, sorting, and pagination. | | airtable_manage_records | base_id, table_name_or_id, action, record_id | Single/batch record update (PATCH), deletion (DELETE), or direct ID lookup. |

3. Integrations & Webhooks Engine

| Tool Name | Key Arguments | Description | | :--- | :--- | :--- | | airtable_manage_webhook | base_id, action, notification_url | Creates, lists, deletes, and inspects webhooks for real-time external event sync. |

4. Automation Cloud Engine (NEW in v1.2.0)

| Tool Name | Key Arguments | Description | | :--- | :--- | :--- | | airtable_generate_automation_script | template, table_name, options | Generates verified JS code for Airtable's native "Run a script" action across 10 archetypes. | | airtable_validate_automation_script | script_code | Pre-flight static linter verifying script compatibility with Airtable's In-Base runtime constraints. | | airtable_deploy_automation_script | base_id, workflow_id_or_name, script_code | Programmatically injects and publishes In-Base scripts directly into Airtable Automations via CDP. | | airtable_list_automations | base_id | Discovers all Automation workflows, IDs, trigger types, and active toggle statuses via CDP. | | airtable_test_automation_step | base_id, workflow_id_or_name | Triggers "Test step" inside an automation action and returns live console logs and output variables. |

5. Interface Designer Engine (Chrome CDP Browser Automation)

| Tool Name | Key Arguments | Description | | :--- | :--- | :--- | | airtable_create_interface_page | base_id, page_name, layout_type, table_name | Creates a new Interface page (Dashboard, Kanban, Grid, Record Review). | | airtable_rebrand_interface | base_id, title, sidebar_bundle_name | Double-click automation to rename interface header and sidebar folder bundles. | | airtable_configure_kanban | base_id, stack_by_field, card_fields: [] | Stacks Kanban columns by operational stages and displays front-of-card badges. | | airtable_set_field_permissions | base_id, locked_columns: [], editable_columns: [] | Sets column-level inline edit locks (Edit this column inline = OFF). | | airtable_configure_detail_sheet | base_id, title_field, locked_fields: [] | Configures expandable side-sheet detail cards and toggles field-level lock switches. | | airtable_publish_interface | base_id | Finalizes and publishes all interface draft changes, confirming modals. |

⚡ Automation Script Archetypes (airtable_generate_automation_script)

airtable_generate_automation_script supports 10 production-ready enterprise archetypes:

1. master_intake_processor: Collision-safe sequential zero-padded auto-IDs (VR-C-000001), normalized multi-field duplicate detection (regex phone cleaning, email trim), disqualification / fast-track qualification branching, and dynamic SLA deadline timestamps.
2. relational_child_sync: Auto-instantiates 1-to-many child records across linked tables (Agreements, Documents, Training, Screening) with 50-record batch chunking.
3. cross_table_reconciliation: Queries child records, aggregates scores or completion statuses, and reconciles back to the parent record.
4. compliance_safeguard: Intercepts premature status transitions; checks required gates; reverts to Hold with audit notes if any are missing.
5. document_expiry_monitor: Scheduled daily monitor calculating days to expiration, updating badges ("Expired", "Expiring Soon").
6. external_api_dispatch: Calls external REST APIs using remoteFetchAsync with bearer token auth, error handling, and response logging.
7. tally_fillout_mapper: Sanitized intake payload mapping from Tally, Fillout, or Typeform webhooks.
8. stripe_paypal_reconciliation: Payment charge reconciliation and status updates.
9. unique_id_generator: Standalone sequential ID assignment.
10. deduplication_sync: Standalone duplicate detection and record flagging.

⚡ Quickstart

1. Launch Chrome with Remote Debugging

To enable Interface Designer and Automation Cloud browser automation, launch Chrome with remote debugging:

macOS:

/Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome --remote-debugging-port=9222 &

Linux:

google-chrome --remote-debugging-port=9222 &

Windows:

& "C:\Program Files\Google\Chrome\Application\chrome.exe" --remote-debugging-port=9222

2. Configure Claude Desktop / Cursor

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "airtable-fullstack": {
      "command": "npx",
      "args": ["-y", "airtable-fullstack-mcp"],
      "env": {
        "AIRTABLE_API_KEY": "patXXXXXXXXXXXXXX",
        "AIRTABLE_CDP_PORT": "9222"
      }
    }
  }
}

Or run directly from local source:

{
  "mcpServers": {
    "airtable-fullstack": {
      "command": "node",
      "args": ["/Users/praroopanand/Realm/Code/Airtable-MCP/dist/index.js"],
      "env": {
        "AIRTABLE_API_KEY": "patXXXXXXXXXXXXXX",
        "AIRTABLE_CDP_PORT": "9222"
      }
    }
  }
}

📦 Developer Scripts

# Clone the repository
git clone [email protected]:Praroop1435/airtable-fullstack-mcp.git
cd airtable-fullstack-mcp

# Install dependencies
npm install

# Build TypeScript
npm run build

# Run comprehensive E2E test suite (18 tools)
npm test

👤 Author & License

• Author: Praroop Anand (@Praroop1435)
• License: MIT