How to Use the CData Connect Cloud MCP in LangChain

Q: How do I hook up CData Connect Cloud to my LangChain agent?

Install langchain-mcp-adapters and langgraph via pip. Initialize the MultiServerMCPClient with the Vinkius endpoint, pull the tools using client.gettools(), and pass them straight to your agent.

Q: How does the agent know which tables to query?

Your agent will first run cdatalisttables to see what is in the workspace. It then uses cdatagettablecolumns to inspect the schema of a specific table before drafting the SQL query.

Run multi-step SQL queries across your cloud databases inside LangChain chains without writing API boilerplate.

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 LangChain

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Multi-step query pipelines in LangChain

The `cdata_list_tables` and `cdata_get_table_columns` tools let your agent inspect your data layout dynamically to figure out what tables are available before running a query. This MCP Server gives your LLM the ability to inspect database schemas on the fly, eliminating the need to hardcode table metadata into your chain prompts. Once the agent understands the schema, it chains the next step. It runs `cdata_execute_query` to pull the exact rows it needs, passing the raw output directly to the next node in your LangGraph run.

Dynamic connection setup on the fly

The `cdata_create_connection` tool hooks up a new backend database proxy on demand. This MCP Server allows your agent to configure a connection to a fresh data source mid-run, then test it immediately with `cdata_test_connection` to ensure the credentials work. This turns your static data pipelines into self-configuring systems. Instead of you manually provisioning endpoints, the agent spins up the proxy connection it needs based on the user's prompt.

Workspace and connection audits

The `cdata_list_workspaces` and `cdata_list_connections` tools map out your entire active database environment. Your agent can query these endpoints to see which data sources are connected, giving your LLM a bird's-eye view of your cloud sources without exposing raw database passwords. By calling `cdata_get_schema_metadata`, the agent gets a complete map of backend limits. This prevents your chains from hitting unexpected API walls or database timeouts midway through execution.

Setup guide

Set up CData Connect Cloud MCP in LangChain

Prerequisites

Python 3.10+ installed
langchain-mcp-adapters + langgraph packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run pip install langchain-mcp-adapters langgraph langchain-openai. The MCP adapters package converts MCP tools into native LangChain BaseTool objects.
2

Connect via HTTP transport
Use MultiServerMCPClient with "transport": "http" pointing to your Vinkius endpoint. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Create a ReAct agent
Pass the discovered tools to create_react_agent() from LangGraph. The agent automatically routes CData Connect Cloud tool calls through the MCP protocol.
4

Run with any LLM
Swap ChatOpenAI for ChatAnthropic, ChatGoogleGenerativeAI, or any LangChain-compatible model. The MCP tools work identically across all providers.

agent.py

from langchain_mcp_adapters.client import MultiServerMCPClient
from langgraph.prebuilt import create_react_agent
from langchain_openai import ChatOpenAI

async with MultiServerMCPClient({
    "cdata-connect-cloud-mcp": {
        "transport": "http",
        "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp",
    }
}) as client:
    tools = client.get_tools()

    agent = create_react_agent(
        ChatOpenAI(model="gpt-4o"),
        tools,
    )
    result = await agent.ainvoke({
        "messages": "List recent CData Connect Cloud transactions"
    })
    print(result["messages"][-1].content)

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 LangChain

Install `langchain-mcp-adapters` and `langgraph` via pip. Initialize the `MultiServerMCPClient` with the Vinkius endpoint, pull the tools using `client.get_tools()`, and pass them straight to your agent.

Yes. Because these tools run inside standard LangChain chains, every call to `cdata_execute_query` shows up inside LangSmith with full inputs, outputs, and latency metrics.

Your agent will first run `cdata_list_tables` to see what is in the workspace. It then uses `cdata_get_table_columns` to inspect the schema of a specific table before drafting the SQL query.

Yes, you can mix these database tools with any of LangChain's 500+ vector store and document loader integrations. This lets you build complex RAG setups that pull from both static files and live cloud databases.

Your database queries and proxy credentials are never stored on Vinkius. Every connection made via this MCP integration runs inside an isolated, ephemeral V8 sandbox that destroys its memory state as soon as your session ends.

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