Coalesce

Coalesce MCP Connector for Claude

F

Enable your AI agent to manage Snowflake data pipelines, trigger transformations, and monitor jobs via the Coalesce API.

8 tools Official Updated Jun 28, 2026 Official Vinkius Partner

Connect your AI to Coalesce, the data transformation platform built for Snowflake with a column-aware approach.

What you can do

  • Environment Management — List all environments in your Coalesce organization and inspect their configurations.
  • Job Monitoring — Check the status of the last run for any environment and view execution logs.
  • Trigger Transformations — Start transformation jobs on demand with optional node selectors to target specific pipelines.

How it works

  1. Add the Coalesce integration to your AI toolset.
  2. Provide your API Token (from Organization Settings > API Tokens).
  3. Manage your data pipelines via natural language.

Who is this for?

  • Data Engineers — Trigger and monitor pipeline runs without opening the Coalesce UI.
  • Analytics Engineers — Check job statuses and debug failed transformations from chat.
  • Data Team Leads — Get quick overviews of environment health and recent job results.
data-transformationsnowflakeetl-pipelinedata-engineeringjob-monitoringcolumn-aware

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

get_environment

Retrieve detailed information about a specific environment

get_job_details

Retrieve detailed information about a specific job

get_run_status

Check the current status and progress of a triggered run

list_environments

Retrieve all environments configured in your Coalesce organization

list_jobs

Retrieve a list of jobs, optionally filtered by environment

list_nodes

Retrieve metadata about transformation nodes in a specific environment

trigger_job

Trigger a specific job in an environment

trigger_run

Trigger a new run for a specific environment and optionally a job

See how to talk to your AI agent using Coalesce.

Show me all environments in my Coalesce organization.

You have 3 environments: 1. 'Production' (env-001) — Last run: success, 2h ago 2. 'Staging' (env-002) — Last run: success, 5h ago 3. 'Development' (env-003) — Last run: failed, 1h ago Would you like to check the failed run details?

Trigger job 'job-yyyy' in environment 'env-xxxx'.

Job 'job-yyyy' triggered in environment 'env-xxxx'. Run ID: run-8k3m. Status: running. Estimated completion: ~4 minutes.

What is the status of the ongoing production data pipeline?

The production pipeline (Run ID: run-9g1l) is currently at 85%. All dimension tables have refreshed successfully, and the fact nodes are currently materializing in Snowflake.

In the Coalesce UI, go to **Organization Settings > API Tokens** and generate a new token. Copy it and paste it below.

Related Connectors