What is slv-jetstreamer?

A setup and operating guide for Jetstreamer and ClickHouse to turn archived Solana data into queryable SQL tables. Jetstreamer is a one-time data-loading process, while ClickHouse is the database that stays available for queries.

Use it to load Old Faithful CAR archives, maintain hourly backfills and rolling data windows, and analyze program calls, slot statuses, public-key mentions, MEV, or decentralized-exchange activity.

It separates high-volume historical analysis from ordinary per-request Solana RPC access, making large datasets available for SQL queries.

slv-jetstreamer — Skill for Claude Code and Codex by ValidatorsDAO/slv

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add ValidatorsDAO/slv --skill slv-jetstreamer

Clone the repo

git clone --depth 1 https://github.com/ValidatorsDAO/slv

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/validatorsdao/slv/slv-jetstreamer/github.svg)](https://agentmods.dev/skills/validatorsdao/slv/slv-jetstreamer)

Your own site

<a href="https://agentmods.dev/skills/validatorsdao/slv/slv-jetstreamer"><img src="https://agentmods.dev/badge/skills/validatorsdao/slv/slv-jetstreamer/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/validatorsdao/slv/slv-jetstreamer"><img src="https://agentmods.dev/badge/skills/validatorsdao/slv/slv-jetstreamer.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 78 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 2,143 The whole file, excluding the scripts and references it only reads on demand.

Security scan B 1 finding. A grade says what 26 rules found in the file — not that it is safe. Third-party audits

NVIDIA SkillSpector warn 7 Sept 2026

SkillSpector: 1 finding, up to medium

These are SkillSpector’s own severities. On a checked sample its high-severity flags on skills were ~96% false positives — a documented command, a public API, a “never do X” rule — so we show them as a caution to read, not a verdict. Why →

medium Privilege Escalation · line 160
Commands invoke sudo or root privileges. Verify this elevated access is necessary and justified.

Fix: Avoid sudo/root unless strictly required. Prefer least-privilege patterns. If elevation is needed, document the justification and scope.

How audits are shown

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00078	$0.02143
Opus 5.5	$0.00031	$0.00857
Sonnet 5.5	$0.00016	$0.00429
Haiku 4.5	$0.00008	$0.00214

Measured 2mo ago against content hash ade4b3090984, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade B, and why

slv-jetstreamer scanned grade B with 1 finding against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Asks for rootmediumPrivilege escalation

A mod that escalates privileges can change anything on the machine, not only the project.

- `/mnt` defaulting to mode 0700 (some Solana host images) blocks the `clickhouse` system user from traversing — `chmod 0755 /mnt`.

oss-skills/slv-jetstreamer/SKILL.md · 161 lines

How it starts

The opening of the file, as written. The whole thing — 161 lines — stays where its author put it; the contents beside it link to each section on GitHub.

SLV Jetstreamer Skill

jetstreamer is anza-xyz's high-throughput Solana ETL engine: it streams the Old Faithful CAR archive directly into a local ClickHouse instance and produces query-ready aggregations (program invocation counts, slot statuses, pubkey mentions, …). Together with the slv-rpc of1 rolling cache, it gives a clean separation:

Layer	Component	Role
JSON-RPC (per-call)	`yellowstone-faithful` (Index RPC) + 30-epoch index cache	`getTransaction` / `getBlock` / `getBlockTime` etc.
SQL analytics (bulk)	`jetstreamer` + ClickHouse	Cross-epoch aggregations, program-level joins, MEV / DEX research

Jetstreamer is not a server. It runs as a one-shot ETL per epoch and exits; ClickHouse is the long-running query surface.

Hardware target

Resource	Recommended
CPU	AMD EPYC 64C+ (jetstreamer hits 2.7 M TPS+ ingest with all cores)
RAM	128 GB+ (754 GB optimal for full-fat ClickHouse buffers)
Disk	4-8 TB NVMe (RAID0 recommended for max write bandwidth — derived data is rebuildable from Old Faithful)
Network	10 Gbps+ (50 Gbps demonstrated to fully saturate ingest path)
OS	Ubuntu 24.04, kernel 6.14+
Toolchain	Clang 16 (RocksDB compatibility — Clang 17/18 do not work), GCC 13, Rust (rustup, toolchain pinned by rust-toolchain.toml in jetstreamer repo)

Disk layout

The reference layout combines two NVMes into one mdadm RAID0 stripe:

/dev/nvme0n1 ─┐
              ├─ mdadm RAID0 (chunk=1M) ─► /dev/md0 ─► XFS @ /mnt/jetstreamer
/dev/nvme1n1 ─┘                                       (noatime,inode64,
                                                       logbufs=8,logbsize=256k)

Mount options chosen for sequential write bandwidth + many-small-files (CH parts): noatime,nodiratime,inode64,logbufs=8,logbsize=256k. Format with mkfs.xfs -d agcount=64 -l size=1g for parallel allocation groups + a 1 GiB internal log (XFS log max).

Production benchmark on this layout: 8.1 GB/s sequential write, 13.0 GB/s sequential read (direct I/O).

Read the full file on GitHub · 161 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2mo ago First seen · 161 lines · 78 tokens per session scan B ade4b3090984

Subscribe to this mod's changes

slv-jetstreamer is a skill published in the GitHub repository ValidatorsDAO/slv (96 stars, last pushed 17d ago), licensed Apache-2.0. It adds 78 tokens to every session and 2,143 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it B with 1 finding (asks for root). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Analytics and metrics Databases Web3 and blockchain agent dapp rpc solana validator

slv-jetstreamer next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
slv-jetstreamerValidatorsDAO/slv	Skill	96	17d ago	Apache-2.0	B	78	Claude Code, Codex
alchemy-agentic-gatewaymoonpay/skills	Skill	112	17d ago	MIT	A	101	Claude Code
alchemy-apimoonpay/skills	Skill	112	17d ago	MIT	A	100	Claude Code
stellar-forgerylsherdamz-rgb/stellar-forge	Skill	17	5d ago	MIT	A	82	Claude Code
stellar-mcprylsherdamz-rgb/stellar-forge	Skill	17	5d ago	MIT	A	61	Claude Code
rpcedgerpc-edge/rpcedge-toolkit	Skill	1	10d ago	MIT	A	76	Claude Code
Solana Agent Builderdemo112/yunqu-ai-skills	Skill	45	5mo ago	MIT	A	32	Claude Code, Codex

slv-jetstreamer