airtable-plus-mcp-server

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)

| Tool | Description | |------|-------------| | list_bases | List all accessible bases | | list_tables | List tables in a base (with detail level control) | | describe_table | Get detailed info about a specific table | | list_records | List/filter/sort records from a table | | search_records | Full-text search across text fields | | get_record | Get a single record by ID |

Core Write (3 — from domdomegg)

| Tool | Description | |------|-------------| | create_record | Create a single record | | update_records | Update one or more records | | delete_records | Delete one or more records |

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

| Tool | Description | |------|-------------| | create_table | Create a new table with field definitions | | update_table | Update table name/description | | create_field | Add a field to an existing table | | update_field | Update field name/description | | delete_field | NEW — Delete a field from a table |

Comments & Attachments (3 — from domdomegg)

| Tool | Description | |------|-------------| | create_comment | Add a comment to a record | | list_comments | List comments on a record | | upload_attachment | Upload an attachment to a record field |

Extended Tools (5 — all new)

| Tool | Description | |------|-------------| | bulk_import | Import up to 1000 records with batching (groups of 10) and rate limiting. Handles errors per-batch with optional stop-on-error. | | bulk_upsert | Create-or-update records based on merge field(s). Batched with rate limiting. Ideal for syncing data from external sources. | | summarise_table | Analyse a table: record count, per-field completeness, value distributions, numeric stats (min/max/mean/sum), unique value counts. | | export_table | Export table data as JSON or CSV. Supports filtering, field selection, sorting. | | validate_schema | Validate a base against known patterns. Built-in patterns: open_referral_uk (HSDS 3.0), simple_crm, project_tracker. Also accepts custom patterns as JSON. |

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.