Connect your AI Agents to Airtable in minutes

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

Available tools

get_attachment_info

Get information about an attachment

list_bases

List all accessible Airtable bases

get_base_schema

Get base schema including all tables and their structure

get_base_tables

Get all tables in a base

get_table_schema

Get schema for a specific table

create_table

Create a new table in a base

update_table

Update an existing table

list_record_comments

List all comments on a record

create_record_comment

Create a new comment on a record

update_comment

Update an existing comment

delete_comment

Delete a comment from a record

list_table_fields

List all fields in a table

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
Copied!

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

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"

Explore other MCP servers built and managed by Merge

amazon_s3
Amazon S3
anaplan
Anaplan
apollo
Apollo
articulate
Articulate Reach 360
asana
Asana
bamboohr
BambooHR
basecamp
Basecamp
bitbucket
Bitbucket
box
Box
cms_coverage
CMS Coverage
calendly
Calendly
clickup
ClickUp
cloudflare
Cloudflare
confluence
Confluence
contentful
Contentful
databricks
Databricks
datadog
Datadog
docusign
DocuSign
dropbox
Dropbox
dynamics365
Dynamics 365 Sales
figma
Figma
firecrawl
Firecrawl
freshbooks
FreshBooks
freshdesk
Freshdesk
freshservice
Freshservice
front
Front
gamma
Gamma
github
GitHub
gitlab
GitLab
gmail
Gmail
gong
Gong
google_bigquery
Google BigQuery
google_calendar
Google Calendar
google_docs
Google Docs
google_drive
Google Drive
google_meet
Google Meet
google_sheets
Google Sheets
greenhouse
Greenhouse
hubspot
HubSpot
intercom
Intercom
jira
Jira
jira_service_management
Jira Service Management
linear
Linear
linkedin
LinkedIn
make
Make
microsoft_teams
Microsoft Teams
miro
Miro
monday
Monday.com
npi_registry
NPI Registry
notion
Notion
onedrive
OneDrive
onenote
OneNote
outlook
Outlook
pipedrive
Pipedrive
pubmed
PubMed
pylon
Pylon
quickbooks_online
QuickBooks Online
ramp
Ramp
sapsf
SAP SuccessFactors
salesforce
Salesforce
sendgrid
SendGrid
sentry
Sentry
servicenow
ServiceNow
sharepoint
SharePoint
shopify
Shopify
slack
Slack
snowflake
Snowflake
straker
Straker
stripe
Stripe
teamwork
Teamwork.com
trello
Trello
visualping
VisualPing
weather
Weather
wikipedia
Wikipedia
workday
Workday
x
X
zendesk
Zendesk
zendesk_sell
Zendesk Sell
zohocrm
Zoho CRM
zohodesk
Zoho Desk
zoom
Zoom
zoominfo
ZoomInfo

Ready to try it out?

Whether you're an engineer experimenting with agents or a product manager looking to add tools, you can get started for free now