Airtable

Airtable's MCP server lets your Dust assistants read and write records, explore base schemas, and interact with your Airtable data directly from conversations.

Two authentication methods are available: Personal Access Token (PAT) for a quick setup, and OAuth for a per-user authentication (recommended for teams).


Method 1 — Personal Access Token (PAT)

Simpler to set up, but all users in the workspace share the same token and the same Airtable permissions. If you need each user to authenticate with their own Airtable account, use the OAuth method below.

1. Create a Personal Access Token

Go to airtable.com/create/tokens and click "Create new token".

  • Name: Dust (or any name)
  • We recommend to add the following scopes:
    • data.records:read
    • data.records:write
    • data.recordComments:read
    • data.recordComments:write
    • schema.bases:read
    • schema.bases:write
    • user.email:read
  • Select the bases you want Dust to access
  • Click "Create token" and copy it immediately (it won't be shown again)

2. Connect in Dust

In Dust, go to Spaces → Tools → Add tools → Add MCP server.

  • Server URL: https://mcp.airtable.com/mcp
  • Authentication: Shared secret

Paste your Personal Access Token as the shared secret and save.


Method 2 — OAuth (Recommended)

With OAuth, each user authenticates with their own Airtable account. Airtable permissions are enforced per user.

📖

1. Create an OAuth integration in Airtable

Go to airtable.com/create/oauth and click "Register new OAuth integration".

Under "About your integration", fill in:

FieldValue
NameDust
Homepage URLhttps://dust.tt
LogoDownload from dust.tt/home/brand-resources (PNG, 200x200 to 1000x1000px)

2. Add redirect URIs

Under "OAuth redirect URLs", add these three URIs:

https://dust.tt/oauth/mcp_static/finalize
https://eu.dust.tt/oauth/mcp_static/finalize
https://app.dust.tt/oauth/mcp_static/finalize

3. Generate a client secret

On the same page, click "Generate client secret" and copy it immediately (it will not be shown again).

Note down your Client ID as well (visible on the page).

4. Add permission scopes

Under "Permission scopes", we recommend to add the following scopes:

ScopeDescription
data.records:readView record data
data.records:writeCreate, edit, and delete records
data.recordComments:readView record comments
data.recordComments:writeCreate, edit, and delete record comments
schema.bases:readView base structure (tables, fields)
schema.bases:writeEdit base structure
user.email:readView the authorizing user's email

5. Fill in support information

Airtable requires these fields before allowing OAuth authorization flows:

FieldValue
Support email[email protected]
Privacy policy URLhttps://dust-tt.notion.site/Terms-Conditions-2bdcf30156db4a40bcb20d27b0b1bd4e
Terms of service URLhttps://dust-tt.notion.site/Personal-Use-Terms-of-Service-06b764049abc4d4a9d3434245b56c765

Click "Save changes".

6. Connect in Dust

In Dust, go to Spaces → Tools → Add tools → Add MCP server → Static OAuth.

Server URL:

https://mcp.airtable.com/mcp

Authentication: OAuth, then fill in:

FieldValue
Client IDYour Client ID from step 3
Client SecretThe secret from step 3
Authorization URLhttps://airtable.com/oauth2/v1/authorize
Token URLhttps://airtable.com/oauth2/v1/token
Scopedata.records:read data.records:write data.recordComments:read data.recordComments:write schema.bases:read schema.bases:write user.email:read
Token endpoint auth methodBasic Auth

Save, authenticate with your Airtable account, and select the bases you want to grant access to.