Databuddy Internal
databuddy-analytics/Databuddy
Work inside the Databuddy monorepo for internal implementation, debugging, review, and refactoring.
Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting.
$ npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install ClickHouse/clickhouse-java write-doc-examples --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/ClickHouse/clickhouse-java.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.cursor/skills/write-doc-examples .claude/skills/write-doc-examples && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "write-doc-examples" agent skill from https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examples into .claude/skills/write-doc-examples/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "write-doc-examples", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examplesType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install ClickHouse/clickhouse-java write-doc-examples --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/clickhouse-java.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.cursor/skills/write-doc-examples .agents/skills/write-doc-examples && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "write-doc-examples" agent skill from https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examples into .agents/skills/write-doc-examples/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "write-doc-examples", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install ClickHouse/clickhouse-java write-doc-examples --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/clickhouse-java.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.cursor/skills/write-doc-examples .cursor/skills/write-doc-examples && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "write-doc-examples" agent skill from https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examples into .cursor/skills/write-doc-examples/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "write-doc-examples", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/ClickHouse/clickhouse-java.git --path .cursor/skills/write-doc-examples--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install ClickHouse/clickhouse-java write-doc-examples --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/clickhouse-java.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.cursor/skills/write-doc-examples .gemini/skills/write-doc-examples && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "write-doc-examples" agent skill from https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examples into .gemini/skills/write-doc-examples/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "write-doc-examples", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install ClickHouse/clickhouse-java write-doc-examplesInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/ClickHouse/clickhouse-java.git skills-src && mkdir -p .github/skills && cp -r skills-src/.cursor/skills/write-doc-examples .github/skills/write-doc-examples && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "write-doc-examples" agent skill from https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examples into .github/skills/write-doc-examples/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "write-doc-examples", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install ClickHouse/clickhouse-java write-doc-examples --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/clickhouse-java.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.cursor/skills/write-doc-examples .opencode/skills/write-doc-examples && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "write-doc-examples" agent skill from https://github.com/ClickHouse/clickhouse-java/tree/main/.cursor/skills/write-doc-examples into .opencode/skills/write-doc-examples/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "write-doc-examples", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
write-doc-examplesWrite, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting.
Write Doc Examples is an agent skill from ClickHouse/clickhouse-java. Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting. Use when writing, updating, or formatting Java code examples in integration guides and documentation (such as docs/integration-client.md or docs/integration-jdbc.md).
Its SKILL.md is about 3.1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Development, covering Linting and formatting and Data warehousing. It works with Java and ClickHouse. The repository describes itself as: ClickHouse Java Clients & JDBC Driver. The licence is Apache-2.0.
5 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit 67a6b9e. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
No scripts in the folder and no shell commands in SKILL.md (its code samples are java).
From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Write Doc Examples loads about 3.1k tokens when it runs. Until then it costs about 83 tokens; SKILL.md has 782 words of instructions outside code blocks.
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.
The automated check found no risky patterns in SKILL.md.
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.
The full file from ClickHouse/clickhouse-java at commit 67a6b9e, republished under its Apache-2.0 licence (© ClickHouse). 782 words, ~3,119 tokens.
.claude/skills/write-doc-examples/SKILL.md (or your agent's skills folder).This skill guides writing, rewriting, and formatting code snippets in documentation so they can be directly reused or integrated into production Java applications while maintaining stylistic consistency across the document.
Always align with patterns and conventions established earlier in the same document:
Client.Builder (e.g., public Client.Builder createBaseClient()), subsequent configuration options (auth schemes, TLS, proxy, timeouts) must follow the same pattern rather than reverting to creating full Client instances from scratch.public Client createAnalyticsDBClient(Client.Builder baseClient)).createBaseClient, client, schema, settings, events) across all snippets in the document.Never present bare, loose statements floating outside a method. Encapsulate every snippet into a realistic, reusable method:
public Client.Builder createBaseClient(), public Client createAnalyticsDBClient(Client.Builder baseClient)).public List<Event> readEvents(Client client, TableSchema schema), public void writeEvents(Client client, List<Event> events)).Client client, TableSchema schema, InsertSettings settings, etc.) and meaningful return types instead of writing top-level procedural scripts.At the top of the code block, list only the imports that belong to the library:
com.clickhouse.client.api.*, com.clickhouse.data.*, com.clickhouse.jdbc.*, etc.java.util.List, java.util.Map, java.io.InputStream, java.util.concurrent.TimeUnit) unless needed to avoid ambiguity.Keep examples focused on library usage:
AppConfiguration) do not need full definitions.try-with-resources for closable resources such as QueryResponse, InsertResponse, and streams.// add db specific configuration).When updating documentation examples:
Client.Builder factory methods).Client.Builder or take Client.Builder baseClient if established earlier in the guide.Client (and any required schemas or options) as parameters.com.clickhouse.* imports required by the snippet at the top.try-with-resources blocks.Before (Loose snippet):
Client client = new Client.Builder()
.addEndpoint("http://localhost:8123")
.setUsername("default")
.setPassword("secret")
.setDefaultDatabase("analytics")
.build();After (Reusable production methods with library imports):
import com.clickhouse.client.api.Client;
public Client.Builder createBaseClient() {
return new Client.Builder()
.addEndpoint("http://localhost:8123")
.setUsername("default")
.setPassword("secret")
// set common configuration
;
}
public Client createAnalyticsDBClient(Client.Builder baseClient) {
return baseClient
.setDefaultDatabase("analytics")
// add db specific configuration
.build();
}When earlier sections establish createBaseClient() returning Client.Builder, all variant auth/network options maintain that same style:
Option B (Bearer Auth):
import com.clickhouse.client.api.Client;
public Client.Builder createBaseClient() {
return new Client.Builder()
.addEndpoint("http://localhost:8123")
.useBearerTokenAuth("my_access_token");
}Option C (Mutual TLS):
import com.clickhouse.client.api.Client;
import com.clickhouse.client.api.enums.SSLMode;
public Client.Builder createBaseClient() {
return new Client.Builder()
.addEndpoint("https://localhost:8443")
.useSSLAuthentication(true)
.setClientCertificate("/path/to/client.crt")
.setClientKey("/path/to/client.key")
.setRootCertificate("/path/to/ca.crt")
.setSSLMode(SSLMode.STRICT);
}Before (Loose statement):
client.updateUserAndPassword("new_user", "new_password");After (Wrapped method; obvious custom config class omitted):
void updateClientCredentials(Client client, AppConfiguration appConf) {
client.updateUserAndPassword(appConf.db_username, appConf.db_password);
}Before (Script-like sequence):
TableSchema schema = client.getTableSchema("events");
client.register(Event.class, schema);
List<Event> events = client.queryAll("SELECT * FROM events", Event.class, schema);
client.insert("events", events).get();After (Structured into definition, registration, read, and write methods):
public static class Event {
public long id;
public String name;
public long timestamp;
}import com.clickhouse.client.api.Client;
import com.clickhouse.client.api.metadata.TableSchema;
void registerPojoMappings(Client client, Map<Class<?>, String> pojoTables) {
for (Map.Entry<Class<?>, String> entry : pojoTables.entrySet()) {
TableSchema schema = client.getTableSchema(entry.getValue());
client.register(entry.getKey(), schema);
}
}import com.clickhouse.client.api.Client;
import com.clickhouse.client.api.metadata.TableSchema;
public List<Event> readEvents(Client client, TableSchema schema) {
return client.queryAll(
"SELECT id, name, timestamp FROM events",
Event.class,
schema);
}import com.clickhouse.client.api.Client;
import com.clickhouse.client.api.insert.InsertResponse;
public void writeEvents(Client client, List<Event> events) throws Exception {
if (events.isEmpty()) {
return;
}
try (InsertResponse response = client.insert("events", events).get()) {
// handle response metrics or confirmation
}
}Before (Procedural script):
QuerySettings settings = new QuerySettings()
.setFormat(ClickHouseFormat.RowBinaryWithNamesAndTypes);
QueryResponse response = client.query("SELECT * FROM events", settings).get();
ClickHouseBinaryFormatReader reader = client.newBinaryFormatReader(response);
while (reader.hasNext()) {
reader.next();
long id = reader.getLong("id");
}After (Encapsulated method with try-with-resources and library imports):
import com.clickhouse.client.api.Client;
import com.clickhouse.client.api.data_formats.ClickHouseBinaryFormatReader;
import com.clickhouse.client.api.query.QueryResponse;
import com.clickhouse.client.api.query.QuerySettings;
import com.clickhouse.data.ClickHouseFormat;
public void streamEvents(Client client) throws Exception {
QuerySettings settings = new QuerySettings()
.setFormat(ClickHouseFormat.RowBinaryWithNamesAndTypes);
try (QueryResponse response = client.query("SELECT * FROM events", settings)
.get(30, TimeUnit.SECONDS)) {
ClickHouseBinaryFormatReader reader = client.newBinaryFormatReader(response);
while (reader.hasNext()) {
reader.next();
long id = reader.getLong("id");
String name = reader.getString("name");
// process row data
}
}
}Before (Loose insert callback):
TableSchema schema = client.getTableSchema("events");
ClickHouseFormat format = ClickHouseFormat.RowBinary;
client.insert("events", out -> {
RowBinaryFormatWriter writer = new RowBinaryFormatWriter(out, schema, format);
for (Event event : events) {
writer.setValue("id", event.getId());
writer.commitRow();
}
}, format, new InsertSettings()).get();After (Encapsulated write method with proper response closure):
import com.clickhouse.client.api.Client;
import com.clickhouse.client.api.data_formats.RowBinaryFormatWriter;
import com.clickhouse.client.api.insert.InsertResponse;
import com.clickhouse.client.api.insert.InsertSettings;
import com.clickhouse.client.api.metadata.TableSchema;
import com.clickhouse.data.ClickHouseFormat;
public void writeEventsStream(Client client, TableSchema schema, List<Event> events) throws Exception {
ClickHouseFormat format = ClickHouseFormat.RowBinary;
try (InsertResponse response = client.insert("events", out -> {
RowBinaryFormatWriter writer = new RowBinaryFormatWriter(out, schema, format);
for (Event event : events) {
writer.setValue("id", event.id);
writer.setValue("name", event.name);
writer.commitRow();
}
}, format, new InsertSettings()).get()) {
// handle response metrics
}
}Before finalizing any rewritten documentation example:
Client.Builder return type)?com.clickhouse.*) present and accurate?QueryResponse, InsertResponse, etc.) properly handled with try-with-resources?© ClickHouse, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in .cursor/skills/write-doc-examples of ClickHouse/clickhouse-java.
Open the folder on GitHubat commit 67a6b9e
Write Doc Examples next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Write Doc Examples this skillClickHouse/clickhouse-java | 1.6k | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | |
| Databuddy Internaldatabuddy-analytics/Databuddy | 1.2k | — | ~11k | Automated safety check: Notes | AGPL-3.0 | |
| Adapter Alignmentevloghq/evlog | 1.9k | — | ~1.3k | Automated safety check: Pass | MIT | |
| Android Code Quality Checkerwordpress-mobile/WordPress-Android | 3.2k | — | ~587 | Automated safety check: Pass | GPL-2.0 | |
| Version Upgrade Advisorchmonitor/chmonitor | 298 | — | ~1.6k | Automated safety check: Pass | GPL-3.0 | |
| Adversarial Rustpproenca/dot-skills | 214 | — | ~2.8k | Automated safety check: Pass | MIT |
databuddy-analytics/Databuddy
Work inside the Databuddy monorepo for internal implementation, debugging, review, and refactoring.
evloghq/evlog
Twice-monthly check that evlog's drain adapters still send what each provider's own client sends.
wordpress-mobile/WordPress-Android
Runs detekt, checkstyle, and Android lint together, reads their reports, and proposes approved fixes grouped by file.
chmonitor/chmonitor
Advises whether and how to upgrade ClickHouse — versioning scheme, upgrade path, what you gain, pre/post-upgrade checklist.
pproenca/dot-skills
A skill your agent uses when reviewing or refactoring existing Rust code that carries an alien mental model — OO/enterprise ceremony from Java/C, garbage-collected object graphs, exception-style…
langfuse/langfuse
Build or review Langfuse backend code. An agent skill from langfuse/langfuse.
ClickHouse/clickhouse-java
Analyzes a single GitHub issue at a time. An agent skill from ClickHouse/clickhouse-java.
ClickHouse/clickhouse-java
Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output.
ClickHouse/clickhouse-java
Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests.
Works with
Categories
Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting. Write Doc Examples is an agent skill from ClickHouse/clickhouse-java. Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting.
Write Doc Examples fits situations like: formatting Java code examples in integration guides and documentation (such as docs/integration-client.md; docs/integration-jdbc.md).
Run `npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a claude-code`. Or copy the skill folder (.cursor/skills/write-doc-examples in ClickHouse/clickhouse-java) into .claude/skills/write-doc-examples in your project. Claude Code loads it when a task matches its description.
Run `npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a codex`. Or copy the skill folder (.cursor/skills/write-doc-examples in ClickHouse/clickhouse-java) into .agents/skills/write-doc-examples in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add ClickHouse/clickhouse-java --skill write-doc-examples -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/write-doc-examples, .gemini/skills/write-doc-examples, .github/skills/write-doc-examples and .opencode/skills/write-doc-examples in your project.
SKILL.md names no scripts, command-line tools or credentials: Write Doc Examples is instructions for the agent only.
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Write Doc Examples is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 3.1k tokens (SKILL.md is roughly 12k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Write Doc Examples: Databuddy Internal (databuddy-analytics/Databuddy, 1.2k stars), Adapter Alignment (evloghq/evlog, 1.9k stars), Android Code Quality Checker (wordpress-mobile/WordPress-Android, 3.2k stars) and Version Upgrade Advisor (chmonitor/chmonitor, 298 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
ClickHouse (a GitHub organization) maintains it in ClickHouse/clickhouse-java, which has 1,620 GitHub stars. The repository holds 4 skills in this directory. The repository was last updated on October 6, 2026.
Source: ClickHouse/clickhouse-java on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.