A 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. Step 1: Create an Airtable personal access token by clicking here. Details: - Name: Anything you want e.g. 'Airtable MCP Server Token'. - Scopes: schema.bases:read, data.records:read, and optionally schema.bases:write, data.re
Add this skill
npx mdskills install domdomegg/airtable-mcp-serverComprehensive Airtable integration with excellent tool coverage and detailed setup instructions
A 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.
https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944
Step 1: Create an Airtable personal access token by clicking here. Details:
schema.bases:read, data.records:read, and optionally schema.bases:write, data.records:write, data.recordComments:read, and data.recordComments:write.Keep the token handy, you'll need it in the next step. It should look something like pat123.abc123 (but longer).
Step 2: Follow the instructions below for your preferred client:
airtable-mcp-server-mcpb file.zip file to .mcpb.mcpb file to open with Claude Desktopclaude_desktop_config.json filepat123.abc123 with your API key:{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123",
}
}
}
}
mcp.json file to insert your API keyCreate either a global (~/.cursor/mcp.json) or project-specific (.cursor/mcp.json) configuration file, replacing pat123.abc123 with your API key:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}
pat123.abc123 with your API key:{
"mcpServers": {
"airtable": {
"type": "stdio",
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123"
}
}
}
}
list_records
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the table to querymaxRecords (number, optional): Maximum number of records to return. Defaults to 100.filterByFormula (string, optional): Airtable formula to filter recordssearch_records
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the table to querysearchTerm (string, required): Text to search for in recordsfieldIds (array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.maxRecords (number, optional): Maximum number of records to return. Defaults to 100.list_bases
list_tables
baseId (string, required): The ID of the Airtable basedetailLevel (string, optional): The amount of detail to get about the tables (tableIdentifiersOnly, identifiersOnly, or full)detailLevel)describe_table
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the table to describedetailLevel (string, optional): The amount of detail to get about the table (tableIdentifiersOnly, identifiersOnly, or full)get_record
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablerecordId (string, required): The ID of the record to retrievecreate_record
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablefields (object, required): The fields and values for the new recordupdate_records
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablerecords (array, required): Array of objects containing record ID and fields to updatedelete_records
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablerecordIds (array, required): Array of record IDs to deletecreate_table
baseId (string, required): The ID of the Airtable basename (string, required): Name of the new tabledescription (string, optional): Description of the tablefields (array, required): Array of field definitions (name, type, description, options)update_table
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablename (string, optional): New name for the tabledescription (string, optional): New description for the tablecreate_field
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablename (string, required): Name of the new fieldtype (string, required): Type of the fielddescription (string, optional): Description of the fieldoptions (object, optional): Field-specific optionsupdate_field
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablefieldId (string, required): The ID of the fieldname (string, optional): New name for the fielddescription (string, optional): New description for the fieldcreate_comment
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablerecordId (string, required): The ID of the recordtext (string, required): The comment textparentCommentId (string, optional): Parent comment ID for threaded replieslist_comments
baseId (string, required): The ID of the Airtable basetableId (string, required): The ID of the tablerecordId (string, required): The ID of the recordpageSize (number, optional): Number of comments to return (max 100, default 100)offset (string, optional): Pagination offset for retrieving additional commentsThe server can also run in HTTP mode for use with remote MCP clients:
MCP_TRANSPORT=http PORT=3000 npx airtable-mcp-server
This starts a stateless HTTP server at http://localhost:3000/mcp. Note: HTTP transport has no built-in authentication - only use behind a reverse proxy or in a secured environment.
Pull requests are welcomed on GitHub! To get started:
npm installnpm run test to run testsnpm run buildnpm run build:watch to automatically build after editing src/index.ts. This means you can hit save, reload Claude Desktop (with Ctrl/Cmd+R), and the changes apply.Versions follow the semantic versioning spec.
To release:
npm version to bump the versiongit push --follow-tags to push with tagsInstall via CLI
npx mdskills install domdomegg/airtable-mcp-serverAirtable MCP Server is a free, open-source AI agent skill. A 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. Step 1: Create an Airtable personal access token by clicking here. Details: - Name: Anything you want e.g. 'Airtable MCP Server Token'. - Scopes: schema.bases:read, data.records:read, and optionally schema.bases:write, data.re
Install Airtable MCP Server with a single command:
npx mdskills install domdomegg/airtable-mcp-serverThis downloads the skill files into your project and your AI agent picks them up automatically.
Airtable MCP Server works with Claude Code, Claude Desktop, Cursor, Vscode Copilot, Windsurf, Continue Dev, Gemini Cli, Amp, Roo Code, Goose. Skills use the open SKILL.md format which is compatible with any AI coding agent that reads markdown instructions.