How to Use the CData Connect Cloud MCP in Mastra AI

Q: Does Mastra AI support human-in-the-loop for CData Connect Cloud?

You can flag specific tools like cdatacreateconnection with requireToolApproval. The workflow pauses execution until an administrator manually clears the action, preventing unauthorized infrastructure changes.

Build resilient data pipelines by connecting CData Connect Cloud to your Mastra AI workflows.

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 Mastra AI

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Route Mastra AI queries safely with this MCP Server

Extracting structured records from your backend proxy relies on `cdata_execute_query`. Mastra AI wraps this operation in its workflow engine, meaning temporary database timeouts trigger automatic retries with exponential backoff. Your data extraction pipeline won't crash just because an external API dropped a single connection. Before running a heavy extraction sequence, `cdata_test_connection` verifies the endpoint is actually alive. If the ping fails, the workflow branches to an alert path instead of blindly attempting queries that will inevitably error out. Wasted execution cycles cost money.

Navigate complex table structures

Mapping the backend graph into your agent's context window requires `cdata_get_schema_metadata`. Mastra uses this map to plan multi-step data transformations across different tables. Knowing the exact interaction limits upfront prevents the agent from requesting payloads that exceed memory constraints. Precise field definitions matter. `cdata_get_table_columns` learns the exact data types expected by the target proxy. This ensures any subsequent insert or update operations format dates and integers correctly before transmission.

Manage multiple workspaces autonomously

`cdata_list_workspaces` gives your agent visibility into how organizational data groups are segmented. A single workflow can iterate through every active workspace, extracting weekly metrics or syncing records across environments. You write one loop, and the agent handles the discovery phase. Discovering active links requires `cdata_list_connections` and `cdata_list_tables`. If a new data source appears in the proxy, your Mastra workflow detects it on the next MCP execution run. The agent can then automatically provision a mirroring job without any human intervention or code changes.

Setup guide

Set up CData Connect Cloud MCP in Mastra AI

Prerequisites

Node.js 18+ and a TypeScript project
@mastra/mcp + @mastra/core packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run npm install @mastra/mcp @mastra/core plus your preferred model provider (e.g. @ai-sdk/openai).
2

Configure the MCPClient
Create an MCPClient with your Vinkius endpoint as a URL object. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and inject tools
Call mcpClient.listTools() and spread the result into your agent's tools object. All CData Connect Cloud tools become native Mastra tools.
4

Run with any model
Swap openai("gpt-4o") for any AI SDK-compatible provider. Call agent.generate() and the agent routes tool calls through MCP automatically.

agent.ts

import { MCPClient } from "@mastra/mcp";
import { Agent } from "@mastra/core/agent";
import { openai } from "@ai-sdk/openai";

const mcpClient = new MCPClient({
  id: "cdata-connect-cloud-mcp-client",
  servers: {
    "cdata-connect-cloud-mcp": {
      url: new URL(
        "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
      ),
    },
  },
});

const agent = new Agent({
  name: "CData Connect Cloud Agent",
  model: openai("gpt-4o"),
  instructions: "You have access to CData Connect Cloud tools.",
  tools: {
    ...(await mcpClient.listTools()),
  },
});

const result = await agent.generate(
  "List recent CData Connect Cloud transactions"
);
console.log(result.text);

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 Mastra AI

Install @mastra/mcp and instantiate MCPClient with your Vinkius URL. Call mcpClient.listTools() and spread the returned array directly into your agent tool configuration.

Yes. The workflow engine wraps all tool executions in a retry wrapper. You define the exponential backoff parameters, and temporary database lockups resolve themselves without crashing the pipeline.

You can flag specific tools like cdata_create_connection with requireToolApproval. The workflow pauses execution until an administrator manually clears the action, preventing unauthorized infrastructure changes.

Mastra automatically detects and negotiates the transport layer. It defaults to Streamable HTTP for Vinkius endpoints, ensuring large database payloads transfer reliably.

Vinkius runs the integration inside a zero-trust environment. The schema metadata and structural collections pulled from your proxy exist only in memory during the workflow execution. Everything vanishes the moment the Mastra agent completes its run.

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