MCP Airtable Server

MCP Airtable Server

An MCP (Model Context Protocol) server that provides tools for interacting with Airtable databases. This server allows AI assistants to perform CRUD operations on Airtable bases and tables.

Features

• List available Airtable bases
• List tables within a base
• Get records with filtering, sorting, and field selection
• Create new records
• Update existing records
• Delete records
• Get base schema information

Installation

1. Clone this repository
2. Install dependencies:
   npm install
3. Build the TypeScript code:
   npm run build

Configuration

1. Copy .env.example to .env:
   cp .env.example .env
2. Add your Airtable API key to .env:
   AIRTABLE_API_KEY=your_api_key_here
3. (Optional) Add a default base ID:
   AIRTABLE_BASE_ID=appXXXXXXXXXXXXXX

Getting your Airtable API Key

1. Go to Airtable account settings
2. Navigate to the "API" section
3. Generate a personal access token with the following scopes:
   • data.records:read
   • data.records:write
   • schema.bases:read

Usage

Running the Server

For development with hot reload:

For production:

Using with Claude Desktop

Option 1: Local Installation (Recommended)

Add the following to your Claude Desktop configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

Option 2: Remote Deployment (Zeabur)

1. Deploy to Zeabur:
   • Fork this repository
   • Connect your GitHub account to Zeabur
   • Create a new service and select this repository
   • Zeabur will automatically detect the Dockerfile
2. Configure Environment Variables in Zeabur:
   MCP_AUTH_TOKEN=your-secret-token AIRTABLE_API_KEY=your-airtable-api-key AIRTABLE_BASE_ID=your-default-base-id (optional) AWS_REGION=us-east-1 (optional) AWS_S3_BUCKET=your-bucket-name (optional) AWS_ACCESS_KEY_ID=your-key (optional) AWS_SECRET_ACCESS_KEY=your-secret (optional)
3. Configure Claude Desktop for Remote MCP:
   { "mcpServers": { "airtable-remote": { "transport": "sse", "url": "https://your-app.zeabur.app/mcp", "headers": { "Authorization": "Bearer your-secret-token" } } } }

Security Note: When using remote deployment, always:

• Set a strong MCP_AUTH_TOKEN
• Use HTTPS only
• Keep your API keys secure in Zeabur's environment variables
• Never commit secrets to your repository

Available Tools

list_bases

List all available Airtable bases.

list_tables

List all tables in a specific base.

Parameters:

• baseId (optional): The base ID. Uses default if not specified.

get_records

Retrieve records from a table with optional filtering and sorting.

Parameters:

• tableName (required): The name of the table
• baseId (optional): The base ID
• view (optional): View name or ID
• maxRecords (optional): Maximum number of records to return
• filterByFormula (optional): Airtable formula for filtering
• sort (optional): Array of sort configurations
• fields (optional): Array of field names to return

create_record

Create a new record in a table.

Parameters:

• tableName (required): The name of the table
• fields (required): Object containing field values
• baseId (optional): The base ID

update_record

Update an existing record.

Parameters:

• tableName (required): The name of the table
• recordId (required): The ID of the record to update
• fields (required): Object containing fields to update
• baseId (optional): The base ID

delete_record

Delete a record from a table.

Parameters:

• tableName (required): The name of the table
• recordId (required): The ID of the record to delete
• baseId (optional): The base ID

get_schema

Get the schema information for a base.

Parameters:

• baseId (optional): The base ID

upload_attachment

Upload a file to S3 and get a URL formatted for Airtable attachment fields. Requires AWS S3 configuration.

Parameters:

• filePath (optional): Local file path to upload
• base64Data (optional): Base64 encoded file data
• filename (required with base64Data): Filename for the attachment
• contentType (optional): MIME type of the file

Returns:

• url: Public URL of the uploaded file
• filename: Name of the file
• size: File size in bytes
• type: MIME type

Example usage with create_record:

Development

Running Tests

Type Checking

Linting

Examples

Getting Records with Filtering

Creating a Record

License

MIT