Airtable MCP Server

Requirements:

Node.js

1. Install Node.js (version 18 or higher) and npm from nodejs.org
2. Verify installation:

node --version
npm --version

⚠️ Important: Before running, make sure to setup your Airtable API key

Obtaining an Airtable API Key

1. Log in to your Airtable account at airtable.com
2. Create a personal access token at Airtable's Builder Hub
3. In the Personal access token section select these scopes:

• data.records:read
• data.records:write
• schema.bases:read
• schema.bases:write

4. Select the workspace or bases you want to give access to the personal access token
5. Keep this key secure - you'll need it for configuration

Installation# Method 1: Using npx (Recommended)

1. Navigate to the Claude configuration directory:

• Windows: C:\Users\NAME\AppData\Roaming\Claude
• macOS: ~/Library/Application Support/Claude/

2. Create or edit claude_desktop_config.json:

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@felores/airtable-mcp-server"],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here"
      }
    }
  }
}

Method 2: Using mcp-installer:

mcp-installer is a MCP server to install other MCP servers.

1. Install mcp-installer
2. Install the Airtable MCP server by prompting Claude Desktop:

Install @felores/airtable-mcp-server
set the environment variable AIRTABLE_API_KEY to 'your_api_key'

Method 3: Local Development Installation

If you want to contribute or modify the code run this in your terminal:

git clone https://github.com/felores/airtable-mcp.git
cd airtable-mcp\n\n# Install dependencies
npm install\n\n# Build the server
npm run build\n\n# Run locally
node build/index.js

Then modify the Claude Desktop configuration file to use the local installation:

{
  "mcpServers": {
    "airtable": {
      "command": "node",
      "args": ["path/to/airtable-mcp/build/index.js"],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here"
      }
    }
  }
}

Verifying Installation

1. Start Claude Desktop
2. The Airtable MCP server should be listed in the "Connected MCP Servers" section
3. Test with a simple command:

List all bases

Features# Available Operations\n\n#### Base Management

• list_bases: List all accessible Airtable bases
• list_tables: List all tables in a base
• create_table: Create a new table with fields
• update_table: Update a table's name or description

Field Management

• create_field: Add a new field to a table
• update_field: Modify an existing field

Record Operations

• list_records: Retrieve records from a table
• create_record: Add a new record
• update_record: Modify an existing record
• delete_record: Remove a record
• search_records: Find records matching criteria
• get_record: Get a single record by its ID

Field Types

• singleLineText: Single line text field
• multilineText: Multi-line text area
• email: Email address field
• phoneNumber: Phone number field
• number: Numeric field with optional precision
• currency: Money field with currency symbol
• date: Date field with format options
• singleSelect: Single choice from options
• multiSelect: Multiple choices from options

Field Colors

Available colors for select fields:

• blueBright, redBright, greenBright
• yellowBright, purpleBright, pinkBright
• grayBright, cyanBright, orangeBright
• blueDark1, greenDark1

Contributing

We welcome contributions to improve the Airtable MCP server! Here's how you can contribute:

1. Fork the Repository - Visit https://github.com/felores/airtable-mcp
2. Create a Feature Branch
3. Make Your Changes
4. Commit Your Changes
5. Push to Your Fork
6. Create a Pull Request

Development Guidelines

• Use TypeScript for new code
• Follow semantic commit messages
• Update documentation for new features
• Add examples for new functionality
• Test your changes thoroughly

Getting Help

• Open an issue for bugs or feature requests
• Join discussions in existing issues
• Ask questions in pull requests

Your contributions help make this tool better for everyone.