Airtable
Enables AI assistants to interact with Airtable databases by listing accessible bases and retrieving detailed schema information. Supports secure authentication and provides tools for exploring Airtable base structures through natural language.
What is Airtable?
Airtable is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enables ai assistants to interact with airtable databases by listing accessible bases and retrieving detailed schema information. supports secure authentication and provides tools for exploring airtab...
Enables AI assistants to interact with Airtable databases by listing accessible bases and retrieving detailed schema information. Supports secure authentication and provides tools for exploring Airtable base structures through natural language.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enables AI assistants to interact with Airtable databases by
Use Cases
Maintainer
Works with
Installation
NPM
npx -y @felores/airtable-mcp-serverManual Installation
npx -y @felores/airtable-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Airtable
The Airtable MCP Server connects AI assistants to Airtable databases, letting them list bases, inspect table schemas, manage fields, and perform full CRUD operations on records entirely through natural language. It uses the official Airtable REST API with a personal access token, making it straightforward to set up without OAuth flows. Developers and data teams use it to let Claude or other assistants read, create, update, and search Airtable records without leaving the chat interface.
Prerequisites
- Node.js 18 or later installed (required to run the npx command)
- An Airtable account with at least one Base
- An Airtable personal access token from Airtable Builder Hub with scopes: data.records:read, data.records:write, schema.bases:read, schema.bases:write
- An MCP client such as Claude Desktop or Cursor
Generate an Airtable personal access token
Go to https://airtable.com/create/tokens and create a new token. Grant it the scopes data.records:read, data.records:write, schema.bases:read, and schema.bases:write so the server can list, read, and modify your data.
Add the server to your MCP client config
Open your Claude Desktop configuration file (claude_desktop_config.json) and add the Airtable server entry, substituting your actual personal access token.
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "@felores/airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "your_personal_access_token_here"
}
}
}
}Restart your MCP client
Quit and reopen Claude Desktop (or your chosen MCP client) so it picks up the new server configuration and starts the Airtable MCP process.
Verify the connection by listing bases
In the chat, ask the assistant to list all accessible Airtable bases. A successful response confirms the token is valid and the server is running.
Explore table schemas
Once connected, ask the assistant to describe the fields and structure of any table in your bases to understand what data is available before querying records.
Airtable Examples
Client configuration
Add @felores/airtable-mcp-server to Claude Desktop config with your Airtable personal access token.
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "@felores/airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "patXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
}
}
}
}Prompts to try
Example natural language prompts to explore and manipulate Airtable data through the MCP server.
- "List all my Airtable bases"
- "Show me the schema for the 'Contacts' table in my CRM base"
- "Create a new record in the Tasks table with name 'Write blog post' and status 'In Progress'"
- "Search the Contacts table for records where Email contains '@example.com'"
- "Update record recXXXXXX in the Projects table, set Status to 'Completed'"
- "Add a new select field called 'Priority' with options Low, Medium, and High to the Tasks table"Troubleshooting Airtable
Authentication error: 401 Unauthorized
Verify your AIRTABLE_API_KEY value is a valid personal access token (starts with 'pat'), not an older API key. Generate a new one at https://airtable.com/create/tokens and ensure the required scopes are granted.
Cannot see certain bases or tables
Personal access tokens are scoped to specific bases. Edit your token at https://airtable.com/create/tokens and add the missing bases under 'Access' before retrying.
npx command not found when starting the server
Install Node.js 18 or later from https://nodejs.org. After installation, verify with `node --version` and `npx --version` in your terminal.
Frequently Asked Questions about Airtable
What is Airtable?
Airtable is a Model Context Protocol (MCP) server that enables ai assistants to interact with airtable databases by listing accessible bases and retrieving detailed schema information. supports secure authentication and provides tools for exploring airtable base structures through natural language. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Airtable?
Install via npm with the command: npx -y @felores/airtable-mcp-server. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
Which AI clients work with Airtable?
Airtable works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Airtable free to use?
Yes, Airtable is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Airtable Alternatives — Similar Databases Servers
Looking for alternatives to Airtable? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Airtable in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Airtable?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.