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: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:
- 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: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 bases
list_tables: List all tables in a base
create_table: Create a new table with fields
update_table: Update a table's name or description
Field Management
create_field: Add a new field to a table
update_field: Modify an existing field
Record Operations
list_records: Retrieve records from a table
create_record: Add a new record
update_record: Modify an existing record
delete_record: Remove a record
search_records: Find records matching criteria
get_record: Get a single record by its ID
Field Types
singleLineText: Single line text field
multilineText: Multi-line text area
email: Email address field
phoneNumber: Phone number field
number: Numeric field with optional precision
currency: Money field with currency symbol
date: Date field with format options
singleSelect: Single choice from options
multiSelect: 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
- Create a Feature Branch
- Make Your Changes
- Commit Your Changes
- Push to Your Fork
- Create a Pull Request
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
MIT
Made with by the Airtable MCP community
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: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:
- 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: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 bases
list_tables: List all tables in a base
create_table: Create a new table with fields
update_table: Update a table's name or description
Field Management
create_field: Add a new field to a table
update_field: Modify an existing field
Record Operations
list_records: Retrieve records from a table
create_record: Add a new record
update_record: Modify an existing record
delete_record: Remove a record
search_records: Find records matching criteria
get_record: Get a single record by its ID
Field Types
singleLineText: Single line text field
multilineText: Multi-line text area
email: Email address field
phoneNumber: Phone number field
number: Numeric field with optional precision
currency: Money field with currency symbol
date: Date field with format options
singleSelect: Single choice from options
multiSelect: 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
- Create a Feature Branch
- Make Your Changes
- Commit Your Changes
- Push to Your Fork
- Create a Pull Request
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
MIT
Made with by the Airtable MCP community