What can you do with this server?

The Airtable MCP server enables comprehensive natural language interaction with Airtable through 42 tools covering data management, schema manipulation, webhooks, governance, and AI-driven analytics. Data Operations: Full CRUD (create, read, update, delete) with advanced filtering, sorting, pagination, and Airtable formula support. Batch operations handle up to 10 records simultaneously. Upsert operations update or create records based on merge fields. Write operations include dryRun for diff review, conflict detection, and resolution strategies (fail, server merge, client merge). Schema Management: Programmatically create, update, and delete tables, fields, and views. Describe base or table schemas with configurable detail levels. Create views (grid, form, calendar, etc.) and manage field types. Record Comments: List, create, update, and delete comments on records. Webhooks: Configure real-time notifications for data changes—list, create, delete, refresh expiration, and retrieve payloads. Governance & Compliance: Enforce allow-lists for bases, tables, and operations. Apply PII masking policies (mask, hash, drop) with audit logging and exception tracking with remediation proposals. Base Management: Discover and work with multiple bases dynamically, create new bases, list collaborators and shared configurations. AI Analytics Suite: 10 prompt templates for statistical analysis, intelligent reporting, business intelligence, workflow optimization, schema design, data quality audits, predictive analytics, natural language queries, data transformation, and automation recommendations. Additional Features: User identity verification (whoami), attachment uploads from URLs, idempotency keys for safe retries, typecast support for automatic data conversion, and full TypeScript type safety.

Which integrations are available for this server?

Provides tools for 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.

How do I use Airtable MCP?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Airtable MCP show me all active projects with high priority" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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, record comments, webhooks, batch operations, governance controls, and AI-powered analytics.

Version 4.0.0 | MCP Protocol 2024-11-05 | npm

Quick Start

No installation required — just add this to your Claude Desktop config and restart:

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

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

That's it. npx downloads and runs the server automatically. No git clone, no npm install.

Get your token at airtable.com/create/tokens. Get your Base ID from the URL when viewing your base: https://airtable.com/[BASE_ID]/...

Related MCP server: MariaDB Reader MCP Server

Overview

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

Key Features

Full CRUD Operations — Create, read, update, and delete records with filtering and pagination
Record Comments — List, create, update, and delete comments on records
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
Governance & Compliance — Allow-list governance, PII masking, and exception tracking
User Identity — Verify token identity with the whoami tool
AI Analytics — 10 prompt templates for 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

Prerequisites

Node.js 18 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 npm run build

Configuration

Step 1: Get Your Airtable Credentials

Personal Access Token: Go to airtable.com/create/tokens and create a token with these scopes:
- data.records:read — Read records
- data.records:write — Create, update, delete records
- data.recordComments:read — Read record comments
- data.recordComments:write — Create, update, delete comments
- schema.bases:read — View table schemas
- schema.bases:write — Create and modify tables and fields
- user.email:read — Read user identity (whoami)
- 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: 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" } } } }

Claude Code Configuration

If you use Claude Code, this project includes a configuration skill at .claude/skills/configure-mcp that can assist with agent-assisted MCP setup. Run /configure-mcp inside Claude Code to get guided configuration.

Step 3: 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"

Record Comments

"Show me all comments on record rec123"
"Add a comment to this record: 'Reviewed and approved'"
"Update my comment to say 'Needs revision'"

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

"List all active webhooks in my base"
"Create a webhook for changes to my Projects table"

Available Tools (42)

Core Operations (4 tools)

Tool	Description
`list_bases`	List all accessible bases with permissions
`describe`	Describe base or table schema (supports detail levels)
`query`	Query records with filtering, sorting, and pagination
`search_records`	Advanced search with Airtable formulas

Record CRUD (5 tools)

Tool	Description
`list_records`	List records with field selection and pagination
`get_record`	Retrieve a single record by ID
`create`	Create new records (requires dryRun diff review)
`update`	Update existing records (requires dryRun diff review)
`delete_record`	Remove a record from a table

Upsert (2 tools)

Tool	Description
`upsert`	Update or create records based on merge fields
`batch_upsert_records`	Batch upsert with merge-on fields

Schema Discovery (4 tools)

Tool	Description
`list_tables`	Get all tables in a base with schema info
`get_base_schema`	Get complete schema for any base
`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 (3 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

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 & 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

Record Comments (4 tools)

Tool	Description
`list_comments`	List comments on a record
`create_comment`	Add a comment to a record
`update_comment`	Edit an existing comment
`delete_comment`	Remove a comment

User Info (1 tool)

Tool	Description
`whoami`	Get current user identity and scopes

Governance & Administration (2 tools)

Tool	Description
`list_governance`	Return governance allow-lists and PII masking policies
`list_exceptions`	List recent exceptions and remediation proposals

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" ], "env": { "AIRTABLE_TOKEN": "YOUR_TOKEN", "AIRTABLE_BASE_ID": "YOUR_BASE_ID" } } } }

Environment Variables

Variable	Required	Description
`AIRTABLE_TOKEN`	Yes	Personal Access Token
`AIRTABLE_BASE_ID`	No	Default base ID (discoverable via `list_bases`)
`LOG_LEVEL`	No	Logging level (default: `info`)
`MCP_HTTP_PORT`	No	Enable HTTP transport for hosted deployments

Testing

npm install npm run build # Compile TypeScript npm run test:types # Type checking npm test # Run test suite

Troubleshooting

Connection Issues

Verify the MCP server is running
Restart your MCP client
Check that your token has the required scopes

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
Use list_bases to discover accessible bases

Project Structure

airtable-mcp/ ├── src/typescript/ # TypeScript implementation │ ├── app/ │ │ ├── tools/ # 42 tool implementations │ │ ├── prompts/ # 10 AI prompt registrations │ │ ├── airtable-client.ts │ │ ├── governance.ts │ │ └── context.ts │ └── airtable-mcp-server.ts ├── dist/ # Compiled output ├── docs/ # Documentation ├── types/ # TypeScript definitions └── bin/ # CLI executables

Documentation

Contributing

Contributions are welcome. Please open an issue first to discuss major changes.

License

MIT License — see LICENSE for details.

Support

Install Server

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

Resources

Need Help?

Report Issue

Reddit Discussion

Related Servers

Tools

View all tools