Skip to main content

Airtable

Connects Airtable to FlyMyAI agents via OAuth. Connect once and the agent can browse your bases, read their schema, and create/update/delete records - no token to paste.

What it can do​

  • Discover - list bases (airtable_list_bases), read a base's tables & fields (airtable_get_base_schema)
  • Records - list (with filterByFormula, view, sort, paging), get, create, update (merge or replace), delete - up to 10 per call
  • Any endpoint - airtable_request(method, path, query, body) reaches the full Airtable API

The agent acts within the scopes and bases granted at connect time. Call airtable_get_base_schema first to learn the exact base/table/field names.

How to get credentials​

Airtable uses OAuth - there's no token to copy.

  1. In FlyMyAI, open the Airtable MCP and start the setup flow.
  2. An Airtable authorization screen opens. Choose which bases to share and approve.
  3. You're redirected back to FlyMyAI; the tool flips to Configured.

To revoke access later, open the integration in your Airtable account settings and remove FlyMyAI.

Fields to fill in FlyMyAI​

No fields - the OAuth flow stores the access and refresh tokens automatically. Access tokens last ~1 hour and refresh on their own; to change which bases are shared, reconnect.

Troubleshooting​

  • Base not visible / NOT_FOUND - the base wasn't granted at connect time; reconnect and select it.
  • INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND - the token lacks the needed scope (e.g. write); reconnect with write access.
  • UNKNOWN_FIELD_NAME - field-name mismatch; call airtable_get_base_schema for exact names, or pass typecast: true.
  • 10 records per write - batch creates/updates/deletes in groups of 10.