io.github.jessemarshall/coalesce-transform

claude mcp add coalesce-transform -e 'COALESCE_ACCESS_TOKEN=<your coalesce_access_token>' -e 'COALESCE_PROFILE=<COALESCE_PROFILE>' -e 'COALESCE_BASE_URL=<COALESCE_BASE_URL>' -e 'COALESCE_ORG_ID=<COALESCE_ORG_ID>' -e 'COALESCE_REPO_PATH=<COALESCE_REPO_PATH>' -e 'COALESCE_CACHE_DIR=<COALESCE_CACHE_DIR>' -e 'COALESCE_MCP_AUTO_CACHE_MAX_BYTES=<COALESCE_MCP_AUTO_CACHE_MAX_BYTES>' -e 'COALESCE_MCP_LINEAGE_TTL_MS=<COALESCE_MCP_LINEAGE_TTL_MS>' -e 'COALESCE_MCP_MAX_REQUEST_BODY_BYTES=<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>' -e 'COALESCE_MCP_READ_ONLY=<COALESCE_MCP_READ_ONLY>' -e 'COALESCE_MCP_SKILLS_DIR=<COALESCE_MCP_SKILLS_DIR>' -e 'SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT>' -e 'SNOWFLAKE_USERNAME=<SNOWFLAKE_USERNAME>' -e 'SNOWFLAKE_KEY_PAIR_KEY=<SNOWFLAKE_KEY_PAIR_KEY>' -e 'SNOWFLAKE_PAT=<your snowflake_pat>' -e 'SNOWFLAKE_KEY_PAIR_PASS=<your snowflake_key_pair_pass>' -e 'SNOWFLAKE_WAREHOUSE=<SNOWFLAKE_WAREHOUSE>' -e 'SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE>' -- npx -y coalesce-transform-mcp@0.7.2

{
    "mcpServers": {
        "coalesce-transform": {
            "command": "npx",
            "args": [
                "-y",
                "coalesce-transform-mcp@0.7.2"
            ],
            "env": {
                "COALESCE_ACCESS_TOKEN": "<your coalesce_access_token>",
                "COALESCE_PROFILE": "<COALESCE_PROFILE>",
                "COALESCE_BASE_URL": "<COALESCE_BASE_URL>",
                "COALESCE_ORG_ID": "<COALESCE_ORG_ID>",
                "COALESCE_REPO_PATH": "<COALESCE_REPO_PATH>",
                "COALESCE_CACHE_DIR": "<COALESCE_CACHE_DIR>",
                "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
                "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
                "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
                "COALESCE_MCP_READ_ONLY": "<COALESCE_MCP_READ_ONLY>",
                "COALESCE_MCP_SKILLS_DIR": "<COALESCE_MCP_SKILLS_DIR>",
                "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
                "SNOWFLAKE_USERNAME": "<SNOWFLAKE_USERNAME>",
                "SNOWFLAKE_KEY_PAIR_KEY": "<SNOWFLAKE_KEY_PAIR_KEY>",
                "SNOWFLAKE_PAT": "<your snowflake_pat>",
                "SNOWFLAKE_KEY_PAIR_PASS": "<your snowflake_key_pair_pass>",
                "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
                "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
            }
        }
    }
}

متغيرات البيئة

• COALESCE_ACCESS_TOKEN سري 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_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_PAT سري Snowflake Programmatic Access Token (alternative to key pair)
• SNOWFLAKE_KEY_PAIR_PASS سري Passphrase for encrypted keys
• SNOWFLAKE_WAREHOUSE Snowflake compute warehouse (required for run tools)
• SNOWFLAKE_ROLE Snowflake user role (required for run tools)