How to Use the CData Connect Cloud MCP in OpenAI Agents SDK

Q: How does the OpenAI Agents SDK handle broken connections?

The agent runs cdatatestconnection to verify the proxy status before running queries. If a database goes offline, the agent catches the error immediately instead of sending failing SQL requests.

Stop hardcoding API integrations and let your OpenAI Agents SDK run direct SQL queries across all your cloud data sources.

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 OpenAI Agents SDK

Create your Vinkius account to connect CData Connect Cloud to OpenAI Agents 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 OpenAI Agents SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Direct Database Querying

`cdata_execute_query` is the tool your agent uses to run raw SQL queries directly against your connected databases. Instead of writing custom API endpoints for every database, you let your agent fetch, filter, and aggregate real-time data on the fly. Your agent runs queries inside a secure sandbox without exposing raw credentials. By combining this with `cdata_test_connection`, the system validates the pipeline before executing heavy database loads.

Schema mapping with your OpenAI Agents SDK

`cdata_get_schema_metadata` and `cdata_get_table_columns` allow your agent to inspect database structures and table fields dynamically. Using this MCP Server, your agent doesn't need to guess column names or data types because it inspects the exact schema boundaries before writing queries. This prevents broken database calls when schemas change. Your agent checks the structure using `cdata_list_tables` first, then pulls the exact columns it needs to process the user's request.

Manage active data sources on the fly

`cdata_list_connections` gives your agent immediate visibility into every active external data source configured in your workspace. If a required connection is missing, the agent triggers `cdata_create_connection` to configure a new proxy natively. Segmenting access is straightforward because the agent uses `cdata_list_workspaces` to keep data isolated by department or project. This setup ensures your production agent only touches the specific data groups it has authorization to read.

Setup guide

Set up CData Connect Cloud MCP in OpenAI Agents SDK

Prerequisites

Python 3.10+ installed
openai-agents package (pip install openai-agents)
Active Vinkius subscription with a valid endpoint token

1

Install the SDK

Run pip install openai-agents to install the OpenAI Agents SDK. The MCP integration is built-in — no extra dependencies needed.
2

Connect via SSE transport

Use MCPServerSse with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. The SDK auto-discovers all CData Connect Cloud tools at runtime.
3

Create your Agent

Pass the MCP to Agent(mcp_servers=[server]). The agent receives CData Connect Cloud tools as native definitions — JSON schemas resolve automatically.
4

Run the agent

Call Runner.run(agent, prompt) to execute. The agent invokes the appropriate CData Connect Cloud tools and returns structured results. Copy the full example on the right to get started.

agent.py

import asyncio
from agents import Agent, Runner
from agents.mcp import MCPServerSse

async def main():
    async with MCPServerSse(
        url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    ) as server:
        agent = Agent(
            name="CData Connect Cloud Agent",
            instructions="You have access to CData Connect Cloud tools.",
            mcp_servers=[server],
        )
        result = await Runner.run(agent, "List recent transactions")
        print(result.final_output)

asyncio.run(main())

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 OpenAI Agents SDK

You register the MCP server endpoint during agent initialization. The agent auto-discovers tools like `cdata_list_connections` and executes them natively within your Python workflow.

Yes. You control access by configuring specific workspaces and querying them via `cdata_list_workspaces`. Your agent only sees the database tables exposed to that specific connection profile.

The agent runs `cdata_test_connection` to verify the proxy status before running queries. If a database goes offline, the agent catches the error immediately instead of sending failing SQL requests.

You can query any connected source by switching connection targets. The agent coordinates these calls by pulling active targets from `cdata_list_connections` and querying them individually.

Your raw database credentials never pass through the AI model or the client. This MCP Server routes requests through secure V8 sandboxes that isolate your connection strings, returning only the query results.

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