How to Use the CData Connect Cloud MCP in Windsurf

Q: Can Windsurf create new CData Connect Cloud connections for me?

Yes. The cdatacreateconnection tool allows Windsurf's Cascade agent to configure new data sources directly. You can just tell it to 'add a connection to the new staging database' with the right credentials.

Connect Windsurf to any API or database. Give Cascade a goal, and it will query, connect, and map data structures on its own.

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 Windsurf

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Autonomous Data Discovery and Querying

Let Windsurf's Cascade agent figure out your data landscape for you. Just ask it to find customer info or sales data. It automatically uses `cdata_list_workspaces` and `cdata_list_connections` to see what's available, then digs into schemas with `cdata_list_tables` and `cdata_get_table_columns` to understand the layout. Once Cascade has a map of the data, it can execute complex requests. Tell it to 'pull Q4 revenue from the production database,' and it will find the right connection and run the `cdata_execute_query` tool. You get the results without writing a single line of SQL.

Manage CData Connections with this MCP Server

Your agent can now manage your CData Connect Cloud setup directly. Need to add a new data source? Cascade can use the `cdata_create_connection` tool to configure it without you ever leaving your editor. No more context switching to a web UI. This also works for maintenance. You can ask Windsurf to check on a connection's status. It'll ping the endpoint with `cdata_test_connection` and report back if there's a problem. It's like having a data engineer on call, right inside your IDE.

Full Schema Introspection for Complex Tasks

Sometimes you need more than just table and column names. For intricate tasks, Windsurf's agent can use `cdata_get_schema_metadata` to get a complete picture of the backend data source, including interaction limits and available operations. This gives Cascade the deep context it needs to plan more complex, multi-step actions. It's not just guessing; it knows the exact capabilities of each data source before it tries to act. That means fewer errors and more reliable results when you ask it to perform a complicated data task.

Setup guide

Set up CData Connect Cloud MCP in Windsurf

Prerequisites

Windsurf IDE installed (macOS, Windows, or Linux)
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Click the Cascade assistant icon in the sidebar, then click the hammer icon (🔨) at the top of the panel. Select "Configure" to open ~/.codeium/windsurf/mcp_config.json.
2

Add the CData Connect Cloud MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Refresh MCPs

Go back to the hammer icon (🔨) in Cascade and click "Refresh". Windsurf will detect the new server. No full restart is needed — the connection is hot-reloaded.
4

Verify in Cascade

Start a new Cascade conversation and ask something like "Show my CData Connect Cloud payment history." If connected, Cascade will call the CData Connect Cloud tools directly. You will see a green dot next to the server name in the MCP panel.

mcp_config.json

{
  "mcpServers": {
    "cdata-connect-cloud-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

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 Windsurf

Add the CData Connect Cloud server from the built-in MCP Marketplace in Windsurf. Alternatively, you can add the server URL manually in your settings. Cascade immediately discovers all the CData tools and can use them in its plans.

Yes. The `cdata_create_connection` tool allows Windsurf's Cascade agent to configure new data sources directly. You can just tell it to 'add a connection to the new staging database' with the right credentials.

You can automate any task that involves fetching or managing data. For example, ask Windsurf to 'get all active users from Hubspot and put their emails in a new file'. Cascade will chain together tools like `cdata_execute_query` to get the data and then use other tools to create the file.

The server gives Windsurf's agent a set of tools to inspect your data sources. It uses `cdata_list_tables` and `cdata_get_table_columns` to learn your database schemas on the fly. This is how it can answer questions and fetch data without you having to specify the table and column names every time.

Your credentials and query data are proxied through the MCP Server but not stored. Vinkius runs each server in an ephemeral, zero-trust sandbox. The connection between Windsurf and the MCP server is secured, and your CData credentials are only used for the duration of the operation.

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