# How to connect Airtable to Hermes Agent

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

- Page: https://www.agent200.com/tools/airtable/framework/hermes-agent/
- Connector: [Airtable](https://www.agent200.com/tools/airtable.md)
- Framework: Hermes Agent
- Updated: 2026-11-15

## Instructions for AI agents

Goal: connect Airtable to Hermes Agent with Agent200, through its MCP server.
Guide: https://www.agent200.com/tools/airtable/framework/hermes-agent/

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 Hermes Agent'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 Hermes Agent: 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 Hermes Agent'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, Hermes Agent 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.

## Overview

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

You add one MCP server to Hermes Agent 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](https://www.agent200.com/tools/airtable/)
- **Works with:** Hermes Agent · Agent app, through MCP
- **Authentication:** Managed OAuth, per end user
- **You need:** [An Agent200 API key](https://agent200.com/platform/apikeys/)
- **Tools:** [8 tools](https://www.agent200.com/tools/airtable/framework/hermes-agent/#tools)
- **MCP server:** `https://api.agent200.com/mcp/`

## Before you start

- **An Agent200 API key.** Create one on the [API keys page](https://agent200.com/platform/apikeys/) 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.
- **Hermes Agent, with custom MCP servers allowed.** Hermes Agent is open source and self-hosted: anyone running it can add MCP servers in its config file.

## Connect Airtable to Hermes Agent

### 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 Hermes Agent 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.

Create an API key: https://agent200.com/platform/apikeys/

### Step 2: Store your key in ~/.hermes/.env

Keep the key out of `config.yaml`: Hermes reads it from `~/.hermes/.env`.

File `~/.hermes/.env`:

```bash
AGENT200_API_KEY=your-agent200-api-key
```

### Step 3: Add the server to ~/.hermes/config.yaml

Add an entry under `mcp_servers` with the URL and the Authorization header. Do not set `transport: sse`: Agent200 serves streamable HTTP.

File `~/.hermes/config.yaml`:

```text
mcp_servers:
  agent200:
    url: "https://api.agent200.com/mcp/"
    headers:
      Authorization: "Bearer ${AGENT200_API_KEY}"
```

### Step 4: Reload and test

In a running session, run `/reload-mcp`, or restart Hermes. Then check what the server returned from a terminal.

File `Terminal`:

```bash
# In a running Hermes session: /reload-mcp
hermes mcp test agent200
hermes mcp list
```

### Step 5: Connect your Airtable account

The first time you ask Hermes Agent 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 Hermes Agent or Agent200.

## Test your connection

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, Hermes Agent calls an Agent200 tool for Airtable, such as `airtable_list_bases`.

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

## Airtable tools Hermes Agent can call

- **List bases** (`airtable_list_bases`, read): List the bases the user shared with the connection.
- **Get a base schema** (`airtable_get_schema`, read): Read a base's tables, fields and views.
- **List records** (`airtable_list_records`, read): List the records in a table, filtered by a formula or a view, and sorted.
- **Get a record** (`airtable_get_record`, read): Read one record and its field values.
- **Create records** (`airtable_create_records`, write): Add one or more records to a table.
- **Update records** (`airtable_update_records`, write): Change field values on one or more records.
- **Delete records** (`airtable_delete_records`, write): Delete one or more records from a table.
- **Create a table** (`airtable_create_table`, write): Add a table with its fields to a base.

## How it works

1. **You ask Hermes Agent.** In your own words, for something in Airtable.
2. **Hermes Agent picks a tool.** It sees the Airtable tools on the Agent200 MCP server and calls the one the request needs.
3. **Agent200 runs the call.** With your own Airtable connection, within the tools and scopes your project allows.
4. **Hermes Agent 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

### The connection fails and names a missing variable

Add `AGENT200_API_KEY` to `~/.hermes/.env` and run `/reload-mcp`.

### The server answers 401 or 403

Check the key in `~/.hermes/.env` and that the header reads exactly `Bearer ${AGENT200_API_KEY}`.

### The initialize request fails with 400 or 405

That points to an SSE setting. Remove any `transport: sse` line from the entry and check the URL is exactly the Agent200 MCP server address.

### The Airtable tools do not appear

Run `hermes mcp test agent200`, check the entry is not disabled and no tools filter hides them, then `/reload-mcp`. Hermes names them `mcp_agent200_...`.

### Hermes Agent 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 Hermes Agent 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](https://agent200.com/platform/apikeys/), replace it in Hermes Agent's MCP settings, and stop using the old one. Paste the key only into Hermes Agent's settings, never into a chat.

## Use Airtable with another framework

- [Airtable + Claude](https://www.agent200.com/tools/airtable/framework/claude.md)
- [Airtable + ChatGPT](https://www.agent200.com/tools/airtable/framework/chatgpt.md)
- [Airtable + Claude Code](https://www.agent200.com/tools/airtable/framework/claude-code.md)
- [Airtable + Muse](https://www.agent200.com/tools/airtable/framework/muse.md)
- [Airtable + Grok Bot](https://www.agent200.com/tools/airtable/framework/grok-bot.md)
- [Airtable + OpenAI Dots](https://www.agent200.com/tools/airtable/framework/openai-dots.md)
- [Airtable + Claude Duet](https://www.agent200.com/tools/airtable/framework/claude-duet.md)
- [Airtable + OpenClaw](https://www.agent200.com/tools/airtable/framework/openclaw.md)

---

Agent200: https://www.agent200.com/ · API keys: https://agent200.com/platform/apikeys/ · Docs: https://docs.igpt.ai/
