New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Create Test Datasets

by ClickHouse in ClickHouse/ClickHouse

Create test datasets (hits, visits, tpcds, tpch) from standard scripts.

Apache-2.0Auto-check passedDatabases

Install Create Test Datasets

skills CLI
$ npx skills add ClickHouse/ClickHouse --skill create-test-datasets -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install ClickHouse/ClickHouse create-test-datasets --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/ClickHouse/ClickHouse.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/create-test-datasets .claude/skills/create-test-datasets && rm -rf skills-src

Use ~/.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/

Facts

Skill name
create-test-datasets
GitHub stars
50k
Token cost
~1k tokens
SKILL.md length
432 words
Files
1
Skills in repo
24
Repo updated
First seen
Licence
Apache-2.0

At a glance

Create test datasets (hits, visits, tpcds, tpch) from standard scripts.

  • Works in 7 steps: Parse arguments → Verify the server is running → Check for conflicting tables → …
  • Databases work in your project
  • SKILL.md covers Arguments and Process
  • Calls bash

What it does

Create Test Datasets is an agent skill from ClickHouse/ClickHouse. Create test datasets (hits, visits, tpcds, tpch) from standard scripts. Ensures the server is running first.

Its SKILL.md is about 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 Databases. The repository describes itself as: ClickHouse® is a real-time analytics database management system. The licence is Apache-2.0.

When your agent uses it

  • Databases work in your project

Example prompts

  • “/create-test-datasets”

Requirements

  • Pre-approved tools (allowed-tools): Bash(clickhouse-client:*), Bash(clickhouse:*), Bash(pgrep:*), Bash(ls:*), Bash(cat:*), Bash(bash:*), Read, Glob, Grep, AskUserQuestion

Workflow steps

7 steps, taken from the step headings in SKILL.md.

  1. Parse arguments
  2. Verify the server is running
  3. Check for conflicting tables
  4. Set up hits and/or visits
  5. Set up TPC-DS
  6. Set up TPC-H
  7. Verify

What it can do on your machine

Read from SKILL.md and the folder at commit cd023af. 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:

    • Bash(clickhouse-client:*)
    • Bash(clickhouse:*)
    • Bash(pgrep:*)
    • Bash(ls:*)
    • Bash(cat:*)
    • Bash(bash:*)
    • Read
    • Glob
    • Grep
    • AskUserQuestion

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • bash

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

  • Network

    No URLs in SKILL.md.

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

  • Credentials

    Names no API keys, tokens, secrets or passwords.

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

Context cost

Create Test Datasets loads about 1k tokens when it runs. Until then it costs about 32 tokens; SKILL.md has 432 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~32
When it runs · the whole SKILL.md, loaded when a task matches
~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

Auto-check passed

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.

SKILL.md

The full file from ClickHouse/ClickHouse at commit cd023af, republished under its Apache-2.0 licence (© ClickHouse). 432 words, ~1,027 tokens.

Download SKILL.mdSave it as .claude/skills/create-test-datasets/SKILL.md (or your agent's skills folder).
name
create-test-datasets
description
Create test datasets (hits, visits, tpcds, tpch) from standard scripts. Ensures the server is running first.
allowed-tools
Bash(clickhouse-client:*), Bash(clickhouse:*), Bash(pgrep:*), Bash(ls:*), Bash(cat:*), Bash(bash:*), Read, Glob, Grep, AskUserQuestion
argument-hint
[hits] [visits] [tpcds] [tpch]
disable-model-invocation
false

Create Test Datasets Skill

Set up test datasets by executing standard creation scripts. Supports hits, visits, tpcds, and tpch.

Arguments

  • $ARGS (optional): Space-separated list of dataset names from {hits, visits, tpcds, tpch}. If no arguments are provided, defaults to hits visits.

Examples:

  • /create-test-datasets — sets up hits and visits (default)
  • /create-test-datasets hits — sets up only hits
  • /create-test-datasets tpch tpcds — sets up TPC-H and TPC-DS
  • /create-test-datasets hits visits tpch — sets up all three

Process

1. Parse arguments

Parse the argument string into a set of requested datasets. Valid values are hits, visits, tpcds, tpch. If no arguments are provided, use {hits, visits} as the default. If any argument is not in the valid set, report an error and stop.

2. Verify the server is running
bash
clickhouse-client -q "SELECT 1" 2>&1

If the server is not reachable, report an error and stop. Do not attempt to start the server — ask the user to start it first.

3. Check for conflicting tables

Before making any changes, check whether any target tables already exist. Query system.tables once:

bash
clickhouse-client -q "SELECT database || '.' || name FROM system.tables WHERE
    (database = 'test' AND name IN ('hits', 'visits'))
    OR (database = 'tpcds')
    OR (database = 'tpch')"

Build a list of conflicting tables based on what was requested:

  • If hits is requested: test.hits must not exist.
  • If visits is requested: test.visits must not exist.
  • If tpcds is requested: the tpcds database must have no tables.
  • If tpch is requested: the tpch database must have no tables.

If any conflicts are found, report all of them to the user and stop. Do not drop or overwrite anything. Suggest the user drop the conflicting tables manually and rerun the skill.

Show full SKILL.md (184 more words)Show less
4. Set up hits and/or visits

Only execute this step if hits or visits (or both) are in the requested set.

The file tests/docker_scripts/create.sql contains two CREATE TABLE statements: one for datasets.hits_v1 and one for datasets.visits_v1. For each requested dataset, extract only the corresponding statement, replace the table name to create it directly as test.hits or test.visits, and execute it. This avoids creating unnecessary intermediate tables.

bash
clickhouse-client -q "CREATE DATABASE IF NOT EXISTS test"

If hits is requested — extract the datasets.hits_v1 statement, replace the name, and execute:

bash
clickhouse-client --multiquery <<< "$(sed -n '/^CREATE TABLE datasets\.hits_v1/,/);/p' tests/docker_scripts/create.sql | sed 's/datasets\.hits_v1/test.hits/')"

If visits is requested — extract the datasets.visits_v1 statement, replace the name, and execute:

bash
clickhouse-client --multiquery <<< "$(sed -n '/^CREATE TABLE datasets\.visits_v1/,/);/p' tests/docker_scripts/create.sql | sed 's/datasets\.visits_v1/test.visits/')"
5. Set up TPC-DS

Only execute this step if tpcds is in the requested set.

bash
bash tests/docker_scripts/create_tpcds.sh
6. Set up TPC-H

Only execute this step if tpch is in the requested set.

bash
bash tests/docker_scripts/create_tpch.sh
7. Verify

For each dataset that was set up, confirm it exists and report row counts:

  • If hits: SELECT 'test.hits', count() FROM test.hits
  • If visits: SELECT 'test.visits', count() FROM test.visits
  • If tpcds: SELECT name, total_rows FROM system.tables WHERE database = 'tpcds' ORDER BY name
  • If tpch: SELECT name, total_rows FROM system.tables WHERE database = 'tpch' ORDER BY name

Report all results to the user.

© 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

Files

Just SKILL.md in .claude/skills/create-test-datasets of ClickHouse/ClickHouse.

Open the folder on GitHubat commit cd023af

Compare with similar skills

Create Test Datasets 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.

Create Test Datasets compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Create Test Datasets this skillClickHouse/ClickHouse50k—~1kAutomated safety check: PassApache-2.0
Evolving The Data ModelTriliumNext/Trilium38k—~2.1kAutomated safety check: PassAGPL-3.0
Hybrid Cloud Outboxesgetsentry/sentry46k—~4.8kAutomated safety check: PassCustom licence
Adaptive Spin Waitmicrosoft/garnet12k—~1kAutomated safety check: PassMIT
Iptvnator Sqlite DB Worker4gray/iptvnator7.3k—~824Automated safety check: PassMIT
Replicate Video AdJingyi-Wu-Richael/replicate-video-ad1071 repos~1.6kAutomated safety check: PassNone

Similar skills

  • Evolving The Data Model

    TriliumNext/Trilium

    A skill your agent uses when adding a DB migration or a new column/field to a Becca entity in Trilium ("add a migration", "new column on notes/attributes", "ALTER TABLE", "add a field to…

    38k GitHub stars~2.1k tokensUpdated today
    DatabasesAuto-check passed

  • Hybrid Cloud Outboxes

    getsentry/sentry

    Official

    Guide for creating and maintaining outbox-based eventually consistent operations in Sentry.

    46k GitHub stars~4.8k tokensUpdated today
    DatabasesAuto-check passed

  • Adaptive Spin Wait

    microsoft/garnet

    Official

    Selects Garnet spin-wait policies based on the slow-path cost.

    12k GitHub stars~1k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Iptvnator Sqlite DB Worker

    4gray/iptvnator

    A skill your agent uses when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.

    7.3k GitHub stars~824 tokensUpdated yesterday
    DatabasesAuto-check passed

  • Replicate Video Ad

    Jingyi-Wu-Richael/replicate-video-ad

    Analyze a reference video frame by frame and turn its visual grammar, story beats, dialogue, product reveal, proof sequence, and conversion structure into a production-ready ecommerce story-ad…

    107 GitHub starsUsed in 1 repo~1.6k tokens
    DatabasesAuto-check passed

  • Content Create Hero Image

    prisma/web

    Official

    A skill your agent uses when the operator wants a hero or meta image for a Prisma blog post; asks to create or generate a blog hero, cover, social card, Open Graph, or YouTube image; mentions cover…

    1.1k GitHub stars~6.9k tokensUpdated yesterday
    DatabasesAuto-check passed

More from ClickHouse/ClickHouse

All 24 skills in this repo

  • Keeper Stress Analysis

    ClickHouse/ClickHouse

    Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.

    50k GitHub stars~4.7k tokensUpdated today
    Auto-check passed

  • Perf Comparison

    ClickHouse/ClickHouse

    Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.

    50k GitHub stars~3.9k tokensUpdated today
    Auto-check: notes

  • Patch Release Check

    ClickHouse/ClickHouse

    Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…

    50k GitHub stars~4k tokensUpdated today
    Auto-check: notes

  • Alloc Profile

    ClickHouse/ClickHouse

    Analyze a jemalloc (or other) allocation profile in collapsed stack format.

    50k GitHub stars~4.3k tokensUpdated today
    Auto-check passed

  • Bisect

    ClickHouse/ClickHouse

    Bisect a ClickHouse regression using pre-built master binaries from CI.

    50k GitHub stars~1.4k tokensUpdated today
    Auto-check passed

  • Clickhouse PR Description

    ClickHouse/ClickHouse

    Generate PR descriptions for ClickHouse/ClickHouse that match maintainer expectations.

    50k GitHub stars~1.9k tokensUpdated today
    Auto-check passed

Categories

Questions about Create Test Datasets

What does Create Test Datasets do?

Create test datasets (hits, visits, tpcds, tpch) from standard scripts. Create Test Datasets is an agent skill from ClickHouse/ClickHouse. Create test datasets (hits, visits, tpcds, tpch) from standard scripts.

When should I use Create Test Datasets?

Create Test Datasets fits situations like: databases work in your project.

How do I install Create Test Datasets in Claude Code?

Run `npx skills add ClickHouse/ClickHouse --skill create-test-datasets -a claude-code`. Or copy the skill folder (.claude/skills/create-test-datasets in ClickHouse/ClickHouse) into .claude/skills/create-test-datasets in your project. Claude Code loads it when a task matches its description.

How do I install Create Test Datasets in Codex?

Run `npx skills add ClickHouse/ClickHouse --skill create-test-datasets -a codex`. Or copy the skill folder (.claude/skills/create-test-datasets in ClickHouse/ClickHouse) into .agents/skills/create-test-datasets in your project. Codex loads it when a task matches its description.

Can I use Create Test Datasets in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add ClickHouse/ClickHouse --skill create-test-datasets -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/create-test-datasets, .gemini/skills/create-test-datasets, .github/skills/create-test-datasets and .opencode/skills/create-test-datasets in your project.

What does Create Test Datasets need to run?

Going by SKILL.md and its folder, Create Test Datasets needs the command-line tools its instructions call (bash). Its frontmatter pre-approves these tools: Bash(clickhouse-client:*), Bash(clickhouse:*), Bash(pgrep:*), Bash(ls:*), Bash(cat:*), Bash(bash:*), Read, Glob, Grep, AskUserQuestion.

Does Create Test Datasets access the network?

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.

Is Create Test Datasets safe to install?

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.

What licence does Create Test Datasets use?

Create Test Datasets 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.

How many tokens does Create Test Datasets use?

About 1k tokens (SKILL.md is roughly 4.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Create Test Datasets?

Skills that share tags, products or a category with Create Test Datasets: Evolving The Data Model (TriliumNext/Trilium, 38k stars), Hybrid Cloud Outboxes (getsentry/sentry, 46k stars), Adaptive Spin Wait (microsoft/garnet, 12k stars) and Iptvnator Sqlite DB Worker (4gray/iptvnator, 7.3k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Create Test Datasets?

ClickHouse (a GitHub organization) maintains it in ClickHouse/ClickHouse, which has 50,288 GitHub stars. The repository holds 24 skills in this directory. The repository was last updated on October 8, 2026.

Source: ClickHouse/ClickHouse on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.