Clickhouse Install Auth

What it does

When your agent uses it

• Setting up a new ClickHouse project
• Configuring connection strings
• Initializing the official Node.js
• With install clickhouse

Example prompts

• “install clickhouse”
• “setup clickhouse client”
• “clickhouse auth”
• “/clickhouse-install-auth”

Requirements

• Python 3
• Node.js
• Compatibility (from SKILL.md): Designed for Claude Code
• Pre-approved tools (allowed-tools): Read, Write, Bash(npm:*), Bash(pnpm:*), Bash(pip:*)

Workflow steps

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

1. 1Install the official client. Node.js uses the HTTP-based
2. 2Configure environment variables. Put host, user, and password in .env
3. 3Create the client. Pass url, username, and password to
4. 4Verify the connection with client.ping() plus a SELECT version()
5. 5Python alternative — same shape via clickhouse_connect.get_client(...)

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. 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
  • Bash(npm:*)
  • Bash(pnpm:*)
  • Bash(pip:*)

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • npm
  • pip

  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):

  • clickhouse.com

  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 Install Auth loads about 1.2k tokens when it runs, and up to ~2.1k if it reads all its reference files. Until then it costs about 95 tokens; SKILL.md has 394 words of instructions outside code blocks.

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

~95

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

~1.2k

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

~2.1k

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:38

  ead the current project for an existing `.env` before

• NoteMentions a .env fileSKILL.md:39

  writing one; write credentials to `.env` (never commit it).

• NoteMentions a .env fileSKILL.md:49

  bles.** Put host, user, and password in `.env`

• NoteMentions a .env fileSKILL.md:82

  - A `.env` holding `CLICKHOUSE_HOST` / `CLICKHOUSE_USER` / `CLICKHOUSE_PASSWORD`

• NoteMentions a .env fileSKILL.md:101

  t to ClickHouse Cloud (Node.js).** With `.env` populated, create the

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 cfae287, republished under its MIT licence (© jeremylongshore). 394 words, ~1,237 tokens.

name

clickhouse-install-auth

description

Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted. Use when setting up a new ClickHouse project, configuring connection strings, or initializing the official Node.js or Python client. Trigger with "install clickhouse", "setup clickhouse client", "clickhouse auth", "connect to clickhouse", "clickhouse credentials".

allowed-tools

Read, Write, Bash(npm:*), Bash(pnpm:*), Bash(pip:*)

compatibility

Designed for Claude Code

version

1.7.0

license

MIT

author

Jeremy Longshore <jeremy@intentsolutions.io>

tags

saas, database, analytics, clickhouse, olap

const alive = await client.ping();        // { success: true }
const rs = await client.query({
  query: 'SELECT version() AS ver',
  format: 'JSONEachRow',
});
console.log((await rs.json())[0].ver);    // e.g. "24.8.1"

const localClient = createClient({
  url: 'http://localhost:8123',
  username: 'default',
  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-install-auth of jeremylongshore/tons-of-skills-marketplace.

• SKILL.md
• references/connection-reference.md
• references/implementation.md

Open the folder on GitHubat commit cfae287