Merge Unified's Airtable integration Merge Agent Handler's Airtable MCP server

Connect your AI Agents to Airtable in minutes

Merge lets you securely connect your agents to Airtable and thousands of tools instantly

Start building for free

Read docs

Airtable

Learn more about Merge Agent Handler

Available tools

get_attachment_info

Get one attachment's metadata (filename, size, type, dimensions, thumbnails) and its download URL. The record holding the attachment is required. Use list_records to find record and attachment IDs. The URL is time-limited (valid at least 2 hours from this call) — call this tool again to get a fresh URL.

upload_attachment

Attach a file to a record's attachment field. Provide the file's bytes as a base64 string in content (with filename and contenttype), or a filereference from the file upload API (POST /api/v1/files/), which keeps the bytes out of the model's context. Airtable cannot fetch a URL. Max 5MB. Use gettableschema to find multipleAttachments fields.

list_bases

List every base this credential can access, with its ID and permission level. Start here: base IDs from this tool feed every other Airtable tool. A base missing from this list is not on the token's access list.

get_current_user

Get the Airtable user this credential authenticates as: their user ID, and their email and granted scopes when the credential exposes them. Use it to answer who am I connected as, or to confirm which scopes a credential actually has before attempting a write.

get_base_schema

Get a base's full schema: every table with all of its field definitions (including single-select option values) and views. Large on big bases -- use getbasetables when you only need to find a table ID or name, and gettableschema for one table's fields. Use list_bases to find base IDs.

get_base_tables

List a base's tables with their IDs, names and descriptions only -- no field or view definitions. Use this to find a table ID. For one table's fields use gettableschema; for the whole base's fields use getbaseschema. Use list_bases to find base IDs.

get_table_schema

Get one table's full schema: its fields, their types, and single-select option values. Call this before writing records so field names and option values match exactly. Use getbasetables to find table IDs.

create_table

Create a table in a base. Each field needs a name and a type; option shapes vary per type (e.g. singleSelect takes {'choices': [...]}). Use getbaseschema on an existing table to see valid field definitions. Use list_bases for base IDs. Airtable has no delete-table endpoint.

update_table

Rename a table or change its description. Only the fields you pass are changed. Use getbasetables to find table IDs.

list_record_comments

List the comments on a record, newest first, with pagination. Use list_records to find record IDs.

create_record_comment

Add a comment to a record. Returns the new comment's ID. Use list_records to find record IDs.

update_comment

Replace a comment's text. Only the comment's own author can edit it. Use listrecordcomments to find comment IDs.

delete_comment

Permanently delete a comment from a record. Use listrecordcomments to find comment IDs.

list_table_fields

List one table's fields with their types and option values. Same data as gettableschema without the table's views. Use getbasetables to find table IDs.

create_field

Add a field to a table. Requires a name and a type; the options shape varies per type (e.g. singleSelect takes {'choices': [...]}). Use listtablefields to see existing fields and their option shapes. Airtable has no delete-field endpoint, so a field added here cannot be removed via the API.

update_field

Rename a field or change its description. Cannot change a field's type or its select options. Use listtablefields to find field IDs.

get_field_details

Get one field's type, description and options. Use listtablefields to find field IDs. Reads the whole base schema under the hood, so prefer listtablefields when you want several fields.

list_records

List records in a table, with optional server-side filtering, sorting and pagination. Field names in fields, filterbyformula and sort must match the table exactly -- call gettableschema first to read them. cellformat='string' also requires timezone and userlocale. pagesize max 100.

create_records

Create up to 10 records in one call. Field names and single-select option values must match the table exactly -- call gettableschema first to read them, or set typecast=true to let Airtable coerce values. Returns each new record's ID. Use getbasetables for table IDs.

get_record

Get one record by ID, with all of its field values. Use listrecords to find record IDs, and getrecord only when you already have one.

update_record

Update named fields on one record, leaving every other field untouched. Field names must match the table -- call gettableschema first. To clear all unnamed fields instead, use replacerecord. Use listrecords to find record IDs.

update_multiple_records

Update up to 10 records in one call, each by ID, leaving unnamed fields untouched. Field names must match the table -- call gettableschema first. Use list_records to find record IDs.

replace_record

Replace one record completely: any field not named is CLEARED. To change some fields and keep the rest, use updaterecord instead. Use listrecords to find record IDs and gettableschema for field names.

delete_record

Permanently delete one record. Use listrecords to find record IDs. To delete several at once use deletemultiple_records.

delete_multiple_records

Permanently delete up to 10 records in one call. Use list_records to find record IDs.

validate_credential

Check whether the stored Airtable credential works, by listing accessible bases. Returns {success, message}.

View all tools by creating a free account See more tools

How to set up Merge Agent Handler

In an mcp.json file, add the configuration below, and restart Cursor.

Learn more in the official documentation ↗

1{
2  "mcpServers": {
3    "agent-handler": {
4      "url": "https://ah-api-develop.merge.dev/api/v1/tool-packs/{TOOL_PACK_ID}/registered-users/{REGISTERED_USER_ID}/mcp",
5      "headers": {
6        "Authorization": "Bearer yMt*****"
7      }
8    }
9  }
10}
11

Copy Code

Open your Claude Desktop configuration file and add the server configuration below. You'll also need to restart the application for the changes to take effect.

Make sure Claude is using the Node v20+.

Learn more in the official documentation ↗

1{
2  "mcpServers": {
3    "agent-handler": {
4      "command": "npx",
5      "args": [
6        "-y",
7        "mcp-remote@latest",
8        "https://ah-api-develop.merge.dev/api/v1/tool-packs/{TOOL_PACK_ID}/registered-users/{REGISTERED_USER_ID}/mcp",
9        "--header",
10        "Authorization: Bearer ${AUTH_TOKEN}"
11      ],
12      "env": {
13        "AUTH_TOKEN": "yMt*****"
14      }
15    }
16  }
17}

Copy Code

Open your Windsurf MCP configuration file and add the server configuration below.
Click on the refresh button in the top right of the Manage MCP server page or in the top right of the chat box in the box icon.

Learn more in the official documentation ↗

1{
2    "mcpServers": {
3      "agent-handler": {
4        "command": "npx",
5        "args": [
6          "-y",
7          "mcp-remote@latest",
8          "https://ah-api.merge.dev/api/v1/tool-packs/<tool-pack-id>/registered-users/<registered-user-id>/mcp",
9          "--header",
10          "Authorization: Bearer ${AUTH_TOKEN}"
11        ],
12        "env": {
13          "AUTH_TOKEN": "<ah-production-access-key>"
14        }
15      }
16    }
17  }

Copy Code

In Command Palette (Cmd+Shift+P on macOS, Ctrl+Shift+P on Windows), run "MCP: Open User Configuration".

You can then add the configuration below and press "start" right under servers. Enter the auth token when prompted.

Learn more in the official documentation ↗

1{
2  "inputs": [
3    {
4      "type": "promptString",
5      "id": "agent-handler-auth",
6      "description": "Agent Handler AUTH_TOKEN", // "yMt*****" when prompt
7      "password": true
8    }
9  ],
10  "servers": {
11    "agent-handler": {
12      "type": "stdio",
13      "command": "npx",
14      "args": [
15        "-y",
16        "mcp-remote@latest",
17        "https://ah-api-develop.merge.dev/api/v1/tool-packs/{TOOL_PACK_ID}/registered-users/{REGISTERED_USER_ID}/mcp",
18        "--header",
19        "Authorization: Bearer ${input:agent-handler-auth}"
20      ]
21    }
22  }
23}

Copy Code

FAQs on using Merge's Airtable MCP server

What is an Airtable MCP server?

It’s an MCP server that exposes tools from Airtable. These tools let your AI agents perform a host of “on-the-fly” actions with Airtable, from creating tables to updating comments to fetching records.

How can I use the Airtable MCP server?

Here are just a few use cases (these use cases can also apply to other project management MCP servers):

Project tracking automation: Your agent can monitor project statuses across your Airtable bases and automatically update records based on triggers from other tools. For example, when a GitHub pull request is merged, your agent can update the corresponding feature's status in your product roadmap base
Data enrichment and research: Your agent can automatically populate Airtable records with relevant information from multiple sources. For instance, when a new lead is added to your CRM base, your agent can research the company, pull in firmographic data, and auto-fill fields like industry, employee count, and recent news
Content calendar management: Your agent can analyze your Airtable content calendar, identify gaps or conflicts in your publishing schedule, and propose new content ideas based on performance metrics from past posts. It can then create draft records with suggested topics, target dates, and assigned writers
Cross-platform workflow orchestration: Your agent can detect changes in Airtable and trigger coordinated actions across your integrated tools. For example, when a deal moves to "Closed Won" in your sales base, your agent can create onboarding tasks in your project management tool, add the customer to your support base, and schedule a kickoff meeting

What are popular tools for Airtable’s MCP server?

Here are some popular tools across data types:

Records

<code class="blog_inline-code">get_record</code>
<code class="blog_inline-code">list_records</code>
<code class="blog_inline-code">update_record</code>
<code class="blog_inline-code">replace_record</code>

Bases

<code class="blog_inline-code">get_base_schema</code>
<code class="blog_inline-code">create_table</code>
<code class="blog_inline-code">update_table</code>

Tables

<code class="blog_inline-code">get_table_schema</code>
<code class="blog_inline-code">create_ table</code>
<code class="blog_inline-code">Update_table</code>
<code class="blog_inline-code">get_base_tables</code>

What makes Merge Agent Handler’s Airtable MCP server better than alternative Airtable MCP servers?

Here are a few reasons:

Built-in authentication and credential management: The platform securely manages credentials and supports both individual and shared authentication flows through a guided Link UI, reducing security and implementation complexity

Centralized security gateway with Data Loss Protection (DLP): All tool inputs and outputs pass through a security gateway that can block, redact, or mask sensitive data using default or custom rules, providing protections not inherent to basic MCP servers

Comprehensive tool call logging and observability: Every tool call and underlying API request is logged, creating a complete audit trail for monitoring, debugging, and compliance

Pre-deployment validation via the Evaluation Suite: Airtable’s tool behavior can be tested and evaluated against expected outcomes before production deployment, helping teams catch errors and optimize tool performance early

Tool Pack–based access control: Airtable tools can be bundled with other connectors into Tool Packs, allowing fine-grained control over which tools an agent can access for a given use case

How can I start using Merge Agent Handler’s Airtable MCP server?

You can take the following steps:

1. Sign up for Agent Handler by registering for a free account.

2. Navigate to "Tool Packs" in the left sidebar and select "Create New Tool Pack." You can give it a relevant name (e.g., "Airtable Automation Tools").

3. Browse the available connectors and add Airtable to your Tool Pack.

4. Choose your authentication method by deciding whether to use individual authentication (each user connects their own Airtable account) or shared authentication (one set of organization-level credentials for all users).

5. Select specific Airtable tools you want to make available to your agent, or enable all tools by default.

6. Navigate to "Registered Users" in the sidebar and create a new registered user, which represents the identity that will perform actions through your agent.

7. Save your Tool Pack settings and finalize your configuration.

8. Copy the MCP entry URL from your Tool Pack settings and connect it to your agent so it can access the Airtable tools you've configured.

Can I set custom security rules for Airtable tool calls?

Yes, you can add any number of security rules in a matter of clicks in Merge Agent Handler.

For example, you can:

Block credit card numbers in Airtable record fields
Redact social security numbers from Airtable base content
Log when agents access records containing email addresses or phone numbers
Block your agents from creating or updating Airtable records that contain specific terms, like "confidential" or "internal only"