How to Use the CData Connect Cloud MCP in Vercel AI SDK

Q: How do I render tables from this MCP Server in my UI?

Use the cdatagettablecolumns tool to fetch the schema definitions. Your frontend code uses those definitions to generate data grid columns dynamically as the AI streams the layout.

Connect backend databases directly to your React UI by streaming CData Connect Cloud queries through this Vercel AI SDK MCP Server.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect CData Connect Cloud MCP to Vercel AI SDK

Create your Vinkius account to connect CData Connect Cloud 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 CData Connect Cloud with Vercel AI SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Query live data with this MCP Server

`cdata_execute_query` forms the core of this integration, letting your agent pull live records directly from backend databases. You pass a SQL string, and the server returns structured proxy data instantly. Because Vercel AI SDK handles the transport layer, these records stream straight into your frontend components while the user watches. Long database joins ruin the user experience. Combining `cdata_get_schema_metadata` with streaming text generation solves this. Your Next.js app renders column headers and partial rows before the full payload finishes downloading. The user sees a live dashboard updating in real time instead of a blank screen with a spinner.

Map backend schemas to UI components

Exposing exact field definitions happens through `cdata_get_table_columns`. Your agent reads these types and automatically maps them to React table components or form inputs. You don't need to manually type out TypeScript interfaces for every external API your app touches. Dynamic discovery relies on `cdata_list_tables` and `cdata_list_connections`. When a user asks what information exists, the agent streams a structural map back to the client. This allows dynamic UI generation based on the actual shape of the external system.

Configure new connections dynamically

Wiring up new data source proxies takes seconds with `cdata_create_connection` via this MCP Server. A user types their credentials into your Vue or Svelte frontend, and the agent provisions the endpoint immediately. The system validates the link using `cdata_test_connection` before saving anything. Managing large deployments requires `cdata_list_workspaces` to segment different groups. Your agent only queries the data relevant to the current user's session. This isolation prevents cross-tenant data leaks in your edge functions.

Setup guide

Set up CData Connect Cloud 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 CData Connect Cloud 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 CData Connect Cloud 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 CData Connect. 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 CData Connect Cloud 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 CData Connect Cloud MCP in Vercel AI SDK

Pass the Vinkius endpoint to createMCPClient using the HTTP transport. Call mcpClient.tools() and feed the result into streamText to push database rows directly to your React components.

Yes. The underlying HTTP transport protocol runs perfectly in edge environments. Your agent queries the database proxy and streams the response back without requiring a heavy Node.js runtime.

You manage auth at the Vinkius layer with a single endpoint token. The SDK authProvider handles the OAuth handshake if you need user-specific access controls for your database queries.

Use the cdata_get_table_columns tool to fetch the schema definitions. Your frontend code uses those definitions to generate data grid columns dynamically as the AI streams the layout.

Vinkius executes all database queries inside an ephemeral V8 isolate. Your raw SQL strings and returned database rows never persist on disk. Once the Vercel edge function closes the connection, the sandbox is destroyed completely.

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