Skip to content
VS Code

coalesce transform for VS Code

io.github.jessemarshall/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-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-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_LINEAGE_TTL_MS": "${input:coalesce-mcp-lineage-ttl-ms}",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "${input:coalesce-mcp-max-request-body-bytes}",
        "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

coalesce transform in other clients