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

Clone this repository
Install dependencies:
npm install
Build the TypeScript code:
npm run build

Configuration

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

Getting your Airtable API Key

Go to Airtable account settings
Navigate to the "API" section
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:

npm run dev

For production:

npm start

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

{
  "mcpServers": {
    "airtable": {
      "command": "node",
      "args": ["/path/to/mcp-airtable/dist/index.js"],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here",
        "AIRTABLE_BASE_ID": "optional_default_base_id",
        "AWS_REGION": "us-east-1",
        "AWS_S3_BUCKET": "your-bucket-name",
        "AWS_ACCESS_KEY_ID": "your-access-key",
        "AWS_SECRET_ACCESS_KEY": "your-secret-key"
      }
    }
  }
}

Option 2: Remote Deployment (Zeabur)

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
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)
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:

// First upload the file
const attachment = await upload_attachment({ filePath: '/path/to/image.jpg' });

// Then create/update record with attachment field
await create_record({
  tableName: 'Products',
  fields: {
    'Name': 'Product Name',
    'Images': [{ url: attachment.url, filename: attachment.filename }]
  }
});

Development

Running Tests

npm test

Type Checking

npm run type-check

Linting

npm run lint

Examples

Getting Records with Filtering

{
  "tool": "get_records",
  "arguments": {
    "tableName": "Contacts",
    "filterByFormula": "AND({Status} = 'Active', {Age} > 25)",
    "sort": [{ "field": "Name", "direction": "asc" }],
    "maxRecords": 50
  }
}

Creating a Record

{
  "tool": "create_record",
  "arguments": {
    "tableName": "Contacts",
    "fields": {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Status": "Active"
    }
  }
}

License

MIT

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Provides tools for AI assistants to interact with Airtable databases, enabling CRUD operations on Airtable bases and tables.

Related MCP Servers

MySQL MCP Server
designcomputer
A
security
A
license
A
quality
Allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
Last updated -
1
732
Python
MIT License
Metabase MCP Server
imlewc
-
security
F
license
-
quality
Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.
Last updated -
51
JavaScript
Metabase Server MCP
berry-street
-
security
F
license
-
quality
Enables AI assistants to interact with Metabase, providing access to dashboards, questions, databases, and tools for executing queries and viewing data through natural language.
Last updated -
JavaScript
Airtable MCP
mufonix
-
security
A
license
-
quality
Enables AI-powered applications to access and manipulate Airtable data directly from your IDE, supporting operations like querying, creating, updating, and deleting records through natural language commands.
Last updated -
MIT License

View all related MCP servers

MCP Airtable Server