Skip to content
mcp/skillhub

Coalesce Transform MCP Server

by coalesce-software-incio.github.Coalesce-Software-Inc/coalesce-transformv0.10.1

MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.

Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Slowing3mo ago

Install Coalesce Transform MCP server

Install in Claude Code

claude mcp add coalesce-transform -e COALESCE_ACCESS_TOKEN='<coalesce-access-token>' -e SNOWFLAKE_PAT='<snowflake-pat>' -e SNOWFLAKE_KEY_PAIR_PASS='<snowflake-key-pair-pass>' -- npx -y coalesce-transform-mcp

Configuration

VariableRequiredSecretDescription
COALESCE_ACCESS_TOKEN—yesBearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.
COALESCE_PROFILE——Selects which `~/.coa/config` profile to load. Defaults to default.
COALESCE_BASE_URL——Region-specific base URL. Defaults to https://app.coalescesoftware.io (US).
COALESCE_ORG_ID——Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.
COALESCE_REPO_PATH——Local repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.
COALESCE_CACHE_DIR——Base 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_BYTES——JSON size threshold before auto-caching to disk. Defaults to 32768.
COALESCE_MCP_INLINE_RESPONSES——Forces large responses inline as text instead of auto-caching them to disk and returning a `resource_link` (and suppresses per-field cache resource links). The server already auto-enables this for clients known not to support MCP resources (e.g. Snowflake Cortex), which otherwise render the link as unreadable "binary data" and retry in a loop. Set `true` to force it on for an unrecognised client, or `false` to disable auto-detection. Leave unset for Claude/Cursor to keep large payloads out of context. Defaults to false (auto-enabled for resource-less clients).
COALESCE_MCP_LINEAGE_TTL_MS——In-memory lineage cache TTL in milliseconds. Defaults to 1800000.
COALESCE_MCP_MAX_REQUEST_BODY_BYTES——Max outbound API request body size. Defaults to 524288.
COALESCE_MCP_REQUEST_TIMEOUT_MS——Default per-request timeout for Coalesce API calls. Raise on large workspaces where paginated reads exceed the default. Defaults to 60000.
COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS——Per-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000.
COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS——Deadline for the best-effort workspace-adoption node-type ranking lookup inside node creation. Advisory only — creation proceeds without a ranking suggestion if this trips. Defaults to 15000.
COALESCE_MCP_INVENTORY_CACHE_TTL_MS——In-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS——In-memory TTL for the workspace node-index (id/name/type/location) cache used by SQL- and intent-ref resolution. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS——In-memory TTL for the workspace node-detail (full body) cache used by review and predecessor lookups. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_READ_ONLY——When `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_DIR——Directory 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_ACCOUNT——Snowflake 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_USERNAME——Snowflake account username (required for run tools)
SNOWFLAKE_KEY_PAIR_KEY——Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)
SNOWFLAKE_PAT—yesSnowflake Programmatic Access Token (alternative to key pair)
SNOWFLAKE_KEY_PAIR_PASS—yesPassphrase for encrypted keys
SNOWFLAKE_WAREHOUSE——Snowflake compute warehouse (required for run tools)
SNOWFLAKE_ROLE——Snowflake user role (required for run tools)

Freshness

Slowing — last maintenance signal 3mo ago. The newest of the signals below sets the band.

  1. Last commit (default branch)

    no data · GitHub

  2. Latest release

    no data · GitHub

  3. Package published

    no data · npm/PyPI

  4. Registry entry updated

    2026-07-03 · 3mo ago · official registry · v0.10.1

FAQ

›How do I install the Coalesce Transform MCP server in Claude Code?

Run: claude mcp add coalesce-transform -e COALESCE_ACCESS_TOKEN='<coalesce-access-token>' -e SNOWFLAKE_PAT='<snowflake-pat>' -e SNOWFLAKE_KEY_PAIR_PASS='<snowflake-key-pair-pass>' -- npx -y coalesce-transform-mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Coalesce Transform require an API key?

Yes. It expects COALESCE_ACCESS_TOKEN, SNOWFLAKE_PAT, SNOWFLAKE_KEY_PAIR_PASS, of which 3 are secrets.

›Can I use Coalesce Transform as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Coalesce Transform in the official MCP registry?

Yes, as io.github.Coalesce-Software-Inc/coalesce-transform.