Docs

Configure the Airtable MCP Server

Updated 2 min read

Overview

Airtable operates an official hosted MCP server at mcp.airtable.com, covering base and table discovery, records (read, create, update), and interface pages. Access is authorized through OAuth 2.0 via an OAuth integration you register yourself in Airtable.

1. Configure Airtable

  1. In the Airtable web app, click your account avatar in the top right and select Builder Hub.
  2. Go to Integrations → OAuth integrations and click + Register new OAuth integration.
  3. Give the integration a name, add your gateway’s OAuth redirect URI — found in the Configuration section for your gateway in the Dtwo UI — and click Register integration.
  4. Click + Generate client secret to create a client secret, and copy it immediately — Airtable shows it only once.
  5. Under scopes, check off the ones your agents need — for example schema.bases:read, data.records:read, and data.records:write — then save your changes.

2. Add the MCP server to your gateway config

In the mcp_servers section of your gateway configuration add the following entry:

  - name: airtable
    description: "Airtable's official hosted MCP server for bases, tables, and records."
    url: https://mcp.airtable.com/mcp
    transport_type: streamablehttp
    authentication:
      type: oauth
      grant_type: authorization_code
      scopes:
        - schema.bases:read
        - data.records:read
        - data.records:write
      client_id: "<CLIENT_ID>"
      client_secret: "<CLIENT_SECRET>"
      authorization_url: https://airtable.com/oauth2/v1/authorize
      token_url:  https://airtable.com/oauth2/v1/token
      redirect_uri: "<CALLBACK_URL>"
      pkce_enabled: true
      token_endpoint_auth_method: "client_secret_basic"

Replace the placeholder values:

  • <CLIENT_ID> and <CLIENT_SECRET> — come from the OAuth integration you registered in step 1.
  • <CALLBACK_URL> — the same redirect URI you set in step 1, found in the Configuration section for your gateway in the Dtwo UI.

The scopes you list here have to match the scopes you checked off in step 1.5 in Airtable exactly — if they don’t, the OAuth authorization will fail.

3. Deploy and verify

Save the configuration and deploy the gateway.

Then, in your AI client, ask it to authorize Airtable via the gateway. This opens the Airtable login screen — sign in, then choose which bases to share with the connection before approving. Only the bases you grant here will be reachable by the agent. Once authorized, confirm the server’s tools appear and run a quick call to make sure the connection works.

Having trouble? Email support@dtwo.ai.