How to Use the Matillion (Cloud Data Integration & ELT) MCP in Windsurf

Audit your entire Matillion ETL setup without leaving your editor. Let Windsurf's Cascade agent handle the diagnostics.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Matillion (Cloud Data Integration & ELT) MCP to Windsurf

Create your Vinkius account to connect Matillion (Cloud Data Integration & ELT) 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 Matillion (Cloud Data Integration & ELT) with Windsurf

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Diagnose Failed Pipelines Autonomously

Stop digging through logs. Just tell Windsurf, "Find out why the daily sales pipeline failed." Cascade, its autonomous agent, gets to work immediately. It doesn't need you to hold its hand. Cascade chains the tools together for you. It uses `list_projects` to find the right context, `list_pipelines` to identify the job, and then `list_executions` to pull the exact error message from the most recent failed run. You get a clear answer, not a list of links to check.

Get Pre-Deployment Health Checks

Before you push a change that could break something, get a quick all-clear. Ask Windsurf to "Check the production Matillion environment and agents." It's a simple request with a powerful result. Cascade uses the `list_environments` and `list_agents` tools to confirm your infrastructure is online and ready. You get a real-time status check without switching context to a web UI. This simple step can prevent a lot of headaches.

Map Out Your Matillion Projects with this MCP Server

If you've inherited a complex Matillion setup, making sense of it can be a chore. Instead, just ask Windsurf to map it out. A prompt like, "Show me all pipelines that handle financial data," is all it takes. Cascade will intelligently query `list_pipelines` and filter the results based on your request. From there, you can dig deeper, asking it to fetch specific configurations with `get_pipeline`. It turns a messy discovery process into a quick conversation.

Setup guide

Set up Matillion (Cloud Data Integration & ELT) 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 Matillion (Cloud Data Integration & ELT) 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 Matillion (Cloud Data Integration & ELT) payment history." If connected, Cascade will call the Matillion (Cloud Data Integration & ELT) tools directly. You will see a green dot next to the server name in the MCP panel.

mcp_config.json

{
  "mcpServers": {
    "matillion-cloud-data-integration-elt-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 Matillion. 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 Matillion (Cloud Data Integration & ELT) 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 Matillion (Cloud Data Integration & ELT) MCP in Windsurf

Use the built-in MCP Marketplace in Windsurf for a one-click install. Alternatively, you can add the server URL manually in your `mcp_config.json` file. Once connected, Cascade will automatically discover all the available tools.

Yes, that's its main strength. You give Cascade a goal, and it creates and executes a plan using tools like `list_projects` and `list_executions` in sequence. You don't have to call each tool one by one.

You can automate diagnostic and audit tasks. For example, ask Windsurf to create a summary of all failed jobs in the last 24 hours or to verify all your production agents are online before a release.

Yes, all the tools are for reading data only. You can list projects, pipelines, and executions, but you can't use it to start jobs or modify your Matillion configuration. It's built for safe, secure auditing.

It only ever reads metadata about your Matillion instance. This includes project names, pipeline structures, environment configurations, and execution logs. Your actual business data flowing through the pipelines is never accessed or stored.

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