coalesce transform for VS Code
io.github.coalesce-software-inc/coalesce-transform
MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.
client:VS Code
transport:stdio
runtime:npm
Install coalesce transform in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "coalesce-access-token",
"description": "COALESCE_ACCESS_TOKEN",
"password": true
},
{
"type": "promptString",
"id": "coalesce-profile",
"description": "COALESCE_PROFILE",
"password": true
},
{
"type": "promptString",
"id": "coalesce-base-url",
"description": "COALESCE_BASE_URL",
"password": true
},
{
"type": "promptString",
"id": "coalesce-org-id",
"description": "COALESCE_ORG_ID",
"password": true
},
{
"type": "promptString",
"id": "coalesce-repo-path",
"description": "COALESCE_REPO_PATH",
"password": true
},
{
"type": "promptString",
"id": "coalesce-cache-dir",
"description": "COALESCE_CACHE_DIR",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-auto-cache-max-bytes",
"description": "COALESCE_MCP_AUTO_CACHE_MAX_BYTES",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-inline-responses",
"description": "COALESCE_MCP_INLINE_RESPONSES",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-lineage-ttl-ms",
"description": "COALESCE_MCP_LINEAGE_TTL_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-max-request-body-bytes",
"description": "COALESCE_MCP_MAX_REQUEST_BODY_BYTES",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-request-timeout-ms",
"description": "COALESCE_MCP_REQUEST_TIMEOUT_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-detail-fetch-timeout-ms",
"description": "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-node-type-ranking-timeout-ms",
"description": "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-inventory-cache-ttl-ms",
"description": "COALESCE_MCP_INVENTORY_CACHE_TTL_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-node-index-cache-ttl-ms",
"description": "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-node-detail-cache-ttl-ms",
"description": "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-read-only",
"description": "COALESCE_MCP_READ_ONLY",
"password": true
},
{
"type": "promptString",
"id": "coalesce-mcp-skills-dir",
"description": "COALESCE_MCP_SKILLS_DIR",
"password": true
},
{
"type": "promptString",
"id": "snowflake-account",
"description": "SNOWFLAKE_ACCOUNT",
"password": true
},
{
"type": "promptString",
"id": "snowflake-username",
"description": "SNOWFLAKE_USERNAME",
"password": true
},
{
"type": "promptString",
"id": "snowflake-key-pair-key",
"description": "SNOWFLAKE_KEY_PAIR_KEY",
"password": true
},
{
"type": "promptString",
"id": "snowflake-pat",
"description": "SNOWFLAKE_PAT",
"password": true
},
{
"type": "promptString",
"id": "snowflake-key-pair-pass",
"description": "SNOWFLAKE_KEY_PAIR_PASS",
"password": true
},
{
"type": "promptString",
"id": "snowflake-warehouse",
"description": "SNOWFLAKE_WAREHOUSE",
"password": true
},
{
"type": "promptString",
"id": "snowflake-role",
"description": "SNOWFLAKE_ROLE",
"password": true
}
],
"servers": {
"coalesce-transform": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"coalesce-transform-mcp"
],
"env": {
"COALESCE_ACCESS_TOKEN": "${input:coalesce-access-token}",
"COALESCE_PROFILE": "${input:coalesce-profile}",
"COALESCE_BASE_URL": "${input:coalesce-base-url}",
"COALESCE_ORG_ID": "${input:coalesce-org-id}",
"COALESCE_REPO_PATH": "${input:coalesce-repo-path}",
"COALESCE_CACHE_DIR": "${input:coalesce-cache-dir}",
"COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "${input:coalesce-mcp-auto-cache-max-bytes}",
"COALESCE_MCP_INLINE_RESPONSES": "${input:coalesce-mcp-inline-responses}",
"COALESCE_MCP_LINEAGE_TTL_MS": "${input:coalesce-mcp-lineage-ttl-ms}",
"COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "${input:coalesce-mcp-max-request-body-bytes}",
"COALESCE_MCP_REQUEST_TIMEOUT_MS": "${input:coalesce-mcp-request-timeout-ms}",
"COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "${input:coalesce-mcp-detail-fetch-timeout-ms}",
"COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS": "${input:coalesce-mcp-node-type-ranking-timeout-ms}",
"COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "${input:coalesce-mcp-inventory-cache-ttl-ms}",
"COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "${input:coalesce-mcp-node-index-cache-ttl-ms}",
"COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "${input:coalesce-mcp-node-detail-cache-ttl-ms}",
"COALESCE_MCP_READ_ONLY": "${input:coalesce-mcp-read-only}",
"COALESCE_MCP_SKILLS_DIR": "${input:coalesce-mcp-skills-dir}",
"SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
"SNOWFLAKE_USERNAME": "${input:snowflake-username}",
"SNOWFLAKE_KEY_PAIR_KEY": "${input:snowflake-key-pair-key}",
"SNOWFLAKE_PAT": "${input:snowflake-pat}",
"SNOWFLAKE_KEY_PAIR_PASS": "${input:snowflake-key-pair-pass}",
"SNOWFLAKE_WAREHOUSE": "${input:snowflake-warehouse}",
"SNOWFLAKE_ROLE": "${input:snowflake-role}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs