Airtable

DataPublisher: Airtable

Route Airtable MCP traffic through Formal to control and log what AI agents do in Airtable:

Block risky tools, such as update_records_for_table.
Mask sensitive data in tool results, such as emails and phone numbers in list_records_for_table responses.
Keep credentials at the Connector, so users and agents never see Airtable tokens.
Log every tool call with the user, the MCP client and its parameters.

0. Prepare your Connector

The Connector needs an MCP listener and a hostname with wildcard DNS and TLS. Set them up once by following Deploy the Connector. Every MCP server reuses them.

1. Add Airtable MCP server to your Resources

UI
Terraform
Pulumi
API

Open the Admin Catalog and click Add MCP.
Select the Airtable template.
Enter a DNS-label Name, such as airtable.
Choose the Space containing your Connector, such as default.
Configure upstream authentication as described below, then save.

If no Connector is in the selected Space, the Configuration tab shows MCP clients can’t connect directly yet. The reason reads: No Connector is in this server's Space.

Set space_id to the ID of the Space containing your Connector.

resource "formal_resource" "airtable" {
  name                    = "airtable"
  technology              = "mcp"
  hostname                = "mcp.airtable.com"
  space_id                = "<SPACE_ID>"
  native_users_v3_enabled = true
  port                    = 443
  tags = {
    "mcp-endpoint" = "/mcp"
  }
}

resource "formal_resource_oauth_settings" "airtable" {
  resource_id = formal_resource.airtable.id
}

Set spaceId to the ID of the Space containing your Connector.

import * as formal from "@formalco/pulumi";

const resource = new formal.Resource("mcp", {
  name: "airtable",
  technology: "mcp",
  hostname: "mcp.airtable.com",
  port: 443,
  spaceId: "<SPACE_ID>",
  tags: { "mcp-endpoint": "/mcp" },
  nativeUsersV3Enabled: true,
});

new formal.ResourceOauthSettings("mcpOAuth", {
  resourceId: resource.id,
});

Create a Resource with the MCP endpoint and its Space ID.

export FORMAL_API_KEY="<YOUR_API_KEY>"
RESOURCE_RESPONSE=$(curl --fail --silent --show-error \
  --request POST \
  https://api.formal.ai/core.v1.ResourceService/CreateResource \
  --header "x-api-key: ${FORMAL_API_KEY}" \
  --header "Content-Type: application/json" \
  --data-binary @- <<JSON
  {
    "name": "airtable",
    "hostname": "mcp.airtable.com",
    "port": 443,
    "technology": "mcp",
    "spaceId": "<SPACE_ID>",
    "tags": [
      {
        "key": "mcp-endpoint",
        "value": "/mcp"
      }
    ]
  }
JSON
)
RESOURCE_ID=$(printf '%s' "${RESOURCE_RESPONSE}" | jq -r '.resource.id')
curl --fail --silent --show-error \
  --request POST \
  https://api.formal.ai/core.v1.ResourceService/CreateResourceOAuthSettings \
  --header "x-api-key: ${FORMAL_API_KEY}" \
  --header "Content-Type: application/json" \
  --data-binary @- <<JSON
  {
    "resourceId": "${RESOURCE_ID}"
  }
JSON

2. Setup Authentication

Linked Accounts (Recommended)
Shared Credentials
Pass Through

Each user links their own Airtable account once in the Employee Catalog, and the Connector sends that user’s token to Airtable.

Linked Accounts selected under How does Formal authenticate to this resource?

Under OAuth app, choose one of the two options.

1. Formal’s App (default)

Airtable supports Client ID Metadata Documents, so you register nothing. Users see Formal on Airtable’s consent screen.

2. Your OAuth App

Users see your app’s name on Airtable’s consent screen.

Set up your own Airtable OAuth app

Go to airtable.com/create/oauth and click Register new OAuth integration. Enter a name, such as Formal.

Add Formal's redirect URI

In the Admin Catalog, open the Airtable server and select Configuration. Under Authentication, choose Linked Accounts, then Your OAuth App. Copy the Redirect URI and paste it into the integration’s OAuth redirect URI.

Choose scopes

Add the scopes your agents need from the ones Airtable’s MCP server supports:

data.records:read
data.records:write
schema.bases:read
schema.bases:write
data.recordComments:read
data.recordComments:write
workspacesAndBases:read

Generate a client secret

Click Generate client secret and copy it. Airtable shows it only once. You can skip this step. Formal then authenticates with PKCE alone.

Enter the app in Formal

UI
Terraform
Pulumi
API

Back in the Admin Catalog, enter the Client ID and Client secret, then save. Users then link their accounts on the Airtable server’s page in the Employee Catalog.

Your OAuth App selected in the Admin Catalog, with the Redirect URI, Client ID and Client secret fields

Use these OAuth settings instead of the ones from step 1.

variable "airtable_oauth_client_secret" {
  type      = string
  sensitive = true
}

resource "formal_resource_oauth_settings" "airtable" {
  resource_id              = formal_resource.airtable.id
  upstream_oauth_mode      = "pre_registered"
  client_id                = "<YOUR_CLIENT_ID>"
  client_secret_wo         = var.airtable_oauth_client_secret
  client_secret_wo_version = 1
}

Use these OAuth settings instead of the ones from step 1. Store the secret with pulumi config set --secret airtableOauthClientSecret.

import * as pulumi from "@pulumi/pulumi";

const config = new pulumi.Config();

new formal.ResourceOauthSettings("mcpOAuth", {
  resourceId: resource.id,
  upstreamOauthMode: "pre_registered",
  clientId: "<YOUR_CLIENT_ID>",
  clientSecret: config.requireSecret("airtableOauthClientSecret"),
});

Use this call instead of the CreateResourceOAuthSettings call from step 1. The OAuth app is fixed at creation.

curl --fail --silent --show-error \
  --request POST \
  https://api.formal.ai/core.v1.ResourceService/CreateResourceOAuthSettings \
  --header "x-api-key: ${FORMAL_API_KEY}" \
  --header "Content-Type: application/json" \
  --data-binary @- <<JSON
  {
    "resourceId": "${RESOURCE_ID}",
    "upstreamOauthMode": "pre_registered",
    "clientId": "<YOUR_CLIENT_ID>",
    "clientSecret": "<YOUR_CLIENT_SECRET>"
  }
JSON

Switching between Formal’s App and your OAuth app unlinks every account. Users must link again.

An administrator stores one Airtable token in Formal, and the Connector sends it on every user’s requests without showing it to them.

Shared Credentials selected under How does Formal authenticate to this resource?

Airtable’s MCP endpoint accepts personal access tokens (PATs) as Bearer tokens. Create one at airtable.com/create/tokens. Grant only the scopes your agents need, such as data.records:read and schema.bases:read. The PAT can only reach the bases you add to it.

Open this server from the Admin Catalog.
Select Configuration, then Authentication.
Choose Shared Credentials, then select Add credential.
Enter the credential, make it the default, and select Save authentication.

See Native Users.For HTTP Bearer authentication, enter the raw token. The Connector adds the Bearer prefix.In the Terraform tab, set native_users_v3_enabled = true on the Resource and upstream_oauth_mode = "none" on its OAuth settings.

variable "mcp_shared_credential" {
  type      = string
  sensitive = true
}

resource "formal_native_user_v3" "mcp_shared_credential" {
  resource_id = formal_resource.airtable.id
  label       = "shared-credential"

  http_bearer {
    header = "Authorization"
    token {
      literal_wo         = var.mcp_shared_credential
      literal_wo_version = 1
    }
  }
}

resource "formal_resource_native_user_selection" "mcp_shared_credential" {
  resource_id = formal_resource.airtable.id
  cel         = "\"${formal_native_user_v3.mcp_shared_credential.id}\""
}

3. Route Endpoint traffic

Auth is managed at the Connector level when you use Linked Accounts or Shared Credentials, so the Endpoint needs to forward the MCP traffic to it. Laptops and VMs with the Formal Endpoint keep using https://mcp.airtable.com/mcp, and a network rule sends that traffic to the Connector.

UI
Terraform
Pulumi
API

Go to Network Rules and create a rule named airtable-mcp.
Paste this expression, set the rule to Active, then save:

{
  "condition": {
    "pre_tcp": process.is_agent,
    // Every MCP server added to Formal: process.is_agent && resource.technology == "mcp"
    "pre_tls": process.is_agent && hostname == "mcp.airtable.com",
    "post_tls": true
  },
  "outputs": {
    "forward_to_connector": true
  }
}

resource "formal_network_rule" "airtable_mcp" {
  name        = "airtable-mcp"
  description = "Forward Airtable MCP traffic from agents to the Connector"
  status      = "active"

  # Every MCP server added to Formal: set pre_tls to process.is_agent && resource.technology == "mcp"
  cel_expression = <<-EOT
    {
      "condition": {
        "pre_tcp": process.is_agent,
        "pre_tls": process.is_agent && hostname == "mcp.airtable.com",
        "post_tls": true
      },
      "outputs": {
        "forward_to_connector": true
      }
    }
  EOT
}

import * as formal from "@formalco/pulumi";

new formal.NetworkRule("airtableMcp", {
  name: "airtable-mcp",
  description: "Forward Airtable MCP traffic from agents to the Connector",
  status: "active",
  // Every MCP server added to Formal: set pre_tls to process.is_agent && resource.technology == "mcp"
  celExpression: `
    {
      "condition": {
        "pre_tcp": process.is_agent,
        "pre_tls": process.is_agent && hostname == "mcp.airtable.com",
        "post_tls": true
      },
      "outputs": {
        "forward_to_connector": true
      }
    }
  `,
});

export FORMAL_API_KEY="<YOUR_API_KEY>"
# Every MCP server added to Formal: set pre_tls to process.is_agent && resource.technology == "mcp"
CEL_EXPRESSION=$(cat <<'CEL'
{
  "condition": {
    "pre_tcp": process.is_agent,
    "pre_tls": process.is_agent && hostname == "mcp.airtable.com",
    "post_tls": true
  },
  "outputs": {
    "forward_to_connector": true
  }
}
CEL
)
jq -n --arg cel "${CEL_EXPRESSION}" '{
  name: "airtable-mcp",
  description: "Forward Airtable MCP traffic from agents to the Connector",
  status: "active",
  celExpression: $cel
}' | curl --fail --silent --show-error \
  --request POST \
  https://api.formal.ai/core.v1.DesktopService/CreateDesktopRoutingRule \
  --header "x-api-key: ${FORMAL_API_KEY}" \
  --header "Content-Type: application/json" \
  --data-binary @-

The rule matches known agents only. See Identity headers.Cloud agents such as Claude, ChatGPT and Cursor Cloud Agents don’t run the Endpoint. Point them at this server’s Connector address, https://airtable.<connector-hostname>/mcp. Find it in the Admin Catalog: open Airtable, then copy Connector address on the Configuration tab.

4. Create policies

Tools

The Admin Catalog lists these tools for Airtable:

Tool	Description
`list_bases`	List the bases you can access.
`search_bases`	Search bases by name.
`list_tables_for_base`	List a base’s tables.
`get_table_schema`	Get a table’s fields and views.
`list_records_for_table`	List a table’s records.
`search_records`	Search records in a table.
`create_records_for_table`	Create records in a table.
`update_records_for_table`	Update records in a table.
`create_table`	Create a table.
`create_field`	Add a field to a table.

Policies examples

Block a tool
Mask a tool's output

This policy blocks the tools that change data, so agents can only read Airtable.

package formal.v2

import future.keywords.if
import future.keywords.in

write_tools := {
  "create_records_for_table",
  "update_records_for_table",
  "create_table",
  "create_field",
}

request := {
  "action": "block",
  "type": "block_with_custom_message",
  "message": "Writing to Airtable is not allowed.",
} if {
  input.resource.name == "airtable"
  input.mcp.method == "tools/call"
  input.mcp.tool_name in write_tools
}

This policy replaces email addresses in records returned by list_records_for_table and search_records.

package formal.v2

import future.keywords.if
import future.keywords.in

email_pattern := `[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}`

response := {
  "action": "rewrite",
  "body": regex.replace(input.http.body, email_pattern, "[REDACTED-EMAIL]"),
  "reason": "Mask emails in Airtable records",
} if {
  input.resource.name == "airtable"
  input.mcp.tool_name in {"list_records_for_table", "search_records"}
  regex.match(email_pattern, input.http.body)
}

See MCP resources for the input.mcp fields and Rewrite Action for body rewrites.

5. Check the logs

Open Logs and search for resource.name:airtable. Each Airtable tool call is one request log with the user, the MCP client and the tool. Open a log to see its tool parameters and the policies it triggered. A blocked write shows the block policy and its message. A masked search shows the rewrite policy.See Logs for search syntax and filters.

Troubleshooting

The agent says Airtable rejected your credentials

The agent relays: airtable rejected your credentials. Link or re-link your airtable account in Formal…Cause: Airtable no longer accepts the linked token, for example after the user revoked access in Airtable.Fix: Link Airtable again from the Employee Catalog.With Shared Credentials, the message asks the user to contact an administrator. Replace the token in the server’s Shared Credentials.

Laptop traffic doesn't appear in Logs

Cause: The Endpoint isn’t running, or the network rule doesn’t match the client.Fix: Check the Endpoint is connected. The rule above only matches known agents. Other clients, such as a browser, reach Airtable directly unless the rule also matches them. See Network rules.

MCP clients can't connect directly yet

Cause: The Configuration tab lists the reason, most often No Connector is in this server's Space.Fix: Edit the server and choose the Space containing its Connector.

Getting Started

Example Use Cases

AI Governance

Configuring Formal

Integrations

Configuration

0. Prepare your Connector

1. Add Airtable MCP server to your Resources

2. Setup Authentication

1. Formal’s App (default)

2. Your OAuth App

3. Route Endpoint traffic

4. Create policies

Tools

Policies examples

5. Check the logs

Troubleshooting

Next Steps

MCP Gateway

All MCP servers

​0. Prepare your Connector

​1. Add Airtable MCP server to your Resources

​2. Setup Authentication

​1. Formal’s App (default)

​2. Your OAuth App

​3. Route Endpoint traffic

​4. Create policies

​Tools

​Policies examples

​5. Check the logs

​Troubleshooting

​Next Steps

MCP Gateway

All MCP servers

0. Prepare your Connector

1. Add Airtable MCP server to your Resources

2. Setup Authentication

1. Formal’s App (default)

2. Your OAuth App

3. Route Endpoint traffic

4. Create policies

Tools

Policies examples

5. Check the logs

Troubleshooting

Next Steps