The Airtable MCP Server allows programmatic management of Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.
Capabilities include:
Base Management: List accessible bases, list tables in a base, create or update tables
Field Management: Create or update fields (including name, options, and descriptions)
Record Operations: List, create, update, delete, or search records; retrieve a single record by ID
Support for Various Field Types: singleLineText, multilineText, email, phoneNumber, number, currency, date, singleSelect, multiSelect, etc.
Customization: Define field options and descriptions, and use specific colors for select fields
Enables programmatic management of Airtable bases, tables, fields, and records, with capabilities for creating and modifying tables, adding and updating fields with various data types, and performing CRUD operations on records.
Airtable MCP Server
A Model Context Protocol server that provides tools for interacting with Airtable's API. This server enables programmatic management of Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.
This MCP server features a specialized implementation that allows it to build tables in stages, leveraging Claude's agentic capabilities and minimizing the failure rate typically seen in other MCP servers for Airtable when building complex tables. It also includes system prompt and project knowledge markdown files to provide additional guidance for the LLM when leveraging projects in Claude Desktop.
Requirements: Node.js
Install Node.js (version 18 or higher) and npm from nodejs.org
Verify installation:
node --version npm --version
⚠️ Important: Before running, make sure to setup your Airtable API key
Obtaining an Airtable API Key
Log in to your Airtable account at airtable.com
Create a personal access token at Airtable's Builder Hub
In the Personal access token section select these scopes:
data.records:read
data.records:write
schema.bases:read
schema.bases:write
Select the workspace or bases you want to give access to the personal access token
Keep this key secure - you'll need it for configuration
Installation
Method 1: Using npx (Recommended)
Navigate to the Claude configuration directory:
Windows:
C:\Users\NAME\AppData\Roaming\Claude
macOS:
~/Library/Application Support/Claude/
You can also find these directories inside the Claude Desktop app: Claude Desktop > Settings > Developer > Edit Config
Create or edit
claude_desktop_config.json
:
Note: For Windows paths, use double backslashes (\) or forward slashes (/).
Method 2: Using mcp-installer:
mcp-installer is a MCP server to install other MCP servers.
Install mcp-installer
Install the Airtable MCP server by prompting Claude Desktop:
Claude will install the server, modify the configuration file and set the environment variable AIRTABLE_API_KEY to your Airtable API key.
Method 3: Local Development Installation
If you want to contribute or modify the code run this in your terminal:
Then modify the Claude Desktop configuration file to use the local installation:
Verifying Installation
Start Claude Desktop
The Airtable MCP server should be listed in the "Connected MCP Servers" section
Test with a simple command:
Features
Available Operations
Base Management
list_bases
: List all accessible Airtable baseslist_tables
: List all tables in a basecreate_table
: Create a new table with fieldsupdate_table
: Update a table's name or description
Field Management
create_field
: Add a new field to a tableupdate_field
: Modify an existing field
Record Operations
list_records
: Retrieve records from a tablecreate_record
: Add a new recordupdate_record
: Modify an existing recorddelete_record
: Remove a recordsearch_records
: Find records matching criteriaget_record
: Get a single record by its ID
Field Types
singleLineText
: Single line text fieldmultilineText
: Multi-line text areaemail
: Email address fieldphoneNumber
: Phone number fieldnumber
: Numeric field with optional precisioncurrency
: Money field with currency symboldate
: Date field with format optionssingleSelect
: Single choice from optionsmultiSelect
: Multiple choices from options
Field Colors
Available colors for select fields:
blueBright
,redBright
,greenBright
yellowBright
,purpleBright
,pinkBright
grayBright
,cyanBright
,orangeBright
blueDark1
,greenDark1
Contributing
We welcome contributions to improve the Airtable MCP server! Here's how you can contribute:
Fork the Repository
Click the "Fork" button in the top right
Clone your fork locally:
git clone https://github.com/your-username/airtable-mcp.git
Create a Feature Branch
git checkout -b feature/your-feature-nameMake Your Changes
Follow the existing code style
Add tests if applicable
Update documentation as needed
Commit Your Changes
git add . git commit -m "feat: add your feature description"Push to Your Fork
git push origin feature/your-feature-nameCreate a Pull Request
Go to your fork on GitHub
Click "New Pull Request"
Select your feature branch
Describe your changes in detail
Development Guidelines
Use TypeScript for new code
Follow semantic commit messages
Update documentation for new features
Add examples for new functionality
Test your changes thoroughly
Getting Help
Open an issue for bugs or feature requests
Join discussions in existing issues
Ask questions in pull requests
Your contributions help make this tool better for everyone. Whether it's:
Adding new features
Fixing bugs
Improving documentation
Suggesting enhancements
We appreciate your help in making the Airtable MCP server more powerful and user-friendly!
License
Made with ❤️ by the Airtable MCP community
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
A Model Context Protocol server that provides tools for programmatically managing Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.
Related Resources
Related MCP Servers
- -securityAlicense-qualityA Model Context Protocol server that provides read and write access to Airtable databases. This server enables LLMs to inspect database schemas, then read and write records.Last updated -2,956307TypeScriptMIT License
- -securityFlicense-qualityA Model Context Protocol server built with mcp-framework that allows users to create and manage custom tools for processing data, integrating with the Claude Desktop via CLI.Last updated -325
- AsecurityAlicenseAqualityA Model Context Protocol server that automatically reads the Claude Desktop configuration file and presents all available MCP services in an easy-to-copy format at the top of the tools list.Last updated -1183MIT License
- AsecurityFlicenseAqualityA Model Context Protocol server that allows integration with Claude Desktop by creating and managing custom tools that can be executed through the MCP framework.Last updated -31