Search / io.github.Coalesce-Software-Inc/coalesce-transform
protogridL0· runs locallyMCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.
v0.10.1 · active · repository · descriptor JSON · versions
{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
"SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
"SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
}
}
}
}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 [email protected][mcp_servers.coalesce-transform]
command = "npx"
args = ["-y", "[email protected]"]
env = { "COALESCE_ACCESS_TOKEN" = "${COALESCE_ACCESS_TOKEN}", "SNOWFLAKE_PAT" = "${SNOWFLAKE_PAT}", "SNOWFLAKE_KEY_PAIR_PASS" = "${SNOWFLAKE_KEY_PAIR_PASS}" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"coalesce-transform": {
"type": "local",
"command": [
"npx",
"-y",
"[email protected]"
],
"enabled": true,
"environment": {
"COALESCE_ACCESS_TOKEN": "{env:COALESCE_ACCESS_TOKEN}",
"SNOWFLAKE_PAT": "{env:SNOWFLAKE_PAT}",
"SNOWFLAKE_KEY_PAIR_PASS": "{env:SNOWFLAKE_KEY_PAIR_PASS}"
}
}
}
}{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
"SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
"SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=coalesce-transform&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsImNvYWxlc2NlLXRyYW5zZm9ybS1tY3BAMC4xMC4xIl0sImVudiI6eyJDT0FMRVNDRV9BQ0NFU1NfVE9LRU4iOiIke0NPQUxFU0NFX0FDQ0VTU19UT0tFTn0iLCJTTk9XRkxBS0VfUEFUIjoiJHtTTk9XRkxBS0VfUEFUfSIsIlNOT1dGTEFLRV9LRVlfUEFJUl9QQVNTIjoiJHtTTk9XRkxBS0VfS0VZX1BBSVJfUEFTU30ifX0%3D"
}{
"servers": {
"coalesce-transform": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
"SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
"SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
}
}
}
}{
"mcpServers": {
"coalesce-transform": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
"SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
"SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
}
}
}
}extensions:
"coalesce-transform":
enabled: true
name: "coalesce-transform"
type: stdio
cmd: "npx"
args:
- "-y"
- "[email protected]"
envs:
"COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}"
"SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}"
"SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
timeout: 300
Placeholders to fill from your own secret store: ${COALESCE_ACCESS_TOKEN}, ${SNOWFLAKE_PAT}, ${SNOWFLAKE_KEY_PAIR_PASS}. The registry never accepts secret values.
This is a local package: the command runs on your machine.
Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)auth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)stability.changes, stability.rug_pulltool list unknownNo tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.
Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.
+repository +namespace-matches-repo ~liveness-unmeasured ~updated-109d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
[email protected] npmthis version is not known to the dependency resolver
Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
coalesce-transform-mcp | npm | 0.10.1 | – | COALESCE_ACCESS_TOKEN, SNOWFLAKE_PAT, SNOWFLAKE_KEY_PAIR_PASS |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
{
"name": "io.github.Coalesce-Software-Inc/coalesce-transform",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.10.1",
"packages": [
{
"version": "0.10.1",
"transport": {
"type": "stdio"
},
"identifier": "coalesce-transform-mcp",
"registryType": "npm",
"environmentVariables": [
{
"name": "COALESCE_ACCESS_TOKEN",
"format": "string",
"isSecret": true,
"description": "Bearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`."
},
{
"name": "COALESCE_PROFILE",
"format": "string",
"description": "Selects which `~/.coa/config` profile to load. Defaults to default."
},
{
"name": "COALESCE_BASE_URL",
"format": "string",
"description": "Region-specific base URL. Defaults to https://app.coalescesoftware.io (US)."
},
{
"name": "COALESCE_ORG_ID",
"format": "string",
"description": "Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile."
},
{
"name": "COALESCE_REPO_PATH",
"format": "string",
"description": "Local repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile."
},
{
"name": "COALESCE_CACHE_DIR",
"format": "string",
"description": "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."
},
{
"name": "COALESCE_MCP_AUTO_CACHE_MAX_BYTES",
"format": "string",
"description": "JSON size threshold before auto-caching to disk. Defaults to 32768."
},
{
"name": "COALESCE_MCP_INLINE_RESPONSES",
"format": "string",
"description": "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)."
},
{
"name": "COALESCE_MCP_LINEAGE_TTL_MS",
"format": "string",
"description": "In-memory lineage cache TTL in milliseconds. Defaults to 1800000."
},
{
"name": "COALESCE_MCP_MAX_REQUEST_BODY_BYTES",
"format": "string",
"description": "Max outbound API request body size. Defaults to 524288."
},
{
"name": "COALESCE_MCP_REQUEST_TIMEOUT_MS",
"format": "string",
"description": "Default per-request timeout for Coalesce API calls. Raise on large workspaces where paginated reads exceed the default. Defaults to 60000."
},
{
"name": "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS",
"format": "string",
"description": "Per-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000."
},
{
"name": "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS",
"format": "string",
"description": "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."
},
{
"name": "COALESCE_MCP_INVENTORY_CACHE_TTL_MS",
"format": "string",
"description": "In-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000."
},
{
"name": "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS",
"format": "string",
"description": "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."
},
{
"name": "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS",
"format": "string",
"description": "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."
},
{
"name": "COALESCE_MCP_READ_ONLY",
"format": "string",
"description": "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."
},
{
"name": "COALESCE_MCP_SKILLS_DIR",
"format": "string",
"description": "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."
},
{
"name": "SNOWFLAKE_ACCOUNT",
"format": "string",
"description": "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)"
},
{
"name": "SNOWFLAKE_USERNAME",
"format": "string",
"description": "Snowflake account username (required for run tools)"
},
{
"name": "SNOWFLAKE_KEY_PAIR_KEY",
"format": "string",
"description": "Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)"
},
{
"name": "SNOWFLAKE_PAT",
"format": "string",
"isSecret": true,
"description": "Snowflake Programmatic Access Token (alternative to key pair)"
},
{
"name": "SNOWFLAKE_KEY_PAIR_PASS",
"format": "string",
"isSecret": true,
"description": "Passphrase for encrypted keys"
},
{
"name": "SNOWFLAKE_WAREHOUSE",
"format": "string",
"description": "Snowflake compute warehouse (required for run tools)"
},
{
"name": "SNOWFLAKE_ROLE",
"format": "string",
"description": "Snowflake user role (required for run tools)"
}
]
}
],
"repository": {
"url": "https://github.com/Coalesce-Software-Inc/coalesce-transform-mcp",
"source": "github"
},
"description": "MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs."
}