Clickhouse Local Dev Loop

What it does

When your agent uses it

• Setting up a local ClickHouse dev environment
• Writing integration tests against ClickHouse
• Running ClickHouse in Docker Compose for local work
• With clickhouse local dev

Example prompts

• “clickhouse local dev”
• “clickhouse docker”
• “clickhouse dev environment”
• “/clickhouse-local-dev-loop”

Requirements

• Node.js
• Docker
• Compatibility (from SKILL.md): Designed for Claude Code
• Pre-approved tools (allowed-tools): Read, Write, Edit, Bash(docker:*), Bash(docker-compose:*)

Workflow steps

7 steps, taken from the first numbered list in SKILL.md.

1. 1Docker Compose setup — Write a docker-compose.yml exposing 8123
2. 2Init script — Write init-db/001-schema.sql with your
3. 3Seed data — Write scripts/seed.ts that batch-inserts synthetic rows via
4. 4Project structure — lay out init-db/, scripts/, src/, tests/, and
5. 5Client singleton — Write src/db.ts exposing a memoized getClient()
6. 6Integration testing — Write a vitest tests/setup.ts that TRUNCATEs
7. 7Package scripts — Edit package.json to add db:up, db:down,

What it can do on your machine

Read from SKILL.md and the folder at commit 80f86df. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Read
  • Write
  • Edit
  • Bash(docker:*)
  • Bash(docker-compose:*)

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • docker
  • curl
  • npm

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Links to these hosts (documentation or services it may open):

  • hub.docker.com
  • clickhouse.com
  • vitest.dev

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names these keys or tokens, usually read from environment variables:

  • CLICKHOUSE_PASSWORD

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

• Compatibility

  Designed for Claude Code

  From compatibility in the SKILL.md frontmatter.

Context cost

Clickhouse Local Dev Loop loads about 1.5k tokens when it runs, and up to ~3.3k if it reads all its reference files. Until then it costs about 101 tokens; SKILL.md has 541 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~101

When it runs · the whole SKILL.md, loaded when a task matches

~1.5k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~3.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

• NoteMentions a .env fileSKILL.md:46

  git-ignored `.env.local`; commit only a `.env.example`. Never reuse

• NoteMentions a .env fileSKILL.md:83

  the `.env.local` / `.env.example` pair.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit 80f86df, republished under its MIT licence (© jeremylongshore). 541 words, ~1,529 tokens.

name

clickhouse-local-dev-loop

description

Run ClickHouse locally with Docker, configure test fixtures, and iterate fast. Use when setting up a local ClickHouse dev environment, writing integration tests against ClickHouse, or running ClickHouse in Docker Compose for local work. Trigger with "clickhouse local dev", "clickhouse docker", "clickhouse dev environment", "run clickhouse locally", "clickhouse docker compose".

allowed-tools

Read, Write, Edit, Bash(docker:*), Bash(docker-compose:*)

compatibility

Designed for Claude Code

version

1.7.0

license

MIT

author

Jeremy Longshore <jeremy@intentsolutions.io>

tags

saas, database, analytics, clickhouse, olap

docker compose up -d
curl http://localhost:8123/ping                 # → "Ok.\n"
npm run db:seed                                   # seeds 1000 events
curl 'http://localhost:8123/?query=SELECT+count()+FROM+app.events'   # → 1000

docker exec -it <container> clickhouse-client --password dev_password

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 2 other files (references) in skills/.curated/clickhouse-local-dev-loop of jeremylongshore/tons-of-skills-marketplace.

• SKILL.md
• references/examples.md
• references/implementation.md

Open the folder on GitHubat commit 80f86df