Clickhouse MCP tools

Use this reference to find a tool and its inputs. Connect an MCP client before calling tools. Tool visibility depends on discovery and permissions.

For actions that send messages, spend credits, delete data, or start execution, review the intended records and confirm the action before proceeding. Obtain IDs from a prior result; do not invent them. A registered tool does not guarantee that its supporting service is available in every organization.

g8_clickhouse_mashup

Bulk enrichment lookup against the ClickHouse Cloud mashup tables. Use when you already have a PK (UP_ID from g8_opensearch_resolve_ids, a HEM from a visitor row, or a company domain) and want the canonical enrichment record. For free-form attribute search prefer g8_opensearch_search. Args: mode: “by_upid” (PK lookup), “by_hem” (resolves HEM then joins the profile), or “by_domain” (filter on company domain; b2b / joined only). values: Up to 100 input keys. Empty list is rejected (a PK filter is required). profile: “b2b” (default, work emails + LinkedIn), “b2c” (consumer), or “joined” (denormalized). limit: Max rows (server-capped at 1000).

Inputs

Input	Required	Type	Description
mode	Yes	string	See the schema below for constraints and defaults.
values	Yes	array	See the schema below for constraints and defaults.
profile	No	string	See the schema below for constraints and defaults.
limit	No	integer	See the schema below for constraints and defaults.

Complete input schema

{
  "properties": {
    "mode": {
      "title": "Mode",
      "type": "string"
    },
    "values": {
      "items": {
        "type": "string"
      },
      "title": "Values",
      "type": "array"
    },
    "profile": {
      "default": "b2b",
      "title": "Profile",
      "type": "string"
    },
    "limit": {
      "default": 1000,
      "title": "Limit",
      "type": "integer"
    }
  },
  "required": [
    "mode",
    "values"
  ],
  "title": "g8_clickhouse_mashupArguments",
  "type": "object"
}

g8_clickhouse_org_analytics

Per-org visitor + intent analytics: who visited the site, which companies, which keywords resolved. Scoped to your authenticated org; you CANNOT query another tenant. Args: dataset: One of “people_visitors” (resolved-person visits), “company_visitors” (resolved-company visits), “5x5_visitors” (mashup-resolved visits keyed by HEM), or “intent_resolved” (intent keyword resolutions). since: ISO date or datetime - inclusive lower bound. until: ISO date or datetime - exclusive upper bound (defaults to now). Window is hard-capped at 90 days. filters: Optional column equality filters. Unknown columns are dropped server-side. Examples: {“contact_id”: 12345}, {“keyword_id”: [“k1”, “k2”]}. aggregation: “raw” (matching rows, default), “daily_counts” (count per day), or “top_n” (count per the dataset’s primary group key, descending). limit: Max rows (server-capped at 1000).

Inputs

Input	Required	Type	Description
dataset	Yes	string	See the schema below for constraints and defaults.
since	Yes	string	See the schema below for constraints and defaults.
until	No	string / null	See the schema below for constraints and defaults.
filters	No	object / null	See the schema below for constraints and defaults.
aggregation	No	string	See the schema below for constraints and defaults.
limit	No	integer	See the schema below for constraints and defaults.

Complete input schema

{
  "properties": {
    "dataset": {
      "title": "Dataset",
      "type": "string"
    },
    "since": {
      "title": "Since",
      "type": "string"
    },
    "until": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Until"
    },
    "filters": {
      "anyOf": [
        {
          "additionalProperties": true,
          "type": "object"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Filters"
    },
    "aggregation": {
      "default": "raw",
      "title": "Aggregation",
      "type": "string"
    },
    "limit": {
      "default": 100,
      "title": "Limit",
      "type": "integer"
    }
  },
  "required": [
    "dataset",
    "since"
  ],
  "title": "g8_clickhouse_org_analyticsArguments",
  "type": "object"
}