coalesce-transform

{
  "id": "io.github.Coalesce-Software-Inc/coalesce-transform",
  "type": "mcp-server",
  "version": "0.9.3",
  "displayName": "coalesce-transform",
  "description": "MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.",
  "repository": {
    "url": "https://github.com/Coalesce-Software-Inc/coalesce-transform-mcp",
    "source": "github"
  },
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "coalesce-transform-mcp",
        "version": "0.9.3",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "COALESCE_ACCESS_TOKEN",
            "description": "Bearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.",
            "isSecret": true
          },
          {
            "name": "COALESCE_PROFILE",
            "description": "Selects which `~/.coa/config` profile to load. Defaults to default."
          },
          {
            "name": "COALESCE_BASE_URL",
            "description": "Region-specific base URL. Defaults to https://app.coalescesoftware.io (US)."
          },
          {
            "name": "COALESCE_ORG_ID",
            "description": "Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile."
          },
          {
            "name": "COALESCE_REPO_PATH",
            "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",
            "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",
            "description": "JSON size threshold before auto-caching to disk. Defaults to 32768."
          },
          {
            "name": "COALESCE_MCP_LINEAGE_TTL_MS",
            "description": "In-memory lineage cache TTL in milliseconds. Defaults to 1800000."
          },
          {
            "name": "COALESCE_MCP_MAX_REQUEST_BODY_BYTES",
            "description": "Max outbound API request body size. Defaults to 524288."
          },
          {
            "name": "COALESCE_MCP_REQUEST_TIMEOUT_MS",
            "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",
            "description": "Per-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000."
          },
          {
            "name": "COALESCE_MCP_INVENTORY_CACHE_TTL_MS",
            "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",
            "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",
            "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",
            "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",
            "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",
            "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",
            "description": "Snowflake account username (required for run tools)"
          },
          {
            "name": "SNOWFLAKE_KEY_PAIR_KEY",
            "description": "Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)"
          },
          {
            "name": "SNOWFLAKE_PAT",
            "description": "Snowflake Programmatic Access Token (alternative to key pair)",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_KEY_PAIR_PASS",
            "description": "Passphrase for encrypted keys",
            "isSecret": true
          },
          {
            "name": "SNOWFLAKE_WAREHOUSE",
            "description": "Snowflake compute warehouse (required for run tools)"
          },
          {
            "name": "SNOWFLAKE_ROLE",
            "description": "Snowflake user role (required for run tools)"
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.Coalesce-Software-Inc/coalesce-transform",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.Coalesce-Software-Inc%2Fcoalesce-transform/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}