Menu
Load when writing or debugging ClickHouse SQL, including backtick identifiers, ClickHouse casts, date bucket functions, string matching, aggregate functions, and engine-specific limitations.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Load when building, editing, or debugging Mako React apps — app files, npm dependencies, data bindings, the @mako/app-sdk hooks (useQuery / useDuckDB / useLocation / useSearchParams / navigate), URL state and shareable deep links, materialized Parquet/DuckDB bindings, and the live preview runtime.
Load for dbt branches, commits, pushes, pull requests, merges, repository sync, or branch cleanup.
Load when creating, editing, scheduling, running, or debugging dbt jobs and production deployments.
Load when building, editing, running, or debugging dbt models, dbt projects, schema.yml tests, sources, seeds, snapshots, incremental models, materializations, or dbt jobs in the Transforms section.
Load when creating, editing, configuring, validating, or debugging database sync flows, connector flows, pagination, incremental sync, destination mappings, and flow form fields.
Add a new MCP server preset (connector) to Mako's MCP client system — server URL, auth model (OAuth DCR, pre-registered app, or API key), scopes, icon, tests, and docs. Use when connecting a new external MCP server (like Slack or Close CRM) or changing how MCP connections authenticate.
| name | dialect-clickhouse |
| description | Load when writing or debugging ClickHouse SQL, including backtick identifiers, ClickHouse casts, date bucket functions, string matching, aggregate functions, and engine-specific limitations. |
| entities | ["clickhouse","sql","toStartOfMonth","formatDateTime","countIf","sumIf"] |
Use this skill for ClickHouse connections.
| Feature | ClickHouse syntax | Notes |
|---|---|---|
| Identifiers | `column` | Backticks are safest for reserved or mixed-case names. |
| Type casts | toUInt32(x), toString(x), CAST(x, 'Type') | Prefer typed conversion functions when clear. |
| String concat | concat(a, b) | Not PostgreSQL ` |
| Pattern match | LIKE, match(value, 'regex') | match uses RE2-style regex. |
| Date bucket | toStartOfHour(ts), toStartOfDay(ts), toStartOfMonth(ts) | Use these instead of date_trunc. |
| Date format | formatDateTime(ts, '%Y-%m') | Similar strftime-style tokens. |
| Conditional aggregate | countIf(condition), sumIf(value, condition) | Prefer native combinators for concise analytics. |
Some older ClickHouse versions have limited window function support. If a window query fails, rewrite with grouped subqueries or array functions.
SELECT
toStartOfMonth(created_at) AS month,
status,
count() AS order_count,
sum(total_amount) AS revenue
FROM `orders`
WHERE created_at >= now() - INTERVAL 6 MONTH
GROUP BY month, status
ORDER BY month, status
LIMIT 500;