what-can-i-click.moriatz.com
An explorable ClickHouse architecture advisor taught through living, interactive MergeTree analogies.
First seen 2026-11-05 · Last seen 2026-11-05 · Source: webmcp.com
Answer 2 · Act 5 · Transact 0 · Score: Not yet scored
Tool inspector
recommend_clickhouse_architecture
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.
Input schema
No input properties (empty object).
Raw JSON schema
{
"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
}
]
}
Similar websites
morphus.myles4miles.chatgpt.site
Morphus is an AI-native workspace for designing worlds and generating playable game experiences.
damnpdfs.com
Install the DamnPDFs Codex plugin, pair a browser workspace and use PDF, image and file tools from your coding agent. Includes setup and privacy limits.
insignifi4nt.github.io
broCAD/M: local-first CAD and CAM for parametric design, wire EDM planning, simulation and controller export.
cabinet.varera.studio
The Cartographer's Cabinet