Coalesce Transform
MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.
- Pricing
- Open source
- Runs
- Locally
- Version
- 0.7.2
- Listing updated
- 5 days ago
About Coalesce Transform
Coalesce Transform is an open-source MCP server. It runs locally on your machine and is started by your AI client.
Install
Run in a terminal
claude mcp add coalesce-transform --env COALESCE_ACCESS_TOKEN='<COALESCE_ACCESS_TOKEN>' --env SNOWFLAKE_PAT='<SNOWFLAKE_PAT>' --env SNOWFLAKE_KEY_PAIR_PASS='<SNOWFLAKE_KEY_PAIR_PASS>' -- npx -y coalesce-transform-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
"SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
"SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"coalesce-transform": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
"SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
"SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
"SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
COALESCE_ACCESS_TOKENBearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.COALESCE_PROFILESelects which `~/.coa/config` profile to load. Defaults to default.COALESCE_BASE_URLRegion-specific base URL. Defaults to https://app.coalescesoftware.io (US).COALESCE_ORG_IDFallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.COALESCE_REPO_PATHLocal repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.COALESCE_CACHE_DIRBase directory for the local data cache. When set, cache files are written here instead of the working directory. Also readable from `cacheDir` in the active ~/.coa/config profile.COALESCE_MCP_AUTO_CACHE_MAX_BYTESJSON size threshold before auto-caching to disk. Defaults to 32768.COALESCE_MCP_LINEAGE_TTL_MSIn-memory lineage cache TTL in milliseconds. Defaults to 1800000.COALESCE_MCP_MAX_REQUEST_BODY_BYTESMax outbound API request body size. Defaults to 524288.COALESCE_MCP_READ_ONLYWhen `true`, hides all write/mutation tools during registration. Only read, list, search, cache, analyze, review, diagnose, and plan tools are exposed. Defaults to false.COALESCE_MCP_SKILLS_DIRDirectory for customizable AI skill resources. When set, reads context resources from this directory and seeds defaults on first run. Users can augment or override any skill.SNOWFLAKE_ACCOUNTSnowflake account identifier (e.g., `abc12345.us-east-1`). Required by the local `coa` CLI and `coa doctor`; not used by the MCP's REST run path. (required for run tools)SNOWFLAKE_USERNAMESnowflake account username (required for run tools)SNOWFLAKE_KEY_PAIR_KEYPath to PEM-encoded private key (required if SNOWFLAKE_PAT not set)SNOWFLAKE_PATSnowflake Programmatic Access Token (alternative to key pair)SNOWFLAKE_KEY_PAIR_PASSPassphrase for encrypted keysSNOWFLAKE_WAREHOUSESnowflake compute warehouse (required for run tools)SNOWFLAKE_ROLESnowflake user role (required for run tools)
Pricing
Open source
Coalesce Transform FAQ
Is Coalesce Transform free?
Yes. Coalesce Transform is open source, so you can use and self-host it for free.
How do I add Coalesce Transform to Claude Code?
Run this command in your terminal: claude mcp add coalesce-transform --env COALESCE_ACCESS_TOKEN='<COALESCE_ACCESS_TOKEN>' --env SNOWFLAKE_PAT='<SNOWFLAKE_PAT>' --env SNOWFLAKE_KEY_PAIR_PASS='<SNOWFLAKE_KEY_PAIR_PASS>' -- npx -y coalesce-transform-mcp
Where this comes from
- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.