Agent skill · software engineering · jeremylongshore
clickhouse-install-auth
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".
Why this skill is useful
Adds specific installation and configuration steps for ClickHouse clients that the AI wouldn't reliably generate on its own.
What it needs
Requires npm, pip installed locally. About 2k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.
What this skill does
ClickHouse Install & Auth Overview Set up the official ClickHouse client for Node.js or Python and configure authentication to ClickHouse Cloud or a self-hosted instance. The workflow below is the high-level path; each step links to a full walkthrough with complete code in references/implementation.md. Prerequisites Node.js 18+ or Python 3.8+ A running ClickHouse instance (Cloud or self-hosted) Connection credentials (host, port, user, password) Instructions Follow these five steps. Read the current project for an existing .env before writing one; write credentials to .env (never commit it). 1. Install the official client. Node.js uses the HTTP-based @clickhouse/client; Python uses clickhouse-connect. 2. Configure environment variables. Put host, user, and password in .env and add it to .gitignore. Cloud hosts use port 8443 (HTTPS); self-hosted uses 8123 (HTTP). 3. Create the client. Pass url, username, and password to createClient() (Node.js) or getclient() (Python). Cloud requires TLS — supply an https:// URL and the client handles it. 4. Verify the connection with client.ping() plus a SELECT version() probe. 5. Python alternative — same shape via clickhouseconnect.getclient(...) with secure=True for Cloud. Full code for every step (Cloud + self-hosted variants, the verify routine, and the Python client): references/implementation.md. Every createClient() option and a Cloud-vs-self-hosted comparison: references/connection-reference.md. Output After completing the workflow you have: The official client installed (@clickhouse/client or clickhouse-connect). A .env holding CLICKHOUSEHOST / CLICKHOUSEUSER / CLICKHOUSEPASSWORD (gitignored). An initialized client module that reads those variables. A successful ping() returning success: true and a SELECT version() probe printing the server version and uptime — proof the connection and auth both work. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jeremylongshore/clickhouse-install-auth