MCPG Config
TemplatesHow it works
All templates

Airtable Base

beta

Data

Set up this templateAirtable API docs

Makes one Airtable base queryable as MCP tools: list rows with a formula, read a record, add rows. The base is pinned in the config; only the table is a caller's choice.

What you get

  • airtable.records.list — rows from a table, with an optional formula filter and view.
  • airtable.record.get — one record by id.
  • airtable.record.create — add up to ten rows in a call.

What you need

  • Airtable personal access token — with data.records:read, plus data.records:write only if you want the create tool. Scope the token to this one base rather than to everything your account can see.
  • Base id — from the API docs page for your base. It is a config value, so a caller can name a table but never another base.
  • Records per page — optional; how many rows one list call returns.
  • JWKS endpoint — the host where your identity provider publishes its signing keys, without a scheme.
  • Token audience — the aud claim your callers' tokens carry.

How it works

The base id is interpolated from config into every URL and the table name comes from the caller. That split is the containment: a base is a dataset, a table is a page of it, and an agent that can pick the base can read anything the token touches.

filterByFormula is passed through verbatim, which is a deliberate trade. An Airtable formula can read any column in the table it runs against, but it cannot leave that table — so the blast radius is the table the caller already named. If that is too wide, drop the argument and fix a view instead: a view is a filter defined in Airtable, not in the request.

pageSize carries the ceiling you set as its default, so the common call is already bounded and a caller has to ask for more on purpose.

Notes

Airtable rate-limits at five requests per second per base and answers 429 when you exceed it. The gateway surfaces that as a tool error rather than retrying, which is the honest behaviour when the caller may be a model in a loop.

typecast: true lets Airtable coerce a string into a date or a number for you. Turn it off if you would rather a badly-typed write fail than be guessed at.

Airtable Base · MCPG Config