Which integrations are available for this server?

Provides tools for [Airtable](/mcp/servers/integrations/airtable) data management, including base and table operations, record creation, reading, updating, and deletion, schema management, and data filtering—all accessible through natural language commands.

Airtable MCP Server

Trust Score MCP TypeScript AI Agent Security Protocol

A Model Context Protocol (MCP) server for Airtable with full CRUD operations, schema management, webhooks, batch operations, and AI-powered analytics.

Version 3.2.6 | MCP Protocol 2024-11-05

Overview

This server provides comprehensive Airtable integration through the Model Context Protocol, enabling natural language interactions with your Airtable data. It includes 33 tools for data operations and 10 AI prompt templates for intelligent analytics.

Key Features

Full CRUD Operations — Create, read, update, and delete records with filtering and pagination
Schema Management — Create and modify tables, fields, and views programmatically
Batch Operations — Process up to 10 records per operation for improved performance
Webhook Management — Set up real-time notifications for data changes
AI Analytics — Predictive analytics, natural language queries, and automated insights
Multi-Base Support — Discover and work with multiple bases dynamically
Type Safety — Full TypeScript support with comprehensive type definitions

Related MCP server: Airtable MCP

Prerequisites

Node.js 14 or later
An Airtable account with a Personal Access Token
Your Airtable Base ID (optional—can be discovered via the list_bases tool)

Installation

Option 1: NPM (Recommended)

npm install -g @rashidazarang/airtable-mcp

Option 2: Clone from GitHub

git clone https://github.com/rashidazarang/airtable-mcp.git cd airtable-mcp npm install

Configuration

Step 1: Get Your Airtable Credentials

Personal Access Token: Go to Airtable Account Settings and create a token with these scopes:
- data.records:read — Read records
- data.records:write — Create, update, delete records
- schema.bases:read — View table schemas
- schema.bases:write — Create and modify tables and fields
- webhook:manage — Manage webhooks (optional)
Base ID: Open your Airtable base and copy the ID from the URL: https://airtable.com/[BASE_ID]/...

Step 2: Environment Variables

Create a .env file in your project directory:

AIRTABLE_TOKEN=your_personal_access_token AIRTABLE_BASE_ID=your_base_id # Optional in v3.2.5+

Note: The Base ID is optional. You can start without one and use the list_bases tool to discover accessible bases, or specify base IDs per tool call.

Step 3: Configure Your MCP Client

Add to your Claude Desktop configuration:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

{ "mcpServers": { "airtable": { "command": "npx", "args": ["@rashidazarang/airtable-mcp"], "env": { "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN", "AIRTABLE_BASE_ID": "YOUR_BASE_ID" } } } }

To start without a base ID (and discover bases dynamically):

{ "mcpServers": { "airtable": { "command": "npx", "args": ["@rashidazarang/airtable-mcp"], "env": { "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN" } } } }

Step 4: Restart Your MCP Client

Restart Claude Desktop or your MCP client to load the server.

Usage

Once configured, interact with your Airtable data using natural language:

Basic Operations

"List all my accessible Airtable bases"
"Show me all records in the Projects table"
"Create a new task with priority 'High' and due date tomorrow"
"Update the status of task ID rec123 to 'Completed'"
"Search for records where Status equals 'Active'"

Schema Management

"Show me the complete schema for this base"
"Create a new table called 'Tasks' with Name, Priority, and Due Date fields"
"Add a Status field to the Projects table"

Batch Operations

"Create 5 new records at once in the Tasks table"
"Update multiple records with new status values"
"Delete these 3 records in one operation"

Webhooks

"Create a webhook for my table that notifies https://my-app.com/webhook"
"List all active webhooks in my base"

TypeScript Usage

import { AirtableMCPServer, ListRecordsInput, AnalyzeDataPrompt } from '@rashidazarang/airtable-mcp/types'; const server = new AirtableMCPServer(); const params: ListRecordsInput = { table: 'Tasks', maxRecords: 10, filterByFormula: "Status = 'Active'" }; const records = await server.handleToolCall('list_records', params);

Available Tools

Data Operations (7 tools)

Tool	Description
`list_tables`	Get all tables in your base with schema information
`list_records`	Query records with filtering and pagination
`get_record`	Retrieve a single record by ID
`create_record`	Add new records to any table
`update_record`	Modify existing record fields
`delete_record`	Remove records from a table
`search_records`	Advanced search with Airtable formulas

Schema Discovery (6 tools)

Tool	Description
`list_bases`	List all accessible bases with permissions
`get_base_schema`	Get complete schema for any base
`describe_table`	Get detailed table and field specifications
`list_field_types`	Reference guide for available field types
`get_table_views`	List all views for a table

Table Management (3 tools)

Tool	Description
`create_table`	Create tables with custom field definitions
`update_table`	Modify table names and descriptions
`delete_table`	Remove tables (requires confirmation)

Field Management (3 tools)

Tool	Description
`create_field`	Add fields to existing tables
`update_field`	Modify field properties and options
`delete_field`	Remove fields (requires confirmation)

Batch Operations (4 tools)

Tool	Description
`batch_create_records`	Create up to 10 records at once
`batch_update_records`	Update up to 10 records simultaneously
`batch_delete_records`	Delete up to 10 records in one operation
`batch_upsert_records`	Update or create records based on key fields

Webhook Management (5 tools)

Tool	Description
`list_webhooks`	View all configured webhooks
`create_webhook`	Set up real-time notifications
`delete_webhook`	Remove webhook configurations
`get_webhook_payloads`	Retrieve notification history
`refresh_webhook`	Extend webhook expiration

Views and Attachments (3 tools)

Tool	Description
`create_view`	Create views (grid, form, calendar, etc.)
`get_view_metadata`	Get view details including filters
`upload_attachment`	Attach files from URLs

Base Management (3 tools)

Tool	Description
`create_base`	Create new bases with initial structure
`list_collaborators`	View collaborators and permissions
`list_shares`	List shared views and configurations

AI Intelligence Suite

Ten AI prompt templates for advanced analytics:

Prompt	Description
`analyze_data`	Statistical analysis with anomaly detection
`create_report`	Intelligent report generation
`data_insights`	Business intelligence and pattern discovery
`optimize_workflow`	Automation recommendations
`smart_schema_design`	Database optimization suggestions
`data_quality_audit`	Quality assessment and remediation
`predictive_analytics`	Forecasting and trend prediction
`natural_language_query`	Process questions with context awareness
`smart_data_transformation`	AI-assisted data processing
`automation_recommendations`	Workflow optimization with cost-benefit analysis

Advanced Configuration

Smithery Cloud

{ "mcpServers": { "airtable": { "command": "npx", "args": [ "@smithery/cli", "run", "@rashidazarang/airtable-mcp", "--token", "YOUR_TOKEN", "--base", "YOUR_BASE_ID" ] } } }

Direct Node.js Execution

{ "mcpServers": { "airtable": { "command": "node", "args": [ "/path/to/airtable-mcp/airtable_simple.js", "--token", "YOUR_TOKEN", "--base", "YOUR_BASE_ID" ] } } }

Testing

TypeScript

npm install npm run test:types # Type checking npm run test:ts # Full test suite npm run build && npm run start:ts

JavaScript

export AIRTABLE_TOKEN=your_token export AIRTABLE_BASE_ID=your_base_id node airtable_simple.js & ./test_v1.6.0_comprehensive.sh

Troubleshooting

Connection Refused

Verify the MCP server is running
Check that port 8010 is available
Restart your MCP client

Invalid Token

Verify your Personal Access Token is correct
Confirm the token has the required scopes
Check for extra whitespace in credentials

Base Not Found

Confirm your Base ID is correct
Verify your token has access to the base

Port Conflicts

lsof -ti:8010 | xargs kill -9

Project Structure

airtable-mcp/ ├── src/ │ ├── typescript/ # TypeScript implementation (primary) │ └── javascript/ # JavaScript implementation ├── dist/ # Compiled output ├── docs/ # Documentation ├── tests/ # Test files ├── examples/ # Usage examples ├── types/ # TypeScript definitions └── bin/ # CLI executables