Matillion (Cloud Data Integration & ELT)

Matillion (Cloud Data Integration & ELT) MCP Connector for Claude

A+

Manage data pipelines via Matillion — audit ETL workflows, track execution statuses, and monitor cloud environments.

6 tools Official Updated Jun 28, 2026 Official Vinkius Partner

Connect your Matillion Data Productivity Cloud account to any AI agent and take full control of your enterprise ELT orchestration and data integration lifecycle through natural conversation.

What you can do

  • Pipeline Orchestration — List all managed ETL pipelines and retrieve detailed structural components of your data transformation logic directly from your agent
  • Execution Audit — Monitor recent pipeline executions to track failed or successful deployment statuses and identify operational bottlenecks in real-time
  • Infrastructure Visibility — Enumerate active Matillion runtime agents and Hybrid SaaS components physically resolving operations across your local network
  • Environment Audit — List configured destination environments attached to cloud data warehouses like Snowflake, Redshift, or BigQuery to ensure data mapping accuracy
  • Project Management — Extract and navigate broad project containers that bind your pipelines and environments together within the Matillion Hub
  • Metadata Inspection — Deep-dive into specific pipeline IDs to retrieve the underlying orchestration definitions and schema mappings securely

How it works

  1. Subscribe to this server
  2. Enter your Matillion API URL, Client ID, and Client Secret
  3. Start managing your data productivity cloud from Claude, Cursor, or any MCP-compatible client

Who is this for?

  • Data Engineers — verify pipeline designs and audit execution logs through natural conversation without manual hub navigation
  • Analytics Leads — monitor project health and data warehouse environment statuses directly from your workspace terminal
  • BI Operations Teams — track active runtime agents and ensure high availability of critical ELT processes efficiently
elt-pipelinesdata-integrationworkflow-orchestrationdata-transformationcloud-data-warehouse

6 tools expose this connector's capabilities to your AI agent.

list_pipelines

List all Matillion ETL pipelines

get_pipeline

Get specific pipeline details

list_executions

List recent pipeline executions

list_environments

List all environment configurations

list_agents

List all Matillion runtime agents

list_projects

List all projects

See how to talk to your AI agent using Matillion (Cloud Data Integration & ELT).

List all Matillion ETL pipelines in my account

I've retrieved your ETL pipelines from the Data Productivity Cloud. Highlights include 'Sales-Data-Sync' (ID: pipe-123), 'Customer-360-View' (ID: pipe-456), and 'Finance-Consolidation' (ID: pipe-789). Would you like to see the structural components for the sales sync?

Show me the last 5 pipeline executions and their status

Retrieving recent executions… I've identified the 5 latest runs: 3 succeeded (including 'Inventory-Load'), 1 is currently 'Running' ('Marketing-Attribution'), and 1 'Failed' ('Web-Log-Ingestion'). Would you like me to investigate the error for the failed run?

What cloud environments are configured in my Matillion instance?

I've identified 3 destination environments: 'Snowflake-Prod' (Targeting: SF_WH_01), 'Redshift-Staging' (Targeting: AWS_NODE_ALPHA), and 'BigQuery-Analytics' (Targeting: GCP_DATASET_V1). I can provide the project mappings for these environments if you'd like.

Yes. Use the `list_executions` tool to retrieve the audit trail of recent Matillion workflows. Your agent will report which pipelines succeeded, which failed, and provide the operational context for each run.

Related Connectors