Tool tree
An explorable ClickHouse architecture advisor taught through living, interactive MergeTree analogies.
Implementation
gradeNot graded
gradeNot graded
describe_clickhouse_worldAnswer
Start the requirements questionnaire: discover accepted answers, current questionnaire context, relevant research, and compact recommendations. Ask only missing questions; never invent a table or start an animation for a use-case assessment.
View tool JSON
{
"name": "describe_clickhouse_world",
"kind": "answer",
"impl": "imperative",
"description": "Start the requirements questionnaire: discover accepted answers, current questionnaire context, relevant research, and compact recommendations. Ask only missing questions; never invent a table or start an animation for a use-case assessment.",
"inputSchema": {
"type": "object",
"additionalProperties": false
}
}recommend_clickhouse_architectureAction
Submit assessment with the user’s known questionnaire answers to open compact, evidence-backed recommendations. Humans and agents use the same questionnaire logic. Ask for missing semantics, never invent a table or launch an animation. Legacy workload inputs and explicitly requested schema proposals remain compatible but are not the questionnaire flow.
View tool JSON
{
"name": "recommend_clickhouse_architecture",
"kind": "act",
"impl": "imperative",
"description": "Submit assessment with the user’s known questionnaire answers to open compact, evidence-backed recommendations. Humans and agents use the same questionnaire logic. Ask for missing semantics, never invent a table or launch an animation. Legacy workload inputs and explicitly requested schema proposals remain compatible but are not the questionnaire flow.",
"inputSchema": {
"anyOf": [
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"workload": {
"type": "string",
"enum": [
"observability",
"product-analytics",
"cdc",
"iot",
"financial",
"general"
]
},
"ingestRate": {
"type": "string",
"enum": [
"low",
"medium",
"high",
"extreme"
]
},
"latencyTarget": {
"type": "string",
"enum": [
"interactive",
"seconds",
"minutes",
"batch"
]
},
"retention": {
"type": "string",
"enum": [
"days",
"months",
"years"
]
},
"updates": {
"type": "string",
"enum": [
"append-only",
"occasional",
"frequent"
]
},
"availability": {
"type": "string",
"enum": [
"standard",
"high"
]
},
"topology": {
"type": "string",
"enum": [
"single-region",
"multi-region"
]
},
"costPriority": {
"type": "string",
"enum": [
"performance",
"balanced",
"cost"
]
},
"accelerationGoal": {
"type": "string",
"enum": [
"repeated-aggregation",
"transform-or-route",
"alternate-order",
"transparent-acceleration",
"none"
]
},
"deployment": {
"type": "string",
"enum": [
"cloud",
"self-managed",
"undecided"
]
},
"insertPattern": {
"type": "string",
"enum": [
"batched",
"many-small",
"mixed",
"unknown"
]
},
"queryShape": {
"type": "string",
"enum": [
"range-filter",
"high-cardinality-aggregate",
"point-lookup",
"join-heavy",
"mixed"
]
},
"partitionCardinality": {
"type": "string",
"enum": [
"low",
"medium",
"high",
"unknown"
]
},
"materializedViewFootprint": {
"type": "string",
"enum": [
"none",
"few",
"many",
"unknown"
]
}
},
"required": [
"workload",
"ingestRate",
"latencyTarget",
"retention",
"updates",
"availability",
"topology",
"costPriority"
],
"additionalProperties": false
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"tableProposal": {
"type": "object",
"properties": {
"schemaVersion": {
"type": "string",
"const": "1.0"
},
"table": {
"type": "object",
"properties": {
"name": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
},
"columns": {
"minItems": 1,
"maxItems": 32,
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
},
"type": {
"type": "string",
"enum": [
"String",
"UInt64",
"UInt32",
"Int64",
"Int8",
"Float64",
"DateTime",
"Date",
"UUID",
"Boolean",
"AggregateState"
]
},
"nullable": {
"type": "boolean"
},
"aggregateFunction": {
"type": "string",
"enum": [
"sum",
"count",
"avg",
"min",
"max",
"uniqExact"
]
}
},
"required": [
"name",
"type",
"nullable"
],
"additionalProperties": false
}
},
"identity": {
"minItems": 1,
"maxItems": 4,
"type": "array",
"items": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
}
},
"existingEngine": {
"type": "string",
"enum": [
"merge",
"replacing",
"summing",
"aggregating",
"coalescing",
"collapsing",
"versioned-collapsing"
]
},
"existingOrderBy": {
"maxItems": 8,
"type": "array",
"items": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
}
}
},
"required": [
"name",
"columns",
"identity"
],
"additionalProperties": false
},
"semantics": {
"type": "object",
"properties": {
"incoming": {
"type": "string",
"enum": [
"events",
"full-versions",
"increments",
"aggregate-states",
"partial-updates",
"signed-changes"
]
},
"desired": {
"type": "string",
"enum": [
"all-events",
"latest-row",
"totals",
"finalized-aggregates",
"latest-non-null",
"net-state"
]
},
"arrival": {
"type": "string",
"enum": [
"ordered",
"out-of-order",
"unknown"
]
},
"versionGuarantee": {
"type": "string",
"enum": [
"strictly-increasing-per-identity",
"unknown"
]
},
"nullMeaning": {
"type": "string",
"enum": [
"unchanged",
"clear",
"unknown"
]
},
"cancellation": {
"type": "string",
"enum": [
"exact-pair",
"unknown"
]
},
"sortingKeyGuarantee": {
"description": "For a reconciling engine with a different ORDER BY: every logical identity must keep exactly one sorting-key tuple across changes, and different identities must never share it. This is a producer assumption, not something the site can verify.",
"type": "string",
"enum": [
"identity-equivalent",
"unknown"
]
}
},
"required": [
"incoming",
"desired",
"arrival"
],
"additionalProperties": false
},
"proposal": {
"type": "object",
"properties": {
"family": {
"type": "string",
"enum": [
"merge",
"replacing",
"summing",
"aggregating",
"coalescing",
"collapsing",
"versioned-collapsing"
]
},
"orderBy": {
"minItems": 1,
"maxItems": 8,
"type": "array",
"items": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
}
},
"parameters": {
"type": "object",
"properties": {
"versionColumn": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
},
"signColumn": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
},
"measureColumns": {
"minItems": 1,
"maxItems": 8,
"type": "array",
"items": {
"type": "string",
"pattern": "^(?!(?:__proto__|constructor|prototype)$)[A-Za-z_][A-Za-z0-9_]{0,47}$"
}
}
},
"additionalProperties": false
},
"readMethod": {
"type": "string",
"enum": [
"all-rows",
"final",
"argmax",
"sum",
"aggregate-merge",
"sign-aware"
]
}
},
"required": [
"family",
"orderBy",
"parameters",
"readMethod"
],
"additionalProperties": false
},
"explanation": {
"type": "object",
"properties": {
"requirement": {
"type": "string",
"minLength": 1,
"maxLength": 600
},
"rationale": {
"type": "string",
"minLength": 1,
"maxLength": 600
},
"assumptions": {
"maxItems": 6,
"type": "array",
"items": {
"type": "string",
"minLength": 1,
"maxLength": 600
}
},
"tradeoffs": {
"minItems": 1,
"maxItems": 6,
"type": "array",
"items": {
"type": "string",
"minLength": 1,
"maxLength": 600
}
},
"evidenceIds": {
"minItems": 1,
"maxItems": 8,
"type": "array",
"items": {
"type": "string",
"minLength": 1,
"maxLength": 80
}
}
},
"required": [
"requirement",
"rationale",
"assumptions",
"tradeoffs",
"evidenceIds"
],
"additionalProperties": false
},
"environment": {
"type": "object",
"properties": {
"clickhouseVersion": {
"type": "string",
"pattern": "^(?:unknown|\\d{2}\\.\\d{1,2}(?:\\.\\d{1,3})?)$"
},
"workload": {
"type": "object",
"properties": {
"workload": {
"type": "string",
"enum": [
"observability",
"product-analytics",
"cdc",
"iot",
"financial",
"general"
]
},
"ingestRate": {
"type": "string",
"enum": [
"low",
"medium",
"high",
"extreme"
]
},
"latencyTarget": {
"type": "string",
"enum": [
"interactive",
"seconds",
"minutes",
"batch"
]
},
"retention": {
"type": "string",
"enum": [
"days",
"months",
"years"
]
},
"updates": {
"type": "string",
"enum": [
"append-only",
"occasional",
"frequent"
]
},
"availability": {
"type": "string",
"enum": [
"standard",
"high"
]
},
"topology": {
"type": "string",
"enum": [
"single-region",
"multi-region"
]
},
"costPriority": {
"type": "string",
"enum": [
"performance",
"balanced",
"cost"
]
},
"accelerationGoal": {
"type": "string",
"enum": [
"repeated-aggregation",
"transform-or-route",
"alternate-order",
"transparent-acceleration",
"none"
]
},
"deployment": {
"type": "string",
"enum": [
"cloud",
"self-managed",
"undecided"
]
},
"insertPattern": {
"type": "string",
"enum": [
"batched",
"many-small",
"mixed",
"unknown"
]
},
"queryShape": {
"type": "string",
"enum": [
"range-filter",
"high-cardinality-aggregate",
"point-lookup",
"join-heavy",
"mixed"
]
},
"partitionCardinality": {
"type": "string",
"enum": [
"low",
"medium",
"high",
"unknown"
]
},
"materializedViewFootprint": {
"type": "string",
"enum": [
"none",
"few",
"many",
"unknown"
]
}
},
"required": [
"workload",
"ingestRate",
"latencyTarget",
"retention",
"updates",
"availability",
"topology",
"costPriority"
],
"additionalProperties": false
}
},
"additionalProperties": false
}
},
"required": [
"schemaVersion",
"table",
"semantics",
"proposal",
"explanation"
],
"additionalProperties": false
}
},
"required": [
"tableProposal"
],
"additionalProperties": false
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"assessment": {
"type": "object",
"properties": {
"schemaVersion": {
"type": "string",
"const": "1.0"
},
"answers": {
"type": "object",
"properties": {
"outcome": {
"type": "string",
"enum": [
"unknown",
"history",
"current",
"metrics",
"serving"
]
},
"data": {
"type": "string",
"enum": [
"unknown",
"events",
"full-versions",
"partial-updates",
"increments",
"aggregate-states"
]
},
"identity": {
"type": "string",
"enum": [
"unknown",
"stable",
"missing"
]
},
"versions": {
"type": "string",
"enum": [
"unknown",
"reliable",
"none"
]
},
"nulls": {
"type": "string",
"enum": [
"unknown",
"unchanged",
"clear",
"mixed"
]
},
"arrival": {
"type": "string",
"enum": [
"unknown",
"ordered",
"out-of-order"
]
},
"metrics": {
"type": "string",
"enum": [
"unknown",
"count-reach",
"additive",
"weighted"
]
},
"accuracy": {
"type": "string",
"enum": [
"unknown",
"exact",
"approximate"
]
},
"replay": {
"type": "string",
"enum": [
"unknown",
"possible",
"deduplicated",
"none"
]
},
"writes": {
"type": "string",
"enum": [
"unknown",
"batched",
"small",
"mixed"
]
},
"buffer": {
"type": "string",
"enum": [
"unknown",
"yes",
"no"
]
},
"volume": {
"type": "string",
"enum": [
"unknown",
"low",
"high",
"extreme"
]
},
"fanout": {
"type": "string",
"enum": [
"unknown",
"low",
"partitions",
"views",
"both"
]
},
"filters": {
"type": "string",
"enum": [
"unknown",
"key",
"range",
"json",
"broad"
]
},
"joins": {
"type": "string",
"enum": [
"unknown",
"none",
"small",
"large"
]
},
"freshness": {
"type": "string",
"enum": [
"unknown",
"live",
"seconds",
"batch"
]
},
"concurrency": {
"type": "string",
"enum": [
"unknown",
"low",
"high"
]
},
"retention": {
"type": "string",
"enum": [
"unknown",
"days",
"months",
"years"
]
},
"corrections": {
"type": "string",
"enum": [
"unknown",
"none",
"occasional",
"frequent"
]
},
"late": {
"type": "string",
"enum": [
"unknown",
"none",
"bounded",
"unbounded"
]
},
"deletion": {
"type": "string",
"enum": [
"unknown",
"ttl",
"targeted",
"none"
]
},
"deployment": {
"type": "string",
"enum": [
"unknown",
"cloud",
"self-managed",
"undecided"
]
},
"availability": {
"type": "string",
"enum": [
"unknown",
"standard",
"high"
]
},
"regions": {
"type": "string",
"enum": [
"unknown",
"single",
"multi"
]
},
"priority": {
"type": "string",
"enum": [
"unknown",
"performance",
"balanced",
"cost"
]
},
"version": {
"type": "string",
"enum": [
"unknown",
"26.3",
"other"
]
}
},
"additionalProperties": false
},
"requirement": {
"type": "string",
"minLength": 1,
"maxLength": 400
}
},
"required": [
"schemaVersion",
"answers"
],
"additionalProperties": false
}
},
"required": [
"assessment"
],
"additionalProperties": false
}
]
}
}play_architecture_storyAction
Navigate the questionnaire with assessmentView: card, review, or result. With no parameters, open the questionnaire or current recommendation—not an animation. Legacy scene identifiers are only for explicitly requested demonstrations outside the questionnaire.
View tool JSON
{
"name": "play_architecture_story",
"kind": "act",
"impl": "imperative",
"description": "Navigate the questionnaire with assessmentView: card, review, or result. With no parameters, open the questionnaire or current recommendation—not an animation. Legacy scene identifiers are only for explicitly requested demonstrations outside the questionnaire.",
"inputSchema": {
"anyOf": [
{
"type": "object",
"additionalProperties": false,
"properties": {
"implementationId": {
"enum": [
"cloudflare-http-analytics",
"netflix-logging",
"gitlab-product-analytics",
"polymarket-realtime-analytics",
"ly-kafka-observability",
"seemplicity-postgres-cdc",
"lago-usage-billing",
"emq-industrial-iot",
"critical-manufacturing-factory",
"constant-contact-realtime-marketing",
"rill-operational-bi",
"ramp-spend-analytics",
"replo-live-campaign-analytics",
"mercado-libre-o11y",
"open-electricity-energy",
"openai-observability",
"chartmetric-playlist-cache",
"reco-security-state",
"common-room-customer-intelligence",
"clickhouse-loghouse",
"tesla-comet-observability",
"qrt-research-risk",
"shopify-global-observability",
"highlevel-notifications-analytics",
"appcues-realtime-profiles",
"flock-safety-traffic-analytics",
"dash0-otel-observability",
"clever-observability-retention",
"uber-schema-agnostic-logging",
"cisco-talos-threat-reputation",
"modal-ai-runtime-observability",
"hud-runtime-telemetry-enrichment",
"openmeter-usage-billing-windows",
"cogent-agentic-vulnerability-analytics",
"docontrol-mcp-security-analytics",
"microsoft-clarity-web-analytics",
"lyft-batch-realtime-analytics",
"deshaw-high-cardinality-observability",
"visa-conversational-payments-analytics",
"sony-liv-streaming-analytics"
]
},
"gotchaId": {
"enum": [
"parts-pressure",
"scale-coordination",
"updates-deduplication",
"read-path-surprises",
"memory-pressure",
"materialized-view-traps"
]
}
}
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"tableScenarioId": {
"type": "string",
"minLength": 1,
"maxLength": 90
},
"stage": {
"type": "string",
"enum": [
"arrive",
"read-now",
"merge",
"read-again"
]
}
},
"required": [
"tableScenarioId"
],
"additionalProperties": false
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"assessmentView": {
"type": "string",
"enum": [
"card",
"review",
"result"
]
},
"cardId": {
"type": "string",
"enum": [
"outcome",
"data",
"identity",
"versions",
"nulls",
"arrival",
"metrics",
"accuracy",
"replay",
"writes",
"buffer",
"volume",
"fanout",
"filters",
"joins",
"freshness",
"concurrency",
"retention",
"corrections",
"late",
"deletion",
"deployment",
"availability",
"regions",
"priority",
"version"
]
}
},
"required": [
"assessmentView"
],
"additionalProperties": false
}
]
}
}inspect_clickhouse_mechanismAction
Use assessmentInspect to read a questionnaire card, answer, recommendation component, or explanation and its research. Legacy mechanism and table inspection are separate, explicitly requested capabilities—not the questionnaire path.
View tool JSON
{
"name": "inspect_clickhouse_mechanism",
"kind": "act",
"impl": "imperative",
"description": "Use assessmentInspect to read a questionnaire card, answer, recommendation component, or explanation and its research. Legacy mechanism and table inspection are separate, explicitly requested capabilities—not the questionnaire path.",
"inputSchema": {
"anyOf": [
{
"type": "object",
"additionalProperties": false,
"anyOf": [
{
"required": [
"mechanismId"
]
},
{
"required": [
"mergeFamilyId"
]
},
{
"required": [
"gotchaId"
]
}
],
"properties": {
"mechanismId": {
"enum": [
"ingestion.client-batching",
"ingestion.async-buffer",
"ingestion.clickpipes",
"ingestion.cdc",
"ingestion.backpressure",
"mergetree.part-anatomy",
"mergetree.partition-boundary",
"mergetree.merge-selection",
"mergetree.sorted-merge",
"mergetree.part-lifecycle",
"mergetree.parts-pressure",
"mergetree.forced-merge",
"read.ordering",
"read.sparse-index",
"read.granules",
"read.column-pruning",
"read.data-skipping",
"read.parallel-pipeline",
"read.saved-work",
"precompute.materialized-view",
"precompute.aggregate-states",
"precompute.projection",
"precompute.optimizer-choice",
"precompute.write-amplification",
"architecture.sharding",
"architecture.distributed-query",
"architecture.replication",
"architecture.keeper",
"architecture.failure",
"architecture.recovery",
"architecture.multi-region",
"retention.ttl-delete",
"retention.ttl-move",
"retention.ttl-recompress",
"retention.ttl-aggregate",
"retention.mutation",
"retention.backup",
"retention.restore",
"memory.os-page-cache",
"memory.mark-cache",
"memory.uncompressed-cache",
"memory.query-cache",
"memory.memory-tracker",
"memory.external-spill",
"execution.analyzer",
"execution.explain-plan",
"execution.join-strategy",
"execution.sort-aggregate",
"execution.processor-pipeline",
"execution.workload-scheduler",
"durability.part-commit",
"durability.async-ack",
"durability.insert-quorum",
"durability.replication-log",
"storage.disks-volumes",
"storage.storage-policy",
"storage.object-storage",
"storage.filesystem-cache",
"storage.compression-codecs",
"observability.query-log",
"observability.part-log",
"observability.merges",
"observability.replication-queue",
"observability.processes",
"observability.profile-events",
"ingestion.retry-deduplication",
"read.limit-short-circuit",
"precompute.refreshable-view",
"architecture.vertical-scaling",
"retention.patch-update"
]
},
"mergeFamilyId": {
"enum": [
"merge",
"replacing",
"coalescing",
"summing",
"aggregating",
"collapsing",
"versioned-collapsing"
]
},
"gotchaId": {
"enum": [
"parts-pressure",
"scale-coordination",
"updates-deduplication",
"read-path-surprises",
"memory-pressure",
"materialized-view-traps"
]
},
"beat": {
"enum": [
"cause",
"impact",
"avoid",
"verify"
]
},
"latestReadStrategy": {
"enum": [
"background",
"argmax",
"final"
]
},
"view": {
"enum": [
"mechanism",
"xray"
]
}
}
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"tableScenarioId": {
"type": "string",
"minLength": 1,
"maxLength": 90
},
"stage": {
"type": "string",
"enum": [
"arrive",
"read-now",
"merge",
"read-again"
]
},
"rowId": {
"type": "string",
"minLength": 1,
"maxLength": 40
},
"partId": {
"type": "string",
"enum": [
"part-a",
"part-b",
"part-c",
"part-d"
]
},
"columnId": {
"type": "string",
"minLength": 1,
"maxLength": 48
},
"membershipId": {
"type": "string",
"maxLength": 24,
"pattern": "^audience-\\d{1,12}$"
}
},
"required": [
"tableScenarioId"
],
"additionalProperties": false
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"assessmentInspect": {
"type": "string",
"enum": [
"card",
"answer",
"component",
"explanation"
]
},
"cardId": {
"type": "string",
"enum": [
"outcome",
"data",
"identity",
"versions",
"nulls",
"arrival",
"metrics",
"accuracy",
"replay",
"writes",
"buffer",
"volume",
"fanout",
"filters",
"joins",
"freshness",
"concurrency",
"retention",
"corrections",
"late",
"deletion",
"deployment",
"availability",
"regions",
"priority",
"version"
]
},
"componentId": {
"type": "string",
"enum": [
"ingestion",
"history",
"transform",
"storage",
"access",
"read",
"lifecycle",
"environment"
]
}
},
"required": [
"assessmentInspect"
],
"additionalProperties": false
}
]
}
}compare_clickhouse_methodsAction
Align two reviewed mechanisms, compare argMax with SELECT FINAL, compare incremental materialized views with projections, or open two reviewed production implementations side by side.
View tool JSON
{
"name": "compare_clickhouse_methods",
"kind": "act",
"impl": "imperative",
"description": "Align two reviewed mechanisms, compare argMax with SELECT FINAL, compare incremental materialized views with projections, or open two reviewed production implementations side by side.",
"inputSchema": {
"anyOf": [
{
"type": "object",
"additionalProperties": false,
"anyOf": [
{
"required": [
"firstId",
"secondId"
]
},
{
"required": [
"comparison"
]
},
{
"required": [
"firstImplementationId",
"secondImplementationId"
]
}
],
"properties": {
"firstId": {
"enum": [
"ingestion.client-batching",
"ingestion.async-buffer",
"ingestion.clickpipes",
"ingestion.cdc",
"ingestion.backpressure",
"mergetree.part-anatomy",
"mergetree.partition-boundary",
"mergetree.merge-selection",
"mergetree.sorted-merge",
"mergetree.part-lifecycle",
"mergetree.parts-pressure",
"mergetree.forced-merge",
"read.ordering",
"read.sparse-index",
"read.granules",
"read.column-pruning",
"read.data-skipping",
"read.parallel-pipeline",
"read.saved-work",
"precompute.materialized-view",
"precompute.aggregate-states",
"precompute.projection",
"precompute.optimizer-choice",
"precompute.write-amplification",
"architecture.sharding",
"architecture.distributed-query",
"architecture.replication",
"architecture.keeper",
"architecture.failure",
"architecture.recovery",
"architecture.multi-region",
"retention.ttl-delete",
"retention.ttl-move",
"retention.ttl-recompress",
"retention.ttl-aggregate",
"retention.mutation",
"retention.backup",
"retention.restore",
"memory.os-page-cache",
"memory.mark-cache",
"memory.uncompressed-cache",
"memory.query-cache",
"memory.memory-tracker",
"memory.external-spill",
"execution.analyzer",
"execution.explain-plan",
"execution.join-strategy",
"execution.sort-aggregate",
"execution.processor-pipeline",
"execution.workload-scheduler",
"durability.part-commit",
"durability.async-ack",
"durability.insert-quorum",
"durability.replication-log",
"storage.disks-volumes",
"storage.storage-policy",
"storage.object-storage",
"storage.filesystem-cache",
"storage.compression-codecs",
"observability.query-log",
"observability.part-log",
"observability.merges",
"observability.replication-queue",
"observability.processes",
"observability.profile-events",
"ingestion.retry-deduplication",
"read.limit-short-circuit",
"precompute.refreshable-view",
"architecture.vertical-scaling",
"retention.patch-update"
]
},
"secondId": {
"enum": [
"ingestion.client-batching",
"ingestion.async-buffer",
"ingestion.clickpipes",
"ingestion.cdc",
"ingestion.backpressure",
"mergetree.part-anatomy",
"mergetree.partition-boundary",
"mergetree.merge-selection",
"mergetree.sorted-merge",
"mergetree.part-lifecycle",
"mergetree.parts-pressure",
"mergetree.forced-merge",
"read.ordering",
"read.sparse-index",
"read.granules",
"read.column-pruning",
"read.data-skipping",
"read.parallel-pipeline",
"read.saved-work",
"precompute.materialized-view",
"precompute.aggregate-states",
"precompute.projection",
"precompute.optimizer-choice",
"precompute.write-amplification",
"architecture.sharding",
"architecture.distributed-query",
"architecture.replication",
"architecture.keeper",
"architecture.failure",
"architecture.recovery",
"architecture.multi-region",
"retention.ttl-delete",
"retention.ttl-move",
"retention.ttl-recompress",
"retention.ttl-aggregate",
"retention.mutation",
"retention.backup",
"retention.restore",
"memory.os-page-cache",
"memory.mark-cache",
"memory.uncompressed-cache",
"memory.query-cache",
"memory.memory-tracker",
"memory.external-spill",
"execution.analyzer",
"execution.explain-plan",
"execution.join-strategy",
"execution.sort-aggregate",
"execution.processor-pipeline",
"execution.workload-scheduler",
"durability.part-commit",
"durability.async-ack",
"durability.insert-quorum",
"durability.replication-log",
"storage.disks-volumes",
"storage.storage-policy",
"storage.object-storage",
"storage.filesystem-cache",
"storage.compression-codecs",
"observability.query-log",
"observability.part-log",
"observability.merges",
"observability.replication-queue",
"observability.processes",
"observability.profile-events",
"ingestion.retry-deduplication",
"read.limit-short-circuit",
"precompute.refreshable-view",
"architecture.vertical-scaling",
"retention.patch-update"
]
},
"comparison": {
"enum": [
"argmax-vs-final",
"materialized-view-vs-projection",
"vertical-vs-horizontal-scaling",
"classic-mutation-vs-patch-update",
"incremental-vs-refreshable-view"
]
},
"firstImplementationId": {
"enum": [
"cloudflare-http-analytics",
"netflix-logging",
"gitlab-product-analytics",
"polymarket-realtime-analytics",
"ly-kafka-observability",
"seemplicity-postgres-cdc",
"lago-usage-billing",
"emq-industrial-iot",
"critical-manufacturing-factory",
"constant-contact-realtime-marketing",
"rill-operational-bi",
"ramp-spend-analytics",
"replo-live-campaign-analytics",
"mercado-libre-o11y",
"open-electricity-energy",
"openai-observability",
"chartmetric-playlist-cache",
"reco-security-state",
"common-room-customer-intelligence",
"clickhouse-loghouse",
"tesla-comet-observability",
"qrt-research-risk",
"shopify-global-observability",
"highlevel-notifications-analytics",
"appcues-realtime-profiles",
"flock-safety-traffic-analytics",
"dash0-otel-observability",
"clever-observability-retention",
"uber-schema-agnostic-logging",
"cisco-talos-threat-reputation",
"modal-ai-runtime-observability",
"hud-runtime-telemetry-enrichment",
"openmeter-usage-billing-windows",
"cogent-agentic-vulnerability-analytics",
"docontrol-mcp-security-analytics",
"microsoft-clarity-web-analytics",
"lyft-batch-realtime-analytics",
"deshaw-high-cardinality-observability",
"visa-conversational-payments-analytics",
"sony-liv-streaming-analytics"
]
},
"secondImplementationId": {
"enum": [
"cloudflare-http-analytics",
"netflix-logging",
"gitlab-product-analytics",
"polymarket-realtime-analytics",
"ly-kafka-observability",
"seemplicity-postgres-cdc",
"lago-usage-billing",
"emq-industrial-iot",
"critical-manufacturing-factory",
"constant-contact-realtime-marketing",
"rill-operational-bi",
"ramp-spend-analytics",
"replo-live-campaign-analytics",
"mercado-libre-o11y",
"open-electricity-energy",
"openai-observability",
"chartmetric-playlist-cache",
"reco-security-state",
"common-room-customer-intelligence",
"clickhouse-loghouse",
"tesla-comet-observability",
"qrt-research-risk",
"shopify-global-observability",
"highlevel-notifications-analytics",
"appcues-realtime-profiles",
"flock-safety-traffic-analytics",
"dash0-otel-observability",
"clever-observability-retention",
"uber-schema-agnostic-logging",
"cisco-talos-threat-reputation",
"modal-ai-runtime-observability",
"hud-runtime-telemetry-enrichment",
"openmeter-usage-billing-windows",
"cogent-agentic-vulnerability-analytics",
"docontrol-mcp-security-analytics",
"microsoft-clarity-web-analytics",
"lyft-batch-realtime-analytics",
"deshaw-high-cardinality-observability",
"visa-conversational-payments-analytics",
"sony-liv-streaming-analytics"
]
}
}
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"assessmentAlternative": {
"type": "string",
"enum": [
"primary-alternative",
"derived-refresh",
"capacity",
"current-read"
]
}
},
"required": [
"assessmentAlternative"
],
"additionalProperties": false
}
]
}
}search_clickhouse_evidenceAnswer
Browse every admitted source with catalog:true and bounded offset/limit. Search official guidance and field cases with query; retrieve up to five caseIds, including engine evidence IDs. Accounts include conditions, tradeoffs, uncertainties and contrasts.
View tool JSON
{
"name": "search_clickhouse_evidence",
"kind": "answer",
"impl": "imperative",
"description": "Browse every admitted source with catalog:true and bounded offset/limit. Search official guidance and field cases with query; retrieve up to five caseIds, including engine evidence IDs. Accounts include conditions, tradeoffs, uncertainties and contrasts.",
"inputSchema": {
"anyOf": [
{
"type": "object",
"additionalProperties": false,
"required": [
"query"
],
"properties": {
"query": {
"type": "string",
"minLength": 2,
"maxLength": 80
}
}
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"caseIds": {
"minItems": 1,
"maxItems": 5,
"type": "array",
"items": {
"type": "string",
"minLength": 1,
"maxLength": 80
}
}
},
"required": [
"caseIds"
],
"additionalProperties": false
},
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"catalog": {
"type": "boolean",
"const": true
},
"offset": {
"default": 0,
"type": "integer",
"minimum": 0,
"maximum": 10000
},
"limit": {
"default": 25,
"type": "integer",
"minimum": 1,
"maximum": 50
}
},
"required": [
"catalog"
],
"additionalProperties": false
}
]
}
}reset_clickhouse_worldAction
Stop the story, clear recommendations and comparisons, and return the camera, scenario, and inspector to system view.
View tool JSON
{
"name": "reset_clickhouse_world",
"kind": "act",
"impl": "imperative",
"description": "Stop the story, clear recommendations and comparisons, and return the camera, scenario, and inspector to system view.",
"inputSchema": {
"type": "object",
"additionalProperties": false
}
}