Airtable Connector
Connector implementation
Build the Airtable integration
Spreadsheet-database hybrid for organizing data with flexible views and automations
Implementation Overview
Implement an Airtable connector that authenticates to the vendor surface, normalizes source records in Tajo, and activates eligible data in Brevo.
Treat this as an implementation guide. Build and validate the auth, mapping, sync, and operations paths before production use.
mcp.airtable.com/mcp
| Property | Value |
|---|---|
| Integration surface | MCP |
| Implementation status | Implementation required |
| Category | Productivity |
| Setup complexity | medium |
| Vendor documentation | support.airtable.com/docs/using-the-airtable-mcp-server |
| Allowed host | Not recorded |
| Base URL | Not recorded |
| OpenAPI schema | Not recorded |
| MCP server | mcp.airtable.com/mcp |
| Last researched | 2026-08-07 |
Official Airtable MCP server live 2026; no official OpenAPI spec. Verified by handshake on 2026-08-07: 401 with RFC 9728 metadata naming https://airtable.com/oauth2/v1 as the authorization server. No runtime mcp block yet — that server publishes neither oauth-authorization-server nor openid-configuration metadata, so its authorize and token URLs would have to be guessed from the issuer, and a guessed OAuth endpoint is worse than none.
Authentication
-
Validate the MCP server endpoint at mcp.airtable.com/mcp and document required headers, auth grants, and tool availability.
-
Keep support.airtable.com/docs/using-the-airtable-mcp-server linked from the connector runbook so operators can confirm vendor behavior during incidents.
-
Store credentials per Tajo workspace and keep tenant-specific secrets out of connector configuration files.
-
Add a credential smoke test that verifies read access to a harmless resource before running backfills or enabling webhooks.
Data To Sync
Start with these inferred data domains, then confirm exact vendor resources and permissions from the source documentation:
- Commerce, payment, or subscription objects
- Campaign, messaging, or audience state
- Custom objects and operational metadata
The connector should make source records idempotent by keeping a stable key such as a vendor object ID, email address, event ID, ticket ID, order ID, or campaign ID. If the vendor only exposes list APIs, Tajo should store the cursor strategy and replay policy explicitly.
Sync Shape
No typed contract exists for Airtable, so the direction of each resource and its conflict handling are not recorded. Direction is declared per resource on a connector contract; see the connector catalog for how contracts are promoted.
Mapping To Tajo/Brevo
No Brevo projection is recorded for Airtable. A projection is declared on a typed connector contract, and Airtable does not have one yet, so this page will not state a mapping it cannot source.
The conventions that apply to every connector — stable external IDs, normalization, backfill and sync strategy, error handling, and the builder checklist — are documented once under “Applies to every connector” on the connector catalog.