Coalesce API
Coalesce ships a documented REST API with endpoints for environments, nodes, runs, projects, users, and Git accounts. Any user can mint a personal access token in the UI. The Runs endpoints are the surface Airflow, Dagster, Prefect, and Fivetran call for orchestration.
Frequently asked questions
Coalesce scores D+ on Supergood's API Report Card. Coalesce ships a documented REST API with endpoints for environments, nodes, runs, projects, users, and Git accounts. Any user can mint a personal access token in the UI. The Runs endpoints are the surface Airflow, Dagster, Prefect, and Fivetran call for orchestration.
Without a usable official API, teams fall back on manual exports, file drops, or one-off vendor integrations. The other option is an unofficial API layer like Supergood that automates the authenticated web app directly. Site terms may apply to any integration approach, and how they apply is a determination each team makes for itself.
Coalesce is a cloud-native, visual, column-aware data transformation platform for the modern cloud data warehouse.
Primary vertical: misc (cross-industry data engineering / analytics engineering tooling). A data engineering team stands up a Coalesce workspace connected to their Snowflake account and Git provider, ingests raw data via Fivetran or Airbyte, and uses Coalesce nodes (Stage, Persistent Stage, Dimension, Fact, View, Work, etc.) to build a column-aware DAG that materializes into Snowflake tables and views.
Medium and rising. Coalesce is one of the two consistently shortlisted modern transformation platforms for Snowflake-centric data teams (the other being dbt Labs / dbt Cloud), and it is the #1 visual / metadata-driven alternative to dbt in enterprise evaluations.
Coalesce is the transformation engine sitting between raw ingested data (Fivetran, Airbyte, Snowpipe) and the gold/serving layer that powers BI, reverse-ETL, ML feature stores, and AI/agent workflows.
Coalesce was founded around 2020 and exited stealth with its launch announcement in 2021 (TechTarget).
Supergood's grades measure one thing: can a customer's engineering team get their own data out programmatically? Supergood checks six things (whether a real API exists, how access is gated, data coverage, auth quality, docs and developer experience, and stability) and rolls them into a letter grade. Supergood re-verifies grades, and they only move on evidence.
Coalesce has partial MCP support. Coalesce publishes an official MCP server as the coalesce-transform-mcp npm package, with public install instructions for Claude, Cursor, VS Code, and Snowflake Cortex Code and releases as recent as July 2026. It is not yet listed in Coalesce's own documentation and the source repository under the vendor's GitHub org is private.
Partially. MCP support for Coalesce exists but is incomplete, so what MCP clients like Claude, Cursor, and Codex can reach depends on what the available server covers.