How to Use the Airtable MCP in Vercel AI SDK

Q: How does the AI know which Airtable base to query?

The agent calls listbases first to see what is available. Then it uses listtables to drill down into the specific data.

Connect Airtable to your Vercel AI SDK frontend and stream live database updates straight into the React UI.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Airtable MCP to Vercel AI SDK

Create your Vinkius account to connect Airtable to Vercel AI SDK and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Airtable with Vercel AI SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Stream Airtable records into React

End users want to see data appear instantly. You pass `search_records` to your LLM, and the results stream into your Next.js frontend without loading spinners. Fetching entire bases works the same way over the MCP connection. The agent calls `list_records` and your Svelte or Vue interface builds the table row by row while the user watches.

Read the exact base schema

Building a UI that edits spreadsheets requires knowing the column types first. Your agent uses `get_base_metadata` to map out the structure before touching any actual data. Once it knows the layout, the AI calls `list_fields` to render dynamic forms. Users get dropdowns that match the actual Airtable configuration exactly.

Edit records via Vercel AI SDK MCP Server

Chat interfaces feel broken when users have to leave the app to save changes. Give your agent `update_records` and `create_records` so it writes back to the base directly from the chat. Deletions work too. A user asks to clear old inventory, the agent fires `delete_records`, and the UI updates instantly.

Setup guide

Set up Airtable MCP in Vercel AI SDK

Prerequisites

Node.js 18+ and a TypeScript project
ai + @modelcontextprotocol/sdk packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies

Run npm install ai @modelcontextprotocol/sdk plus your preferred model provider (e.g. @ai-sdk/openai).
2

Create the Streamable HTTP transport

Use StreamableHTTPClientTransport with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and use tools

Call mcpClient.tools() to auto-discover all Airtable tools. Pass them directly to generateText() or streamText() — no manual schema definitions needed.
4

Works with any model provider

Swap openai("gpt-4o") for any AI SDK provider — Anthropic, Google, Mistral. The MCP tools work identically across all supported models.

index.ts

import { experimental_createMCPClient as createMCPClient } from "ai";
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp";
import { generateText } from "ai";
import { openai } from "@ai-sdk/openai";

const transport = new StreamableHTTPClientTransport(
  new URL("https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp")
);

const mcpClient = await createMCPClient({ transport });
const tools = await mcpClient.tools();

const { text } = await generateText({
  model: openai("gpt-4o"),
  tools,
  prompt: "List recent Airtable transactions",
});

console.log(text);
await mcpClient.close();

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Airtable. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Airtable now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Airtable MCP in Vercel AI SDK

Pass your Vinkius endpoint token to createMCPClient. The platform handles the actual Airtable OAuth or API keys behind the scenes.

Yes. Pass the tools from mcpClient.tools() into streamText. The records pipe straight to the frontend as the agent fetches them.

It runs perfectly on the edge. You just need to call mcpClient.close() when the text generation finishes to prevent hanging connections.

The agent calls list_bases first to see what is available. Then it uses list_tables to drill down into the specific data.

Your spreadsheet rows and base schemas run through a V8 Isolate Sandbox on Vinkius. The environment lives only for the duration of the request and destroys itself immediately after execution.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript