clickhouse-best-practices

clickhouse-best-practices18 wordsInspect firstinspect-then-install

Curated third-party skill source. Run external-skill-auditor before repo promotion.

Quick Start

Install:

npx skills add clickhouse/agent-skills --skill clickhouse-best-practices --skill clickhouse-architecture-advisor -y -g -a antigravity claude-code codex crush cursor gemini-cli github-copilot grok opencode

Use: /clickhouse-best-practices

Works with Claude Code, Gemini CLI, OpenCode, and other agentskills.io-compatible agents.

Curated external (hand-maintained)

Composed compose-external-wave-2 using authoring SSOT (docs/src/authoring/skills/clickhouse-best-practices.mdx) + research. Do not run wagents docs generate on this file (HAND-MAINTAINED sentinel). Run external-skill-auditor before using in production or promoting.

What It Does

clickhouse-best-practices encodes 31 prioritized rules (schema PK ordering, data types, JOIN algorithms, insert batching, mutation avoidance, partitioning, skipping indices, agent discovery/safety) that must be checked and cited before giving ClickHouse recommendations. Requires following a strict connect-discover-plan-execute-recover workflow and rule-file consultation order.

Harness Coverage

Targets verified harnesses: antigravity, claude-code, codex, crush, cursor, gemini-cli, github-copilot, grok, opencode.

Portable multi-harness install command:

npx skills add clickhouse/agent-skills --skill clickhouse-best-practices --skill clickhouse-architecture-advisor -y -g -a antigravity claude-code codex crush cursor gemini-cli github-copilot grok opencode

Trust / Audit

Trust tier: Inspect first (needs-inspection)

Curated status: inspect-then-install

Risk notes: Curated third-party skill source. Run external-skill-auditor before repo promotion.

Entry maintained via authoring + research for compose-external-wave-2; provenance and audit notes are authoritative there (research context is advisory).

Install Prerequisites

Same install command as the architecture advisor skill. Requires prior audit of the agent-skills source.

Public Metadata

Field	Value
Source Type	curated-external
Display Source	clickhouse/agent-skills
Source Kind	github
Installability	portable command
Review State	curated
Trust Tier	needs-inspection
Target Agents	antigravity, claude-code, codex, crush, cursor, gemini-cli, github-copilot, grok, opencode

General

Field	Value
Name	clickhouse-best-practices

Curated catalog entry

docs/src/authoring/skills/clickhouse-best-practices.mdx (full SSOT excerpt)

---
name: "clickhouse-best-practices"
description: "Curated third-party skill source. Run external-skill-auditor before repo promotion."
title: "Clickhouse Best Practices"
source_kind: "curated-external"
source: "clickhouse/agent-skills"
install_source: "clickhouse/agent-skills"
status: "inspect-then-install"
trust_tier: "needs-inspection"
provenance_status: "verified-install-command"
install_command: "npx skills add clickhouse/agent-skills --skill clickhouse-best-practices --skill clickhouse-architecture-advisor -y -g -a antigravity claude-code codex crush cursor gemini-cli github-copilot grok opencode"
target_agents: [antigravity, claude-code, codex, crush, cursor, gemini-cli, github-copilot, grok, opencode]
source_url: "https://github.com/clickhouse/agent-skills"
notes: "Curated third-party skill source. Run external-skill-auditor before repo promotion."
risk_notes: "Curated third-party skill source. Run external-skill-auditor before repo promotion."
promotion_policy: "Inspect source, hooks, scripts, credentials, and dedupe before install."
provenance_evidence: "Curated `npx skills add` command with named `--skill` selectors under `inspect-then-install` in config/external-skills.md."
---

{/* GENERATED-AUTHORING: source=config/external-skills.md; entry=clickhouse-best-practices; re-run migration to refresh */}

Curated third-party skill source. Run external-skill-auditor before repo promotion.

Install / provenance (from authoring frontmatter + research):

Field	Value
install_command	npx skills add clickhouse/agent-skills --skill clickhouse-best-practices --skill clickhouse-architecture-advisor -y -g -a antigravity claude-code codex crush cursor gemini-cli github-copilot grok opencode
source	clickhouse/agent-skills
source_url	https://github.com/clickhouse/agent-skills
trust_tier	needs-inspection
curated_status	inspect-then-install
target_agents	antigravity, claude-code, codex, crush, cursor, gemini-cli, github-copilot, grok, opencode

Resources

Skill Catalog Browse custom and external skills.

CLI Reference Install and manage skills.