Airtable

by felores

69 stars

Not rated

GitHub

About

Airtable MCP server enables AI assistants to programmatically manage Airtable bases, tables, fields, and records through a simplified interface to the Airtable API.

Details

Author: felores
Repository: felores/airtable-mcp
GitHub stars: 69
License: Other
Categories: Database, Other, Productivity, Developer Tools, Design, Workplace, AI, API, Project Management, Frontend, Infrastructure

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name Airtable

Command (node, npx, python, etc.) npx
Arguments
- Argument 1 @felores/airtable-mcp-server
Environment
- AIRTABLE_API_KEY your_api_key_here
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

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

JSON

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

JSON

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

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

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

JSON

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

JSON

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

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

From the repository

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

`list_bases`

List all accessible Airtable bases.

`list_tables`

List all tables in a specified base.

`create_table`

Create a new table with specified fields.

`update_table`

Update a table's name or description.

`create_field`

Add a new field to a specified table.

`update_field`

Modify an existing field in a specified table.

`list_records`

Retrieve records from a specified table.

`create_record`

Add a new record to a specified table.

`update_record`

Modify an existing record in a specified table.

`delete_record`

Remove a specified record from a table.

`search_records`

Find records in a table that match given criteria.

`get_record`

Get a single record from a table by its ID.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

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

Linux

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

Macos

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

Windows

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

A Model Context Protocol server that provides tools for interacting with Airtable's API. This server enables programmatic management of Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.

This MCP server features a specialized implementation that allows it to build tables in stages, leveraging Claude's agentic capabilities and minimizing the failure rate typically seen in other MCP servers for Airtable when building complex tables. It also includessystem promptand project knowledgemarkdown files to provide additional guidance for the LLM when leveraging projects in Claude Desktop.
- Install Node.js (version 18 or higher) and npm from nodejs.org
- Verify installation:

node --version npm --version

⚠️Important: Before running, make sure to setup your Airtable API key
- Log in to your Airtable account at airtable.com
- Create a personal access token at Airtable's Builder Hub
- In the Personal access token section select these scopes:

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

Navigate to the Claude configuration directory:

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

You can also find these directories inside the Claude Desktop app: Claude Desktop > Settings > Developer > Edit Config

Create or editclaude_desktop_config.json:

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

Note: For Windows paths, use double backslashes (\) or forward slashes (/).

mcp-installer is a MCP server to install other MCP servers.
- Installmcp-installer
- 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'

Claude will install the server, modify the configuration file and set the environment variable AIRTABLE_API_KEY to your Airtable API key.

Method 3: Local Development Installation

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

# Clone the repository git clone https://github.com/felores/airtable-mcp.git cd airtable-mcp # Install dependencies npm install # Build the server npm run build # 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" } } } }

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

- 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

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

- 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

- 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

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

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

- Visithttps://github.com/felores/airtable-mcp
- Click the "Fork" button in the top right
- Clone your fork locally:

git clone https://github.com/your-username/airtable-mcp.git

git checkout -b feature/your-feature-name

- Follow the existing code style
- Add tests if applicable
- Update documentation as needed

git add . git commit -m "feat: add your feature description"

git push origin feature/your-feature-name

- Go to your fork on GitHub
- Click "New Pull Request"
- Select your feature branch
- Describe your changes in detail

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

- 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. Whether it's:

- Adding new features
- Fixing bugs
- Improving documentation
- Suggesting enhancements

We appreciate your help in making the Airtable MCP server more powerful and user-friendly!

Made with ❤️ by the Airtable MCP community

Access and manage Airtable bases, tables, and records using the Airtable Web API.

Official Airtable MCP server and skills for working with bases, records, workflows, and business operations from AI agents.

Apify-hosted MCP server for Airtable with 15 tools. Full CRUD for records, tables, fields, search, and schema inspection. No local setup needed.

A read-only MCP server for querying live SAP ByDesign data. Requires a separate CData JDBC Driver for SAP ByDesign.

A read-only MCP server for querying live SAP Hybris C4C data, powered by the CData JDBC Driver.

A read-only MCP server by CData for querying live Zoho Creator data using a JDBC driver.

A read-only MCP server by CData that enables LLMs to query live data from Epicor Kinetic.

A read-only MCP server by CData that enables LLMs to query live data from Exact Online.

Access comprehensive company data including financial records, ownership structures, and contact information. Search for businesses using domains, registration numbers, or LinkedIn profiles to streamline due diligence and lead generation. Retrieve historical financial performance and complex corporate group structures to support informed business analysis.

An MCP server for accessing and managing data on the kintone low-code platform.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

Requirements Node Js

list_bases

list_tables

create_table

update_table

create_field

update_field

list_records

create_record

update_record

delete_record

search_records

get_record

Claude Desktop / Cursor

Linux

Macos

Windows

Method 3: Local Development Installation

Install

More like this

Sequential Thinking

Redis

Time

Filesystem

EverArt

Google Drive

`list_bases`

`list_tables`

`create_table`

`update_table`

`create_field`

`update_field`

`list_records`

`create_record`

`update_record`

`delete_record`

`search_records`

`get_record`