mcpField
C
coalesce-transform

coalesce-transform

ローカル
github.com/Coalesce-Software-Incデータベース
リポジトリ

coalesce-transform について

Coalesce Transform のワークスペース、ノード、パイプライン、実行を管理するための MCP サーバー。

設定

ローカルサーバーの設定はどのクライアントでも共通です。コピーしてクライアントの MCP 設定ファイルに貼り付けてください。

mcp.json · 共通設定
{
  "mcpServers": {
    "coalesce-software-inc-coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<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_INLINE_RESPONSES": "<COALESCE_MCP_INLINE_RESPONSES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_REQUEST_TIMEOUT_MS": "<COALESCE_MCP_REQUEST_TIMEOUT_MS>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
        "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS": "<COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS>",
        "COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
        "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": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
      }
    }
  }
}
起動コマンドnpx -y coalesce-transform-mcp
設定が必要な環境変数
COALESCE_ACCESS_TOKENシークレットBearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.
COALESCE_PROFILESelects which `~/.coa/config` profile to load. Defaults to default.
COALESCE_BASE_URLRegion-specific base URL. Defaults to https://app.coalescesoftware.io (US).
COALESCE_ORG_IDFallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.
COALESCE_REPO_PATHLocal repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.
COALESCE_CACHE_DIRBase 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_BYTESJSON size threshold before auto-caching to disk. Defaults to 32768.
COALESCE_MCP_INLINE_RESPONSESForces large responses inline as text instead of auto-caching them to disk and returning a `resource_link` (and suppresses per-field cache resource links). The server already auto-enables this for clients known not to support MCP resources (e.g. Snowflake Cortex), which otherwise render the link as unreadable "binary data" and retry in a loop. Set `true` to force it on for an unrecognised client, or `false` to disable auto-detection. Leave unset for Claude/Cursor to keep large payloads out of context. Defaults to false (auto-enabled for resource-less clients).
COALESCE_MCP_LINEAGE_TTL_MSIn-memory lineage cache TTL in milliseconds. Defaults to 1800000.
COALESCE_MCP_MAX_REQUEST_BODY_BYTESMax outbound API request body size. Defaults to 524288.
COALESCE_MCP_REQUEST_TIMEOUT_MSDefault 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_MSPer-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000.
COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MSDeadline for the best-effort workspace-adoption node-type ranking lookup inside node creation. Advisory only — creation proceeds without a ranking suggestion if this trips. Defaults to 15000.
COALESCE_MCP_INVENTORY_CACHE_TTL_MSIn-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_INDEX_CACHE_TTL_MSIn-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_MSIn-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_ONLYWhen `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_DIRDirectory 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_ACCOUNTSnowflake 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_USERNAMESnowflake 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_WAREHOUSESnowflake compute warehouse (required for run tools)
SNOWFLAKE_ROLESnowflake user role (required for run tools)

ローカルサーバーにはマシン上の実行環境（Node.js 18 以上など）が必要です。設定ファイルの場所はクライアントごとに異なります。

パッケージ
npmcoalesce-transform-mcp0.10.1

ツール

ツール一覧はまだ取得されていません

ローカルサーバーのツールはマシン上で起動して初めて取得できます。メンテナーはまだツール一覧を提供していません。

詳細

メンテナーはまだ詳細を追加していません。リポジトリの README をご覧ください。

コメント

Markdown 対応

MCP は初めてですか？

プロトコルの概要から最初のサーバーの導入まで、よくある疑問にまとめて答えます。

AI アプリケーションが外部のツールやデータソースに統一的な方法で接続するためのオープンなプロトコルです。クライアントはモデルとの対話を担い、MCP サーバーはツール・リソース・プロンプトテンプレートを提供します。標準メッセージでやり取りするため、1 つのサーバーを複数のクライアントで再利用できます。