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

Wal Inspect Aggs

by celeriant in celeriant/celeriant-db

Run celeriant-wal-inspect on a list of failing aggregates across all shards on the rpi cluster and return a tabulated disk-truth report.

Apache-2.0Auto-check: notesBackend & APIs

Install Wal Inspect Aggs

skills CLI
$ npx skills add celeriant/celeriant-db --skill wal-inspect-aggs -a claude-code

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

GitHub CLI
$ gh skill install celeriant/celeriant-db wal-inspect-aggs --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/celeriant/celeriant-db.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/wal-inspect-aggs .claude/skills/wal-inspect-aggs && 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
wal-inspect-aggs
GitHub stars
114
Token cost
~837 tokens
SKILL.md length
279 words
Files
1
Skills in repo
13
Repo updated
First seen
Licence
Apache-2.0

At a glance

Run celeriant-wal-inspect on a list of failing aggregates across all shards on the rpi cluster and return a tabulated disk-truth report.

  • Backend & APIs work in your project
  • SKILL.md covers When to use, When NOT to use, Key facts the agent needs to… and How to invoke, plus 1 more section
  • Calls ssh and just

What it does

Wal Inspect Aggs is an agent skill from celeriant/celeriant-db. Run celeriant-wal-inspect on a list of failing aggregates across all shards on the rpi cluster and return a tabulated disk-truth report. Use during data-integrity investigations to cross-check audit claims against on-disk state without bloating the main conversation with raw wal-inspect output.

Its SKILL.md is about 840 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 Backend & APIs. The repository describes itself as: Fast, distributed per-aggregate event log with strict ordering and optimistic concurrency control. The licence is Apache-2.0.

When your agent uses it

  • Backend & APIs work in your project

Example prompts

  • “/wal-inspect-aggs”

What it can do on your machine

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

  • Tool permissions

    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.

  • Runs code

    Shell commands in SKILL.md call:

    • ssh
    • just

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

  • Network

    No URLs in SKILL.md. Its commands use ssh, which can reach the network depending on how they are called.

    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

Wal Inspect Aggs loads about 837 tokens when it runs. Until then it costs about 78 tokens; SKILL.md has 279 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~78
When it runs · the whole SKILL.md, loaded when a task matches
~837

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

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteRuns commands with sudoSKILL.md:44
    ar/lib/celeriant/shard_<n>/log_*.wal; do sudo /usr/local/bin/celeriant-wal-inspect "$f" client <org> <type> <agg> <clien

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 celeriant/celeriant-db at commit d071a6d, republished under its Apache-2.0 licence (© celeriant). 279 words, ~837 tokens.

Download SKILL.mdSave it as .claude/skills/wal-inspect-aggs/SKILL.md (or your agent's skills folder).
name
wal-inspect-aggs
description
Run celeriant-wal-inspect on a list of failing aggregates across all shards on the rpi cluster and return a tabulated disk-truth report. Use during data-integrity investigations to cross-check audit claims against on-disk state without bloating the main conversation with raw wal-inspect output.

wal-inspect-aggs

Delegates the grunt work of SSHing to the rpi data nodes, running celeriant-wal-inspect client <org> <agg_type> <agg> <client> per shard for each aggregate in a list, and aggregating the results into a single table. Saves ~30-50 lines of context per aggregate inspected.

When to use

  • Confirming or refuting an audit claim (e.g., "deep audit says no missing, but is the disk consistent?").
  • Investigating agg_version reuse — wal-inspect shows the on-disk shape clearly (missing in 1..=N summary).
  • Need disk-truth for multiple aggregates in one shot.

When NOT to use

  • One-off ad-hoc inspection of a single aggregate (just SSH and run directly — the overhead of dispatching isn't worth it).
  • Need to read raw wal-inspect output line-by-line for some idiosyncratic pattern.

Key facts the agent needs to know

  • The tool is at /usr/local/bin/celeriant-wal-inspect on cs1 (192.168.88.214) and cs2 (192.168.88.213).
  • Subcommand for a (aggregate, client_id): client <org_id> <agg_type_id> <agg_id> <client_id>. IDs are decimal u128 or 32-char hex strings.
  • The wal-inspect tool operates per-file, NOT per-shard. Each shard has one or more log_N.wal files in /var/lib/celeriant/shard_<id>/. Iterate over all log_*.wal files per shard to get full disk truth.
  • Aggregates only live on shards 1..3 when RESERVE_COORDINATOR_SHARD=true (the default for the rpi cluster). Routing of aggregate_id → shard is non-obvious; the workaround is to inspect ALL non-zero shards and pick the one with matched batches > 0.
  • The summary line missing in 1..=N is the headline: empty list = all seqs present on disk; otherwise it lists the gap.

How to invoke

Dispatch a general-purpose agent with the list of aggregates. Template:

For each aggregate in the list below, SSH to the rpi data nodes and run
celeriant-wal-inspect on every log_*.wal file across shards 1..3 on cs1
(192.168.88.214). The cluster may be running or stopped — either is fine.

For each aggregate, report ONE line:
  client=<id> org=<o> type=<t> agg=<a>  shard=<n>  total_batches=<X>  within_read=<X>  max_agg_ver=<X>  distinct_seqs=<X>  missing=<list-or-none>

If matched batches == 0 on every shard, say "NOT FOUND on cs1".

Skip shard 0 (coordinator-reserved). Use:
  ssh 192.168.88.214 'for f in /var/lib/celeriant/shard_<n>/log_*.wal; do sudo /usr/local/bin/celeriant-wal-inspect "$f" client <org> <type> <agg> <client> 2>&1; done'

Aggregates to inspect:
- client=<C1> org=<O> type=<T> agg=<A1>
- client=<C2> org=<O> type=<T> agg=<A2>
- ...

Report under 300 words. No raw wal-inspect output, no per-batch lines —
just the tabulated summary line per aggregate.

Caller pattern

Agent(
  description: "wal-inspect <N> aggregates",
  subagent_type: "general-purpose",
  prompt: <template above with aggregate list filled in>,
)

Use the returned table to decide whether to drill deeper on a specific aggregate (which would warrant a direct SSH for the raw output).

© celeriant, 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/wal-inspect-aggs of celeriant/celeriant-db.

Open the folder on GitHubat commit d071a6d

Compare with similar skills

Wal Inspect Aggs 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.

Wal Inspect Aggs compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Wal Inspect Aggs this skillceleriant/celeriant-db114—~837Automated safety check: NotesApache-2.0
Configuring Horizoncoollabsio/coolify63k4 repos~898Automated safety check: PassMIT
Nestjs Best Practicesrolling-scopes/rsschool-app10k6 repos~1.2kAutomated safety check: PassMIT
Sub2API AdminWei-Shaw/sub2api44k1 repos~717Automated safety check: PassLGPL-3.0
Firecrawl Build Onboardingfirecrawl/firecrawl190k1 repos~1.4kAutomated safety check: NotesISC
Obsidian BasesAtmosphere/atmosphere3.8k22 repos~3.2kAutomated safety check: PassApache-2.0

Similar skills

  • Configuring Horizon

    coollabsio/coolify

    A skill your agent uses whenever the user mentions Horizon by name in a Laravel context.

    63k GitHub starsUsed in 4 repos~898 tokens
    Backend & APIsAuto-check passed

  • Nestjs Best Practices

    rolling-scopes/rsschool-app

    NestJS best practices and architecture patterns for building production-ready applications.

    10k GitHub starsUsed in 6 repos~1.2k tokens
    Backend & APIsAuto-check passed

  • Sub2API Admin

    Wei-Shaw/sub2api

    Manages a Sub2API deployment from the command line: accounts, redeem and invitation codes, groups, proxies, imports, exports and raw admin API calls.

    44k GitHub starsUsed in 1 repo~717 tokens
    Backend & APIsAuto-check passed

  • Firecrawl Build Onboarding

    firecrawl/firecrawl

    Gets Firecrawl working in a project: signs you in through the browser, saves FIRECRAWL_API_KEY to .env and picks the first SDK or REST path.

    190k GitHub starsUsed in 1 repo~1.4k tokens
    Backend & APIsAuto-check: notes

  • Obsidian Bases

    Atmosphere/atmosphere

    Create and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries.

    3.8k GitHub starsUsed in 22 repos~3.2k tokens
    Backend & APIsAuto-check passed

  • Fortify Development

    coollabsio/coolify

    ACTIVATE when the user works on authentication in Laravel. An agent skill from coollabsio/coolify.

    63k GitHub starsUsed in 4 repos~1.9k tokens
    Backend & APIsAuto-check passed

More from celeriant/celeriant-db

All 13 skills in this repo

  • Error Handling

    celeriant/celeriant-db

    Error handling patterns in Celeriant. An agent skill from celeriant/celeriant-db.

    114 GitHub stars~550 tokensUpdated 11 days ago
    Auto-check passed

  • Testing

    celeriant/celeriant-db

    How to write and run tests in Celeriant. An agent skill from celeriant/celeriant-db.

    114 GitHub stars~951 tokensUpdated 11 days ago
    Auto-check passed

  • Understanding Celeriant Structure

    celeriant/celeriant-db

    Celeriant codebase architecture, crate responsibilities, and how they fit together.

    114 GitHub stars~803 tokensUpdated 11 days ago
    Auto-check passed

  • Extract A Type

    celeriant/celeriant-db

    Refactor a named Rust type or its surrounding code with an agreed scope.

    114 GitHub stars~934 tokensUpdated 11 days ago
    Auto-check passed

  • Client Server Protocol

    celeriant/celeriant-db

    Celeriant's client-server protocol invariants, network behavior, failure modes, and shard routing.

    114 GitHub stars~1.6k tokensUpdated 11 days ago
    Auto-check passed

  • Database Architecture

    celeriant/celeriant-db

    Core architecture invariants for Celeriant. An agent skill from celeriant/celeriant-db.

    114 GitHub stars~1.5k tokensUpdated 11 days ago
    Auto-check passed

Categories

Questions about Wal Inspect Aggs

What does Wal Inspect Aggs do?

Run celeriant-wal-inspect on a list of failing aggregates across all shards on the rpi cluster and return a tabulated disk-truth report. Wal Inspect Aggs is an agent skill from celeriant/celeriant-db. Run celeriant-wal-inspect on a list of failing aggregates across all shards on the rpi cluster and return a tabulated disk-truth report.

When should I use Wal Inspect Aggs?

Wal Inspect Aggs fits situations like: backend & APIs work in your project.

How do I install Wal Inspect Aggs in Claude Code?

Run `npx skills add celeriant/celeriant-db --skill wal-inspect-aggs -a claude-code`. Or copy the skill folder (.claude/skills/wal-inspect-aggs in celeriant/celeriant-db) into .claude/skills/wal-inspect-aggs in your project. Claude Code loads it when a task matches its description.

How do I install Wal Inspect Aggs in Codex?

Run `npx skills add celeriant/celeriant-db --skill wal-inspect-aggs -a codex`. Or copy the skill folder (.claude/skills/wal-inspect-aggs in celeriant/celeriant-db) into .agents/skills/wal-inspect-aggs in your project. Codex loads it when a task matches its description.

Can I use Wal Inspect Aggs 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 celeriant/celeriant-db --skill wal-inspect-aggs -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/wal-inspect-aggs, .gemini/skills/wal-inspect-aggs, .github/skills/wal-inspect-aggs and .opencode/skills/wal-inspect-aggs in your project.

What does Wal Inspect Aggs need to run?

Going by SKILL.md and its folder, Wal Inspect Aggs needs the command-line tools its instructions call (ssh and just).

Does Wal Inspect Aggs access the network?

SKILL.md contains no URLs. Its commands use ssh, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Wal Inspect Aggs safe to install?

Our automated static check of SKILL.md found notes only (runs commands with sudo), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Wal Inspect Aggs use?

Wal Inspect Aggs 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 Wal Inspect Aggs use?

About 837 tokens (SKILL.md is roughly 3.3k 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 Wal Inspect Aggs?

Skills that share tags, products or a category with Wal Inspect Aggs: Configuring Horizon (coollabsio/coolify, 63k stars), Nestjs Best Practices (rolling-scopes/rsschool-app, 10k stars), Sub2API Admin (Wei-Shaw/sub2api, 44k stars) and Firecrawl Build Onboarding (firecrawl/firecrawl, 190k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Wal Inspect Aggs?

celeriant (a GitHub organization) maintains it in celeriant/celeriant-db, which has 114 GitHub stars. The repository holds 13 skills in this directory. The repository was last updated on September 28, 2026.

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