How to Use the CData Connect Cloud MCP in VS Code Copilot

Q: How do we share CData Connect Cloud access with our team using VS Code Copilot?

Create a .vscode/mcp.json file in your project's root. Add the CData Connect Cloud MCP Server configuration there and commit it to Git. Everyone who pulls the repo will have Copilot configured automatically.

Give your entire team standardized data access in VS Code Copilot with CData Connect Cloud.

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 VS Code Copilot

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

One Config, Data for Everyone

Add the CData Connect Cloud MCP Server to your project's `.vscode/mcp.json` file and commit it. Now every developer on the team gets the same data tools in Copilot automatically. No more "it works on my machine." New hires can get straight to work. They can ask Copilot to `cdata_list_connections` and `cdata_list_tables` to understand the data landscape without needing a long onboarding session.

Your Copilot Agent as a Data Expert

When you're coding, ask Copilot to get you some data. It will use `cdata_execute_query` to fetch live results from any backend configured in CData Connect Cloud. The results appear right in the chat, ready to be dropped into your code. You can also explore schemas conversationally. Tell Copilot to "describe the `users` table," and it will use `cdata_get_table_columns` to return the exact structure. This is much faster than opening a separate DB client.

Manage Data Sources via Chat

This isn't just a read-only tool. Your Copilot agent can make changes. It can use `cdata_create_connection` to configure a new data source or `cdata_test_connection` to diagnose a problem with an existing one. This MCP Server also lets you organize data sources into logical groups. Ask Copilot to `cdata_list_workspaces` to see how connections are segmented, making it easy to distinguish between development and production environments.

Setup guide

Set up CData Connect Cloud MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the CData Connect Cloud MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the CData Connect Cloud tools listed. Try asking: "List my recent CData Connect Cloud transactions" and Copilot will invoke them automatically.

.vscode/mcp.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 VS Code Copilot

Create a `.vscode/mcp.json` file in your project's root. Add the CData Connect Cloud MCP Server configuration there and commit it to Git. Everyone who pulls the repo will have Copilot configured automatically.

Yes. If you've configured a connection to your production database in CData, you can ask VS Code Copilot questions like, "Using CData, how many users signed up yesterday?" It will run `cdata_execute_query` and give you the answer.

You're using natural language. You don't write SQL; you ask questions. Copilot translates your request into a query, gets the data, and can even help you write the code that uses it.

You need VS Code version 1.96 or newer and a GitHub Copilot subscription. The MCP Server integration works with the standard Copilot Chat feature when it's in Agent mode.

It's built for team use. Your sensitive connection credentials for databases and APIs are stored in CData Connect Cloud, not your Git repo. The `.vscode/mcp.json` file only contains the non-sensitive URL for the Vinkius server, which handles auth securely.

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