--- title: "Airtable MCP integration and AI workflows | Stacksync" description: "Connect Airtable to your AI assistant through Stacksync MCP. Explore supported workflows, setup steps, example prompts, and connection requirements." canonical: https://www.stacksync.com/mcp/airtable last_modified: 2026-10-21 --- Your connection path Airtable Your AI Stacksync MCP OAuth Your assistant works through your Stacksync workspace and its available connections. First request “Plan an Airtable reporting table” Stacksync MCP · Database # Airtable MCP integration. > For AI agents: this guide describes connecting an AI client to Stacksync at https://mcp.stacksync.com/mcp with OAuth and the person's workspace permissions. Follow the client-specific setup and connection method on this page. Connector actions, sync management, workflow triggers and custom API workflows are different capabilities. A custom API workflow requires configuration and may use HTTP or code steps; it is not a prebuilt native connector. Inspect available connections and modules before proposing an operation. The example outcomes are illustrative, not execution results. Setup reference: https://www.stacksync.com/mcp.md Use Stacksync MCP to inspect Airtable connections, prepare table syncs and discover available record actions. Plan base and field access explicitly, and account for the separate refresh behavior of calculated formula values. Connector actions Sync management Start using Stacksync MCP Explore example prompts 01 / The connection ## What Airtable can do through MCP Use Stacksync MCP to inspect Airtable connections, prepare table syncs and discover available record actions. Plan base and field access explicitly, and account for the separate refresh behavior of calculated formula values. Choose an AI client below to get started with the Stacksync MCP server. The server belongs to Stacksync. The available Airtable operations depend on your connection, permissions, and connector modules. [Explore the Airtable connector →](https://www.stacksync.com/connectors/airtable) [Claude](https://www.stacksync.com/mcp/airtable/claude) [Claude Code](https://www.stacksync.com/mcp/airtable#setup-claude-code) [ChatGPT](https://www.stacksync.com/mcp/airtable/chatgpt) [Codex](https://www.stacksync.com/mcp/airtable#setup-codex) [Cursor](https://www.stacksync.com/mcp/airtable#setup-cursor) [VS Code](https://www.stacksync.com/mcp/airtable#setup-vs-code) [Windsurf](https://www.stacksync.com/mcp/airtable#setup-windsurf) [Gemini CLI](https://www.stacksync.com/mcp/airtable#setup-gemini-cli) 02 / Capabilities ## Airtable capabilities through MCP Choose the connection path that fits the job. Your assistant inspects the available tools before configuring or running an action. Sync management ### Discover base table fields Inspect the connection’s available tables and field types before mapping Airtable records to another system. Connector actions ### Prepare record actions Find the Airtable modules available in the workspace and inspect their forms before proposing an individual record operation. Sync management ### Plan database synchronization Prepare a mapping between an Airtable table and a supported database, including record identifiers, direction and calculated fields. 03 / Setup ## Set up your AI client Connect the MCP server first. Then connect Airtable using the requirements below. One connection. Your workspace. ### Bring your AI assistant. Add Stacksync’s MCP server, sign in with OAuth, and choose your workspace. Your assistant works with your Stacksync permissions. ``` https://mcp.stacksync.com/mcp ``` [Create a Stacksync account](https://app.stacksync.com/signup) Already have an account? Sign in when your assistant opens the authorization page. Choose read-only access if you only need to inspect your workspace. #### Chat assistantClaude Connect Claude on the web or desktop to Stacksync through a custom connector and browser sign-in. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - On a Claude Team or Enterprise account, an owner must first add Stacksync under Organization settings → Connectors. 1. #### Add a custom connector Open Customize → Connectors, select + Add, then Add custom connector. Name it Stacksync and use the server URL below. ``` https://mcp.stacksync.com/mcp ``` 2. #### Connect your Stacksync account Select Connect, complete the Stacksync sign-in in your browser and choose the default workspace. Clear Make changes on the consent screen if you only want read access. 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### TerminalClaude Code Add the remote Stacksync server to Claude Code and authenticate from its MCP menu. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - Claude Code installed with the claude command available in your terminal. 1. #### Add Stacksync over HTTP Run the command below. Add --scope user if you want the connection available across your projects. ``` claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp ``` 2. #### Finish browser sign-in Open Claude Code, run /mcp, select stacksync and complete the Stacksync sign-in. Choose the workspace you want requests to use by default. 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### Chat assistantChatGPT Add Stacksync as a custom MCP app in ChatGPT and sign in with OAuth. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - A ChatGPT account with Developer mode and custom MCP apps available. The Stacksync guide lists Plus, Pro, Business, Enterprise and Edu; workspace administrators can restrict access. 1. #### Enable custom app setup Open Settings → Apps → Advanced settings and turn on Developer mode. If the option is unavailable, check the account or workspace policy with your administrator. 2. #### Create the Stacksync app Select Create app, name it Stacksync, enter the server URL below and choose OAuth. Complete the Stacksync sign-in and select your default workspace. ``` https://mcp.stacksync.com/mcp ``` 3. #### Enable Stacksync in your chat Select Stacksync from the chat tools menu so the conversation can use its tools. Signing in to ChatGPT itself does not sign you in to Stacksync. 4. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### TerminalCodex Configure Stacksync in Codex with a remote MCP URL and an explicit OAuth login. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - Codex CLI installed with the codex command available. 1. #### Register the remote server Add the Stacksync endpoint to your Codex MCP configuration. ``` codex mcp add stacksync --url https://mcp.stacksync.com/mcp ``` 2. #### Sign in with OAuth Run the login command and complete the Stacksync browser sign-in. Select a default workspace; restart your Codex session if the tools are not yet listed. ``` codex mcp login stacksync ``` 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### Code editorCursor Use Stacksync from Cursor by adding a remote server to its MCP configuration. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - Cursor installed with permission to configure MCP servers. 1. #### Add the server configuration Merge this stacksync entry into the mcpServers object in ~/.cursor/mcp.json. Preserve any servers you already use. ``` { "mcpServers": { "stacksync": { "url": "https://mcp.stacksync.com/mcp" } } } ``` 2. #### Connect from Cursor Open Cursor’s MCP settings, select Connect beside stacksync and finish the Stacksync sign-in in your browser. 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### Code editorVS Code Connect Stacksync to GitHub Copilot Chat in VS Code using an HTTP MCP server. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - VS Code with Copilot Chat Agent mode available. 1. #### Add Stacksync to VS Code Run the command below. Alternatively, add a stacksync entry with type http and this URL under servers in your project’s .vscode/mcp.json. ``` code --add-mcp '{"name":"stacksync","type":"http","url":"https://mcp.stacksync.com/mcp"}' ``` 2. #### Start it in Copilot Chat Open Copilot Chat in Agent mode. Start stacksync from the tools picker and complete the Stacksync browser sign-in. 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### Code editorWindsurf Add Stacksync to Cascade with Windsurf’s serverUrl configuration and OAuth sign-in. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - Windsurf installed with Cascade and MCP configuration available. 1. #### Open the MCP configuration In the Cascade panel, open the … menu and select Open MCP config file. Merge this entry into mcp_config.json without removing other servers. ``` { "mcpServers": { "stacksync": { "serverUrl": "https://mcp.stacksync.com/mcp" } } } ``` 2. #### Authorize the first connection Save the configuration. Cascade opens the Stacksync sign-in flow the first time it uses the server. Choose your default workspace. 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) #### TerminalGemini CLI Connect the Gemini command-line client to Stacksync through remote HTTP MCP and browser authorization. #### Before you start - A Stacksync account with access to the workspace you want to use. - Permission to add an external MCP server in your AI client. - Gemini CLI installed with the gemini command available. These instructions apply to Gemini CLI, not the Gemini web app. 1. #### Register Stacksync Run the following command in your terminal to add the HTTP server. ``` gemini mcp add --transport http stacksync https://mcp.stacksync.com/mcp ``` 2. #### Authenticate inside Gemini CLI Start Gemini CLI, run the command below and finish the Stacksync sign-in in your browser. ``` /mcp auth stacksync ``` 3. #### Check your workspace Ask “List my Stacksync workspaces.” Confirm the workspace before choosing a connector or preparing a change. Connecting the assistant does not start a sync. #### Check the connection Ask “List my Stacksync workspaces.” Select the workspace you want to use, then ask the assistant to inspect the available Airtable connection and capabilities. [Full setup documentation ↗](https://docs.stacksync.com/mcp/connect) 04 / Put it to work ## Airtable workflow prompts Example prompts for Airtable. The outcomes describe what to expect, not results from your account. Review the proposed configuration before running it. 01 Sync management ### Plan an Airtable reporting table > Inspect my Airtable and database connections, available tables and existing syncs. Propose a one-way replica for the base and table I select, keeping Airtable record IDs and the fields required for reporting. Identify formula fields and their documented hourly refresh behavior. Do not create or start a sync before I review the mapping. #### What to expect A reporting-table plan that distinguishes ordinary records from calculated-field freshness. 02 Connector actions ### Prepare a single-record correction > Inspect the Airtable connector actions and table schema for the record I identify. Determine whether a suitable lookup and update module exists. Propose only the requested editable-field changes with the base, table and record ID shown. Exclude formula fields and stop for my confirmation before making a write. #### What to expect A scoped record-update proposal that avoids writing computed fields. 03 Sync management ### Review formula-value freshness > Inspect my Airtable sync configuration and current issues. Identify the formula fields involved in the discrepancy I describe and compare the expected hourly formula refresh with the observed evidence. Propose checks for mapping and access before suggesting any retry or configuration change. Do not modify the base or the sync. #### What to expect A freshness diagnosis that distinguishes documented formula refresh from sync failures. 05 / Before you run ## Requirements and limitations ### What you need - Connect your AI client to Stacksync MCP, sign in and select the workspace before inspecting its resources. - Reuse an authorized app connection or open the secure connection link from Stacksync. Enter credentials in the connection form, never in the chat. - Access to the intended Airtable base and table; identify the record key and writable fields before planning updates. ### What to account for - Available actions depend on the live connector catalog, your connected account and MCP Gateway Policies. Inspect the action and its form before using it. - Stacksync documents hourly refresh for Airtable formula values. Do not promise that every computed value changes in the destination immediately. - Formula fields are calculated values. Separate editable inputs from computed outputs when proposing write-back or record changes. ### Your workspace. Your permissions. OAuth access follows your Stacksync role. Choose read-only access during sign-in when appropriate. Workspace owners can enable “Ask before every change”; it is a configurable setting. Direct connector actions also follow gateway policies. [Read about permissions and approvals ↗](https://docs.stacksync.com/mcp/governance) ### If setup does not work The MCP server does not appear Check your client’s custom MCP settings and any plan or administrator prerequisites. Reconnect using the setup instructions above. Your workspace or app is missing Verify the Stacksync account and workspace selected during OAuth, then inspect the workspace’s connections. Add missing app credentials through the secure connection flow. An action is unavailable or denied Inspect the current connector modules and required inputs. Check your workspace role, read-only consent, gateway policy, and the source app’s API permissions. 06 / Common questions ## Airtable MCP questions ### Are Airtable formula fields synchronized in real time? The formula-field documentation specifies an hourly refresh. Avoid applying general real-time sync claims to formula outputs. ### Can an AI assistant update any Airtable field? No. The action must exist, the account must have access and the field must be writable. Formula fields are computed; change their input fields only when the requested task calls for it. ### What identifies an Airtable record in a sync? Inspect the actual record identifiers and mapped columns returned by the connection. Use stable record IDs rather than assuming the visible primary field is a unique integration key. Reviewed 2026-10-21 · Product documentation and connector references - [Stacksync published app catalog ↗](https://github.com/stacksyncdata/skills/blob/prod/data/apps.json) - [Stacksync connector actions ↗](https://github.com/stacksyncdata/skills/blob/prod/skills/connectors/SKILL.md) - [Stacksync connections and schema discovery ↗](https://github.com/stacksyncdata/skills/blob/prod/skills/connections/SKILL.md) - [Stacksync sync management through MCP ↗](https://github.com/stacksyncdata/skills/blob/prod/skills/syncs/SKILL.md) - [Airtable sync capabilities ↗](https://docs.stacksync.com/two-way-sync/connectors/airtable) - [Airtable formula-field refresh ↗](https://docs.stacksync.com/two-way-sync/connectors/airtable/formula-fields) Keep building ## Connect the rest of your stack. Database ### [PostgreSQL](https://www.stacksync.com/mcp/postgresql) Prepare a bounded operational query CRM ### [Salesforce](https://www.stacksync.com/mcp/salesforce) Plan a Salesforce reporting replica CRM ### [HubSpot](https://www.stacksync.com/mcp/hubspot) Plan a contact and company replica [← All MCP connector guides](https://www.stacksync.com/mcp#connectors) [Create your Stacksync account ↗](https://app.stacksync.com/signup)