How to write idiomatic, readable, performant research SQL in ClickHouse — especially when crossing into PostgreSQL via the postgresql() table function. This skill is about the SQL you write to investigate, not about table design.
Clickhouse Query Best Practices is a community-contributed Claude Code skill in the research-methods sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/clickhouse-query-best-practices/ and loads when your prompt matches the skill's trigger.
When to invoke it: Use when writing or reviewing ad-hoc research SQL in a dbt-ClickHouse project, or running federated queries via `postgresql()` from ClickHouse for data-quality investigations — covers CTE-wrapping of federation, dedup via `limit 1 by`, flow analysis with `groupUniqArray + arraySort`, runtime-computed boundary dates, hybrid PG/CH source selection, source-of-truth citation, and style.
The Clickhouse Query Best Practices Claude Code skill is built for researchers, data scientists, academics, and analysts working with complex data and scientific literature. It's part of ClaudSkills (also referred to as Claude Skills or Claude Code Skills) — the open community-curated registry of 156,000+ SKILL.md files for Anthropic's Claude Code agent and the wider Claude ecosystem (Claude API, Claude Agent SDK).
mkdir -p ~/.claude/skills/clickhouse-query-best-practices curl -L https://claudskills.com/skills/clickhouse-query-best-practices/SKILL.md \ -o ~/.claude/skills/clickhouse-query-best-practices/SKILL.md
Or just download SKILL.md directly and drop it into ~/.claude/skills/clickhouse-query-best-practices/. Claude Code auto-discovers it on next session.
Skills live at ~/.claude/skills/clickhouse-query-best-practices/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\clickhouse-query-best-practices\SKILL.md on Windows. See the full install guide for step-by-step instructions.
Open @claudskills_bot on Telegram, tap Open Desktop App, and the desktop app installs this skill for you. Or share the bot link with a colleague — they get the same one-tap install. Learn more →
The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.
For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.
SKILL.md from the source repository to ~/.claude/skills/clickhouse-query-best-practices/SKILL.md and restart Claude Code. Both flows are detailed at claudskills.com/install/.SKILL.md file that lives under ~/.claude/skills/<name>/ and tells the Claude Code CLI agent how to perform a specific task (instructions, prompts, allowed tools). Skills are auto-discovered at session start. Clickhouse Query Best Practices is one of 67,000+ skills indexed in the open ClaudSkills catalog, classified under the Science & Research category. Learn more at /learn/what-is-a-claude-skill/.If you reference this skill in a blog post, paper, or documentation, you can cite it as:
@misc{clickhouse-query-best-practices-2026,
author = {bim-ba},
title = {Clickhouse Query Best Practices [Claude Code skill]},
year = {2026},
publisher = {ClaudSkills},
url = {https://claudskills.com/skills/clickhouse-query-best-practices/}
}Grade A · scanned 2026-07-21 — free static scan against the OWASP Agentic Skills Top 10.
No risk patterns were found in any of the ten OWASP-aligned categories. How grading works ›
Browse all Science & Research skills in the ClaudSkills registry, or explore these other picks from the same category:
Part of Acreator Store — Adam Lankamer's AI tools: PerfectStudio · Ucaption · UTagger · AutoXPoster · TestYourSkills · AutomationFlows · Au Naturel · Telegram @acreatorstore
SKILL.md files, not affiliated with, endorsed by, or sponsored by Anthropic.