airtable-plus-mcp-server

An extended Airtable MCP server for Claude Code (and other MCP clients). Provides full CRUD plus bulk import/upsert, data analysis, schema validation against known standards, and data export.

Built on domdomegg/airtable-mcp-server (MIT license) — all original tools preserved, with 6 additional power-user tools added.

Quick Start

1. Create an Airtable Personal Access Token

Go to airtable.com/create/tokens and create a token with these scopes:

• schema.bases:read
• schema.bases:write
• data.records:read
• data.records:write
• data.recordComments:read
• data.recordComments:write

Set access to the bases you need (or "All current and future bases").

2. Configure Claude Code

Add to ~/.claude.json under mcpServers:

{
  "mcpServers": {
    "airtable": {
      "type": "stdio",
      "command": "node",
      "args": ["/path/to/airtable-plus-mcp-server/dist/main.js"],
      "env": {
        "AIRTABLE_API_KEY": "patYOUR_TOKEN_HERE"
      }
    }
  }
}

3. HTTP Transport (optional)

For reusable HTTP mode:

AIRTABLE_API_KEY=patYOUR_TOKEN MCP_TRANSPORT=http PORT=3000 node dist/main.js

Then point any MCP client at http://localhost:3000/mcp.

All Tools (22)

Core Read (6 — from domdomegg)

Core Write (3 — from domdomegg)

Schema Management (5 — 4 from domdomegg + 1 new)

Comments & Attachments (3 — from domdomegg)

Extended Tools (5 — all new)

Schema Validation Patterns

The validate_schema tool includes three built-in patterns:

open_referral_uk — The Open Referral UK / HSDS 3.0 standard for service directories. Checks for tables like organizations, services, locations, contacts, phones, physical_addresses, regular_schedules, eligibility, taxonomies, and service_taxonomies with their required and optional fields.

simple_crm — A basic CRM pattern with contacts, organisations, interactions, and activities tables.

project_tracker — Project management with projects, tasks, milestones, and team_members tables.

You can also pass a custom pattern as a JSON string:

{
  "name": "My Standard",
  "description": "Custom schema pattern",
  "tables": {
    "people": {
      "requiredFields": ["name", "email"],
      "optionalFields": ["phone", "role"]
    }
  }
}

Building from Source

git clone <this-repo>
cd airtable-plus-mcp-server
npm install
npm run build

Acknowledgements

This project extends domdomegg/airtable-mcp-server (MIT license). All original tools, types, and architecture are preserved. The extended tools follow the same patterns and conventions.

License

MIT — see LICENSE.