io.github.Coalesce-Software-Inc/coalesce-transform

Command

Environment

• COALESCE_ACCESS_TOKENsecret

  Bearer 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_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_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_PATsecret

  Snowflake Programmatic Access Token (alternative to key pair)

• SNOWFLAKE_KEY_PAIR_PASSsecret

  Passphrase for encrypted keys

• SNOWFLAKE_WAREHOUSE

  Snowflake compute warehouse (required for run tools)

• SNOWFLAKE_ROLE

  Snowflake user role (required for run tools)