Provides tools for interacting with Airtable bases and schemas, enabling listing of accessible bases and retrieval of detailed schema information including table structures and metadata.
Airtable MCP
An MCP (Model Context Protocol) server that provides tools for interacting with Airtable bases and schemas.
Overview
This project implements an xMCP application that allows AI assistants to interact with Airtable.
Related MCP server: Metabase MCP Server
Features
ποΈ List all accessible Airtable bases
π Retrieve detailed schema information for any base
π Secure authentication using Airtable API keys
π Built with TypeScript and xMCP framework
π§ HTTP server support for easy integration
Prerequisites
Node.js >= 20.0.0
Airtable API key
Access to Airtable bases
Installation
Clone the repository:
Install dependencies:
Set up environment variables: Create a
.envfile in the root directory with:
Getting Started
Run the development server:
Build for production:
Available Tools
listBases
Description: List all Airtable bases owned by the user
Parameters: None
Returns: JSON array of bases with their metadata
getBaseSchema
Description: Get the schema of a specific Airtable base
Parameters:
baseId(string): The ID of the Airtable base
Returns: JSON object containing the base's table schemas
Scripts
npm run dev- Start development server with hot reloadnpm run build- Build the project for productionnpm start- Start the production HTTP servernpm run lint- Run TypeScript type checking
Project Structure
This project uses the structured approach where tools are automatically discovered from the src/tools directory. Each tool is defined in its own file with the following structure:
Dependencies
airtable: Official Airtable JavaScript client
xmcp: xMCP framework for building MCP servers
zod: Runtime type validation