Airtable + Claude

How to connect Airtable to Claude

Connect Airtable to Claude through Agent200's MCP server: managed OAuth, ready-made tools and one API key.

On this page
  1. Overview
  2. Before you start
  3. Setup steps
  4. Test your connection
  5. Instructions for AI agents
  6. Airtable tools
  7. How it works
  8. Troubleshooting

Overview

This guide connects Airtable to Claude through Agent200's MCP server. When you finish, Claude can search, read and act in Airtable with the tools Agent200 provides, whenever a request needs them.

You add one MCP server to Claude with your Agent200 API key. Your Airtable account is connected through managed OAuth: you approve access once on Airtable's own page, and Agent200 keeps the connection working.

Connector
Airtable
Works with
Claude ยท Agent app, through MCP
Authentication
Managed OAuth, per end user
Tools
8 tools
MCP server
https://api.agent200.com/mcp/

Before you start

  • An Agent200 API key. Create one on the API keys page of the dashboard.
  • Airtable enabled for your project. In the dashboard's Connectors settings, with the endpoints and scopes your agent needs.
  • An end user with a Airtable account. They approve access once, on Airtable's own page.
  • Claude, with custom MCP servers allowed. Custom connectors are on every Claude plan (Free: one). Sending an API key uses the Request headers option, a beta that only some accounts have; on Team and Enterprise an Owner adds the connector for everyone.

Connect Airtable to Claude

  1. 1

    Step 1: Create your Agent200 API key

    Open the API keys page in the Agent200 dashboard and choose Create an API key. You add it to Claude in the next step, as "Authorization: Bearer <your key>". One key covers Airtable and every other connector enabled for your project. Keep it out of chats and source control.

  2. 2

    Step 2: Open Connectors in Claude

    On a Free, Pro, Max or Ultra plan, go to Customize > Connectors. On Team or Enterprise, an Owner goes to Organization settings > Connectors; members then find the connector under Customize > Connectors.

  3. 3

    Step 3: Add a custom connector

    Select Add, then Add custom connector. Enter a name, Agent200, and the remote MCP server URL, then choose Continue.

  4. 4

    Step 4: Send your key as a request header

    Under Authentication choose No sign-in. Open Request headers, pick authorization, enter Bearer followed by a space and your key, mark it Required and choose Add. Claude sends the value exactly as typed.

    Add custom connector
    MCP: Claude custom connector (URL and request header)
    Remote MCP server URL:  https://api.agent200.com/mcp/
    Authentication:         No sign-in
    Request header name:    authorization
    Value:                  Bearer YOUR_AGENT200_API_KEY
  5. 5

    Step 5: Turn it on in a chat

    In a chat, select + > Connectors and turn Agent200 on. Ask Claude to list the Agent200 tools to check the connection; Claude asks before a tool runs the first time.

  6. 6

    Step 6: Connect your Airtable account

    The first time you ask Claude for something in Airtable, Agent200 returns an authorization link. Open it and approve access on Airtable's own page. Agent200 stores the connection and keeps it working; your password never reaches Claude or Agent200.

Test your connection

Run one request to check everything is wired up.

Ask

Add this lead to the Leads table with status New

What should come back

  • An answer built from your own Airtable data.
  • Behind the scenes, Claude calls an Agent200 tool for Airtable, such as airtable_list_bases.

If Claude shows an authorization link instead, you have not connected Airtable yet: open it, approve access, then ask again.

Get your API key

Create a key in the Agent200 dashboard. It reaches Airtable and every other connector enabled for your project.

Read the SDK docs

Instructions for AI agents

Using a coding agent? Paste this brief into it, or give it the address of this page. It lists what to do, in order, to connect Airtable to Claude.

Agent brief
Goal: connect Airtable to Claude with Agent200, through its MCP server.
Guide: https://www.agent200.com/tools/airtable/framework/claude/

1. The user needs an Agent200 API key. If they have none, send them to https://agent200.com/platform/apikeys/ to choose "Create an API key". They paste it into Claude's settings themselves: never ask for it in chat and never write it into files you share.
2. Make sure Airtable is enabled for their project in the Agent200 dashboard (Connectors), with the tools the task needs.
3. Add Agent200's MCP server to Claude: URL https://api.agent200.com/mcp/, transport streamable HTTP, header "Authorization: Bearer <the user's Agent200 API key>". Follow the setup steps on the guide page for Claude's exact menus or commands.
4. The first Airtable request returns an authorization link if the user has not connected Airtable yet: show it to them and continue once they have approved access on Airtable's own page.
5. Check it works with this request: "Add this lead to the Leads table with status New"
   What should come back:
   - An answer built from your own Airtable data.
   - Behind the scenes, Claude calls an Agent200 tool for Airtable, such as `airtable_list_bases`.
6. If a tool is missing or a call is refused, check the project's Connectors settings in the dashboard and the access the user granted in Airtable, then retry.

The whole guide is also available as Markdown, for agents and LLMs: /tools/airtable/framework/claude.md

Airtable tools Claude can call

  • List bases

    Read
    airtable_list_bases

    List the bases the user shared with the connection.

  • Get a base schema

    Read
    airtable_get_schema

    Read a base's tables, fields and views.

  • List records

    Read
    airtable_list_records

    List the records in a table, filtered by a formula or a view, and sorted.

  • Get a record

    Read
    airtable_get_record

    Read one record and its field values.

  • Create records

    Write
    airtable_create_records

    Add one or more records to a table.

  • Update records

    Write
    airtable_update_records

    Change field values on one or more records.

  • Delete records

    Write
    airtable_delete_records

    Delete one or more records from a table.

  • Create a table

    Write
    airtable_create_table

    Add a table with its fields to a base.

How it works

  1. 01

    You ask Claude

    In your own words, for something in Airtable.

  2. 02

    Claude picks a tool

    It sees the Airtable tools on the Agent200 MCP server and calls the one the request needs.

  3. 03

    Agent200 runs the call

    With your own Airtable connection, within the tools and scopes your project allows.

  4. 04

    Claude answers

    It gets the result back from the MCP server and uses it in its reply or its next step.

Each user's own connection. Connections belong to individual end users. A request for one user never reaches another user's Airtable account.

Permissions at every level. Your project settings decide what the agent may request, the end user decides what they authorize, and Airtable enforces what its API grants.

Troubleshooting

There is no Request headers section

Request headers are a Claude beta that only some accounts have. Without it, Claude cannot send an API key to a custom connector: use Claude Code, or the Agent200 SDK in your own agent.

Claude cannot reach the server

Check the header value is Bearer, a space, then your key, and that the URL is exactly the Agent200 MCP server address.

A Team or Enterprise member cannot add the connector

Only an Owner adds custom connectors, in Organization settings > Connectors. Members then connect it under Customize > Connectors.

You created a new API key

Claude does not let you edit a connector’s authentication. Remove the Agent200 connector and add it again with the new key.

Claude does not use the Airtable tools

Open + > Connectors in that chat and check Agent200 is on, and that no tool is set to Blocked under Customize > Connectors. Naming Airtable in the request also helps.

Claude shows a Airtable authorization link

You have not connected Airtable yet, or the connection needs to be approved again. Open the link, approve access on Airtable's own page, then ask Claude again.

A tool call is refused or returns less than expected

Agent200 runs only what your project allows. Check that Airtable and the tools you need are enabled in the dashboard's Connectors settings, and that you granted Airtable the access the task needs.

The API key was pasted into a chat or committed

Create a new key on the API keys page, replace it in Claude's MCP settings, and stop using the old one. Paste the key only into Claude's settings, never into a chat.

Use Airtable with another framework

200 OK

Airtable, connected to Claude.
One SDK. One API key.

Agent200 handles the OAuth, the tokens and every tool call. You keep your agent, your model and your code.

Book a demo.
See it in action.

Tell us who you are, then pick a time for a 1:1 session with an expert from our team.

We use your details only to email you about Agent200. See the Privacy Policy.

Pick a time. We'll take it from there.

A 1:1 session with an expert from our team, about what you are building.

Open in Calendly (opens in a new tab)