Skip to main content
Glama
Airtable MCP Server

Airtable MCP Server

by loticdigital

Airtable MCP Server

A comprehensive Model Context Protocol (MCP) server that provides full access to the Airtable Web API, including enterprise features. This server enables AI assistants to create, manage, and interact with Airtable bases, tables, fields, records, views, and webhooks.

Features

πŸ—οΈ Base Management

  • List Bases: Get all accessible bases in a workspace

  • Get Base Schema: Retrieve complete base structure with tables and fields

  • Delete Base: Remove bases (Enterprise only)

πŸ“Š Table Management

  • List Tables: Get all tables in a base

  • Create Table: Create new tables with comprehensive field configurations

  • Update Table: Modify table properties and metadata

  • Delete Table: Remove tables (with proper permissions)

πŸ”§ Field Management

  • List Fields: Get all fields in a table

  • Create Field: Add new fields with 25+ field types supported

  • Update Field: Modify existing field properties and options

  • Delete Field: Remove fields (with data considerations)

Supported Field Types

  • Basic Fields: singleLineText, multilineText, email, phoneNumber, richText, url

  • Numeric Fields: number, currency, percent

  • Date/Time Fields: date, dateTime, duration

  • Selection Fields: singleSelect, multipleSelects

  • Interactive Fields: rating, checkbox

  • Advanced Fields: formula, rollup, lookup, multipleRecordLinks

  • Specialized Fields: attachment, barcode, button, count, autoNumber

πŸ“ Record Operations

  • List Records: Basic record retrieval

  • Advanced List Records: Full filtering, sorting, pagination, and field selection

  • Get Record: Fetch individual record details

  • Create Record: Add single records

  • Update Record: Modify existing records

  • Delete Record: Remove records

  • Batch Create Records: Create multiple records efficiently

  • Batch Update Records: Update multiple records in one request

  • Batch Delete Records: Delete multiple records efficiently

  • Search Records: Find records using field-based search

πŸ‘οΈ View Management

  • List Views: Get all views in a table

  • Get View: Retrieve view configuration

  • Create View: Create new views (grid, form, calendar, gallery, kanban, timeline, gantt)

  • Update View: Modify view properties, filters, and sorting

  • Delete View: Remove views

πŸ”” Webhook Management

  • List Webhooks: Get all webhooks for a base

  • Create Webhook: Set up real-time notifications

  • Update Webhook: Modify webhook configuration

  • Delete Webhook: Remove webhook subscriptions

  • Get Webhook Payloads: Retrieve webhook notification history

🏒 Enterprise Features (Enterprise Scale Plans)

  • User Management: Create, update, and deactivate users

  • Workspace Management: Manage workspace access and permissions

  • Audit Logs: Create and retrieve comprehensive audit logs

  • Share Link Management: Control base sharing across organization

  • Collaborator Management: Add/remove users from bases and workspaces

  • Bulk Operations: Perform enterprise-scale batch operations

Related MCP server: Airtable MCP Server

Installation

npm install @loticdigital/airtable-mcp-server

Configuration

Set your Airtable API key as an environment variable:

export AIRTABLE_API_KEY=your_airtable_api_key_here

Usage

With Claude Desktop

Add to your Claude Desktop configuration:

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@loticdigital/airtable-mcp-server"],
      "env": {
        "AIRTABLE_API_KEY": "your_airtable_api_key_here"
      }
    }
  }
}

With MCP Inspector

npx @modelcontextprotocol/inspector npx @loticdigital/airtable-mcp-server

API Capabilities

Rate Limits & Best Practices

  • Rate Limit: 5 requests per second per base

  • API Call Limits:

    • Free: 1,000 calls per workspace per month

    • Team: 100,000 calls per workspace per month

    • Business/Enterprise: Unlimited calls

  • Pagination: Automatic handling of paginated responses

  • Batch Operations: Efficient bulk processing for multiple records

  • Error Handling: Comprehensive error recovery with exponential backoff

Advanced Features

  • External ID Mapping: Support for upsert operations

  • Data Validation: Comprehensive field validation

  • Conflict Resolution: Handle concurrent updates gracefully

  • Change Tracking: Monitor and log all data modifications

  • Performance Optimization: Caching and selective field requests

Security Features

  • Token Management: Secure PAT handling

  • Data Protection: Input validation and sanitization

  • Enterprise Security: Audit logging and compliance support

  • Access Controls: Proper permission handling

Field Configuration Examples

Basic Fields

{
  "name": "Title",
  "type": "singleLineText",
  "description": "Main title field"
}

Numeric Fields

{
  "name": "Price",
  "type": "currency",
  "options": {
    "precision": 2,
    "symbol": "$"
  }
}

Selection Fields

{
  "name": "Status",
  "type": "singleSelect",
  "options": {
    "choices": [
      { "name": "Active", "color": "greenBright" },
      { "name": "Pending", "color": "yellowBright" },
      { "name": "Inactive", "color": "redBright" }
    ]
  }
}

Advanced Fields

{
  "name": "Full Name",
  "type": "formula",
  "options": {
    "formula": "CONCATENATE({First Name}, ' ', {Last Name})"
  }
}

Webhook Configuration

{
  "notificationUrl": "https://your-server.com/webhook",
  "specification": {
    "options": {
      "filters": {
        "dataTypes": ["tableData"],
        "recordChangeScope": "tblXXXXXXXXXXXXXX"
      }
    }
  }
}

Error Handling

The server implements comprehensive error handling:

  • 401 Unauthorized: Invalid or expired token

  • 403 Forbidden: Insufficient permissions

  • 404 Not Found: Resource doesn't exist

  • 422 Unprocessable Entity: Invalid field configuration

  • 429 Too Many Requests: Rate limit exceeded

  • 500 Internal Server Error: Airtable service issue

Development

# Clone the repository
git clone https://github.com/loticdigital/airtable-mcp

# Install dependencies
npm install

# Build the project
npm run build

# Run with inspector
npm run inspector

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

MIT License - see LICENSE file for details.

Support

For issues and questions:

Changelog

v0.6.0 (Latest)

  • ✨ Major Feature Expansion: Added comprehensive Airtable Web API support

  • πŸ”§ 25+ Field Types: Support for all Airtable field types including advanced fields

  • πŸ‘οΈ View Management: Complete view CRUD operations

  • πŸ”” Webhook Support: Real-time notifications and webhook management

  • πŸ“Š Advanced Record Operations: Batch operations, advanced filtering, pagination

  • 🏒 Enterprise Features: User management, audit logs, workspace management

  • πŸ›‘οΈ Enhanced Security: Comprehensive validation and error handling

  • ⚑ Performance: Optimized batch operations and caching strategies

v0.5.1

  • Basic table and field management

  • Simple record CRUD operations

  • Limited field type support

Available Tools

32 tools
advanced_list_recordsB

List records with advanced filtering, sorting, and pagination

Inputs: base_id (required), table_name (required), filter_by_formula, sort, +8 more.

batch_create_recordsC

Create multiple records in a single request

Inputs: base_id (required), table_name (required), records (required), typecast.

batch_delete_recordsB

Delete multiple records in a single request

Inputs: base_id (required), table_name (required), record_ids (required).

batch_update_recordsB

Update multiple records in a single request

Inputs: base_id (required), table_name (required), records (required), typecast.

create_fieldB

Create a new field in a table

Inputs: base_id (required), table_id (required), field (required).

create_recordB

Create a new record in a table

Inputs: base_id (required), table_name (required), fields (required).

create_tableC

Create a new table in a base

Inputs: base_id (required), table_name (required), description, fields.

create_viewC

Create a new view in a table

Inputs: base_id (required), table_id (required), view (required).

create_webhookC

Create a new webhook for real-time notifications

Inputs: base_id (required), notification_url (required), specification (required).

delete_baseB

Delete a base (Enterprise only)

Inputs: base_id (required).

delete_fieldA

Delete a field from a table

Inputs: base_id (required), table_id (required), field_id (required).

delete_recordC

Delete a record from a table

Inputs: base_id (required), table_name (required), record_id (required).

delete_viewB

Delete a view from a table

Inputs: base_id (required), table_id (required), view_id (required).

delete_webhookB

Delete a webhook

Inputs: base_id (required), webhook_id (required).

get_base_schemaA

Get complete base schema including all tables and fields. For large schemas, returns a cache ID to fetch data in chunks.

Inputs: base_id, cache_id, chunk_offset, table_ids, +1 more.

get_base_summaryA

Get a lightweight summary of all tables in a base (names, IDs, and field counts only)

Inputs: base_id (required).

get_recordB

Get a single record by its ID

Inputs: base_id (required), table_name (required), record_id (required).

get_viewC

Get view configuration

Inputs: base_id (required), table_id (required), view_id (required).

get_webhook_payloadsC

Get webhook notification history

Inputs: base_id (required), webhook_id (required), cursor, limit.

list_basesA

List all accessible Airtable bases

Inputs: no named parameters.

list_cached_schemasA

List all cached schemas with their cache IDs and metadata

Inputs: no named parameters.

list_fieldsB

List all fields in a table

Inputs: base_id (required), table_id (required).

list_recordsC

List records in a table

Inputs: base_id (required), table_name (required), max_records.

list_tablesB

List all tables in a base

Inputs: base_id (required).

list_viewsB

List all views in a table

Inputs: base_id (required), table_id (required).

list_webhooksB

List all webhooks for a base

Inputs: base_id (required).

search_recordsB

Search for records in a table

Inputs: base_id (required), table_name (required), field_name (required), value (required).

update_fieldC

Update a field in a table

Inputs: base_id (required), table_id (required), field_id (required), updates (required).

update_recordB

Update an existing record in a table

Inputs: base_id (required), table_name (required), record_id (required), fields (required).

update_tableC

Update a table's schema

Inputs: base_id (required), table_id (required), name, description.

update_viewC

Update an existing view

Inputs: base_id (required), table_id (required), view_id (required), updates (required).

update_webhookB

Update an existing webhook

Inputs: base_id (required), webhook_id (required), updates (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 32 tools

    Disambiguation5/5

    Each tool targets a distinct resource and action (e.g., record, field, table, view, webhook) with clear purposes. Even similar operations like list_records, search_records, and advanced_list_records are well-differentiated through descriptions.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern in snake_case (e.g., create_record, list_tables, delete_view), with no mixing of conventions.

    Tool Count4/5

    32 tools is on the higher side but justified by the broad coverage of Airtable's API (bases, tables, fields, records, views, webhooks) with CRUD and batch operations. The count is slightly excessive but still reasonable for the domain.

    Completeness4/5

    The tool surface covers most major operations including CRUD for records, tables, fields, views, and webhooks. Notable gaps include missing update_base, delete_table, and get_field, but core workflows are well covered.

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides tools for AI assistants to interact with Airtable databases, enabling CRUD operations on Airtable bases and tables.
      7 npm
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables comprehensive interaction with Airtable bases including record management with automatic type conversion for all field types. It supports batch operations, schema discovery, and secure authentication using Personal Access Tokens.
      18 npm
      MIT
    • A
      license
      Not graded
      quality
      Not graded
      maintenance
      Enables comprehensive interaction with the Airtable Web API to manage bases, tables, and records. It supports advanced features like batch record operations, CSV import/export, attachment uploads, and webhook management.
      -