io.github.Coalesce-Software-Inc/coalesce-transform MCP Server
io.github.Coalesce-Software-Inc/coalesce-transform
What is the io.github.Coalesce-Software-Inc/coalesce-transform MCP server?
MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.
How to install io.github.Coalesce-Software-Inc/coalesce-transform
Copy-paste configuration for popular MCP clients.
COALESCE_ACCESS_TOKENsecretBearer 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_INLINE_RESPONSESForces 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_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_REQUEST_TIMEOUT_MSDefault 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_MSPer-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000.
COALESCE_MCP_INVENTORY_CACHE_TTL_MSIn-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_INDEX_CACHE_TTL_MSIn-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_MSIn-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_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_PATsecretSnowflake Programmatic Access Token (alternative to key pair)
SNOWFLAKE_KEY_PAIR_PASSsecretPassphrase for encrypted keys
SNOWFLAKE_WAREHOUSESnowflake compute warehouse (required for run tools)
SNOWFLAKE_ROLESnowflake user role (required for run tools)
{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<YOUR_COALESCE_ACCESS_TOKEN>",
"COALESCE_PROFILE": "<YOUR_COALESCE_PROFILE>",
"COALESCE_BASE_URL": "<YOUR_COALESCE_BASE_URL>",
"COALESCE_ORG_ID": "<YOUR_COALESCE_ORG_ID>",
"COALESCE_REPO_PATH": "<YOUR_COALESCE_REPO_PATH>",
"COALESCE_CACHE_DIR": "<YOUR_COALESCE_CACHE_DIR>",
"COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<YOUR_COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
"COALESCE_MCP_INLINE_RESPONSES": "<YOUR_COALESCE_MCP_INLINE_RESPONSES>",
"COALESCE_MCP_LINEAGE_TTL_MS": "<YOUR_COALESCE_MCP_LINEAGE_TTL_MS>",
"COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<YOUR_COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
"COALESCE_MCP_REQUEST_TIMEOUT_MS": "<YOUR_COALESCE_MCP_REQUEST_TIMEOUT_MS>",
"COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<YOUR_COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
"COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
"COALESCE_MCP_READ_ONLY": "<YOUR_COALESCE_MCP_READ_ONLY>",
"COALESCE_MCP_SKILLS_DIR": "<YOUR_COALESCE_MCP_SKILLS_DIR>",
"SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_USERNAME": "<YOUR_SNOWFLAKE_USERNAME>",
"SNOWFLAKE_KEY_PAIR_KEY": "<YOUR_SNOWFLAKE_KEY_PAIR_KEY>",
"SNOWFLAKE_PAT": "<YOUR_SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<YOUR_SNOWFLAKE_KEY_PAIR_PASS>",
"SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
"SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>"
}
}
}
}{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<YOUR_COALESCE_ACCESS_TOKEN>",
"COALESCE_PROFILE": "<YOUR_COALESCE_PROFILE>",
"COALESCE_BASE_URL": "<YOUR_COALESCE_BASE_URL>",
"COALESCE_ORG_ID": "<YOUR_COALESCE_ORG_ID>",
"COALESCE_REPO_PATH": "<YOUR_COALESCE_REPO_PATH>",
"COALESCE_CACHE_DIR": "<YOUR_COALESCE_CACHE_DIR>",
"COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<YOUR_COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
"COALESCE_MCP_INLINE_RESPONSES": "<YOUR_COALESCE_MCP_INLINE_RESPONSES>",
"COALESCE_MCP_LINEAGE_TTL_MS": "<YOUR_COALESCE_MCP_LINEAGE_TTL_MS>",
"COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<YOUR_COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
"COALESCE_MCP_REQUEST_TIMEOUT_MS": "<YOUR_COALESCE_MCP_REQUEST_TIMEOUT_MS>",
"COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<YOUR_COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
"COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
"COALESCE_MCP_READ_ONLY": "<YOUR_COALESCE_MCP_READ_ONLY>",
"COALESCE_MCP_SKILLS_DIR": "<YOUR_COALESCE_MCP_SKILLS_DIR>",
"SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_USERNAME": "<YOUR_SNOWFLAKE_USERNAME>",
"SNOWFLAKE_KEY_PAIR_KEY": "<YOUR_SNOWFLAKE_KEY_PAIR_KEY>",
"SNOWFLAKE_PAT": "<YOUR_SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<YOUR_SNOWFLAKE_KEY_PAIR_PASS>",
"SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
"SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>"
}
}
}
}{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<YOUR_COALESCE_ACCESS_TOKEN>",
"COALESCE_PROFILE": "<YOUR_COALESCE_PROFILE>",
"COALESCE_BASE_URL": "<YOUR_COALESCE_BASE_URL>",
"COALESCE_ORG_ID": "<YOUR_COALESCE_ORG_ID>",
"COALESCE_REPO_PATH": "<YOUR_COALESCE_REPO_PATH>",
"COALESCE_CACHE_DIR": "<YOUR_COALESCE_CACHE_DIR>",
"COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<YOUR_COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
"COALESCE_MCP_INLINE_RESPONSES": "<YOUR_COALESCE_MCP_INLINE_RESPONSES>",
"COALESCE_MCP_LINEAGE_TTL_MS": "<YOUR_COALESCE_MCP_LINEAGE_TTL_MS>",
"COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<YOUR_COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
"COALESCE_MCP_REQUEST_TIMEOUT_MS": "<YOUR_COALESCE_MCP_REQUEST_TIMEOUT_MS>",
"COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<YOUR_COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
"COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
"COALESCE_MCP_READ_ONLY": "<YOUR_COALESCE_MCP_READ_ONLY>",
"COALESCE_MCP_SKILLS_DIR": "<YOUR_COALESCE_MCP_SKILLS_DIR>",
"SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_USERNAME": "<YOUR_SNOWFLAKE_USERNAME>",
"SNOWFLAKE_KEY_PAIR_KEY": "<YOUR_SNOWFLAKE_KEY_PAIR_KEY>",
"SNOWFLAKE_PAT": "<YOUR_SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<YOUR_SNOWFLAKE_KEY_PAIR_PASS>",
"SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
"SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>"
}
}
}
}{
"servers": {
"coalesce-transform": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "<YOUR_COALESCE_ACCESS_TOKEN>",
"COALESCE_PROFILE": "<YOUR_COALESCE_PROFILE>",
"COALESCE_BASE_URL": "<YOUR_COALESCE_BASE_URL>",
"COALESCE_ORG_ID": "<YOUR_COALESCE_ORG_ID>",
"COALESCE_REPO_PATH": "<YOUR_COALESCE_REPO_PATH>",
"COALESCE_CACHE_DIR": "<YOUR_COALESCE_CACHE_DIR>",
"COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<YOUR_COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
"COALESCE_MCP_INLINE_RESPONSES": "<YOUR_COALESCE_MCP_INLINE_RESPONSES>",
"COALESCE_MCP_LINEAGE_TTL_MS": "<YOUR_COALESCE_MCP_LINEAGE_TTL_MS>",
"COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<YOUR_COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
"COALESCE_MCP_REQUEST_TIMEOUT_MS": "<YOUR_COALESCE_MCP_REQUEST_TIMEOUT_MS>",
"COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<YOUR_COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
"COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
"COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<YOUR_COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
"COALESCE_MCP_READ_ONLY": "<YOUR_COALESCE_MCP_READ_ONLY>",
"COALESCE_MCP_SKILLS_DIR": "<YOUR_COALESCE_MCP_SKILLS_DIR>",
"SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
"SNOWFLAKE_USERNAME": "<YOUR_SNOWFLAKE_USERNAME>",
"SNOWFLAKE_KEY_PAIR_KEY": "<YOUR_SNOWFLAKE_KEY_PAIR_KEY>",
"SNOWFLAKE_PAT": "<YOUR_SNOWFLAKE_PAT>",
"SNOWFLAKE_KEY_PAIR_PASS": "<YOUR_SNOWFLAKE_KEY_PAIR_PASS>",
"SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
"SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>"
}
}
}
}claude mcp add coalesce-transform --env COALESCE_ACCESS_TOKEN=<YOUR_COALESCE_ACCESS_TOKEN> --env COALESCE_PROFILE=<YOUR_COALESCE_PROFILE> --env COALESCE_BASE_URL=<YOUR_COALESCE_BASE_URL> --env COALESCE_ORG_ID=<YOUR_COALESCE_ORG_ID> --env COALESCE_REPO_PATH=<YOUR_COALESCE_REPO_PATH> --env COALESCE_CACHE_DIR=<YOUR_COALESCE_CACHE_DIR> --env COALESCE_MCP_AUTO_CACHE_MAX_BYTES=<YOUR_COALESCE_MCP_AUTO_CACHE_MAX_BYTES> --env COALESCE_MCP_INLINE_RESPONSES=<YOUR_COALESCE_MCP_INLINE_RESPONSES> --env COALESCE_MCP_LINEAGE_TTL_MS=<YOUR_COALESCE_MCP_LINEAGE_TTL_MS> --env COALESCE_MCP_MAX_REQUEST_BODY_BYTES=<YOUR_COALESCE_MCP_MAX_REQUEST_BODY_BYTES> --env COALESCE_MCP_REQUEST_TIMEOUT_MS=<YOUR_COALESCE_MCP_REQUEST_TIMEOUT_MS> --env COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS=<YOUR_COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS> --env COALESCE_MCP_INVENTORY_CACHE_TTL_MS=<YOUR_COALESCE_MCP_INVENTORY_CACHE_TTL_MS> --env COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS=<YOUR_COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS> --env COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS=<YOUR_COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS> --env COALESCE_MCP_READ_ONLY=<YOUR_COALESCE_MCP_READ_ONLY> --env COALESCE_MCP_SKILLS_DIR=<YOUR_COALESCE_MCP_SKILLS_DIR> --env SNOWFLAKE_ACCOUNT=<YOUR_SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_USERNAME=<YOUR_SNOWFLAKE_USERNAME> --env SNOWFLAKE_KEY_PAIR_KEY=<YOUR_SNOWFLAKE_KEY_PAIR_KEY> --env SNOWFLAKE_PAT=<YOUR_SNOWFLAKE_PAT> --env SNOWFLAKE_KEY_PAIR_PASS=<YOUR_SNOWFLAKE_KEY_PAIR_PASS> --env SNOWFLAKE_WAREHOUSE=<YOUR_SNOWFLAKE_WAREHOUSE> --env SNOWFLAKE_ROLE=<YOUR_SNOWFLAKE_ROLE> -- npx -y coalesce-transform-mcpRelated MCP servers
Scrapling MCP Server
Give your AI agent stealth web scraping with Cloudflare bypass and CSS selection, powered by Scrapling.
Chrome DevTools MCP
Give your AI coding agent full control of a live Chrome browser for automation, debugging, and performance analysis.
com.puter/mcp-server
Let AI agents manage your Puter files, websites, and serverless workers over MCP.
Browser automation for AI agents via MCP, powering ByteDance's Agent TARS hybrid GUI/DOM browser control.
Run arbitrary shell commands from an MCP-connected AI agent.
Filesystem access MCP server from ByteDance's UI-TARS/Agent TARS ecosystem.