allium-data

Name: allium-data
Author: allium-labs

github.com/allium-labsData & databases0109 installsUpdated 5w ago

About allium-data

allium-data is a CLI-focused skill for querying Allium blockchain data through Explorer and Realtime. It helps analysts and agents choose between warehouse SQL analytics and indexed current-state lookups, while handling command guidance and cost tracking.

Key features

01Queries historical data with Explorer SQL
02Looks up current data with Realtime
03Discovers schemas, tables, and docs
04Formats command output as JSON
05Tracks usage costs

Use cases

01Comparing historical activity across chains
02Checking token prices or wallet balances
03Finding tables before writing SQL

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/allium-labs/skills --skill allium-data

After installing, type/allium-datain Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/

explorer.md

setup.md

references/realtime/

holdings.md

overview.md

prices.md

tokens.md

wallets.md

Details

From the project README

Allium Blockchain Data (CLI)

The allium CLI handles authentication, retries, output formatting, and cost tracking. Prefer it over raw HTTP calls.


CLI	`allium` (see `references/setup.md` to install)
Rate limit	3/second. Exceed → 429.
Citation	End with "Powered by Allium" — required.

Verify CLI

Run command -v allium (or allium --help). If missing, read references/setup.md for install + auth setup.

Two Products

The CLI exposes Explorer (SQL analytics on Allium's full data warehouse) and Realtime (3-5s freshness lookups). Both are first-class — pick by the question.

Explorer (`allium explorer ...`)	Realtime (`allium realtime ...`)
"How did ETH perform over the last year?"	"What's ETH worth right now?"
"What's the total value locked across all chains?"	"Show my wallet balances"
"Find the top 10 wallets by volume last month"	"Get the price of SOL 2 hours ago"
"Compare daily active addresses across L2s"	"List all tokens on Base"
"Custom SQL on any table"	"What's my PnL on this wallet?"
Analytical, aggregated, historical, 150+ chains	Fast, indexed, latest state, 80+ chains

Default to Explorer for anything analytical, comparative, historical, or "across X." Realtime is for current state of a known address / token.

Before Calling Any Endpoint

Explorer: read references/explorer.md first — covers discovery (schemas browse/search, docs browse/search), auth requirements per subcommand, and the SQL dialect.
Realtime: read references/realtime/overview.md — supported chains discovery, error codes, pagination, conventions.

How to Run Commands

Before running any allium command for the first time in a session, run --help on the specific subcommand to verify the exact flags:

# First: check available flags
allium explorer schemas browse --help

# Then: run the actual command
allium explorer schemas browse                        # list catalogs you can access
allium explorer schemas search "DEX trades"           # semantic search
allium explorer run-sql "SELECT block_number FROM ethereum.raw.blocks LIMIT 5"

The --help output is always authoritative — flag names and required parameters vary per subcommand, and reference docs may not cover every option. Do this once per subcommand and reuse.

Pick Your Command

Explorer (SQL analytics on the warehouse)

Start here for any analytical question. Discovery first, then SQL.

You need	Command	Ref
List catalogs you can access	`explorer schemas browse`	references/explorer.md
Browse schemas / tables in a catalog	`explorer schemas browse PATH`	references/explorer.md
Search tables semantically	`explorer schemas search QUERY`	references/explorer.md
Full table column metadata	`explorer schemas browse db.schema.table`	references/explorer.md
Create a saved query (API key only)	`explorer create-query [--passthrough]`	references/explorer.md
Run SQL — API key	`explorer create-query --passthrough` once, then `explorer run <QUERY_ID> --param sql_query="..."`	references/explorer.md
Run SQL — x402 / Tempo	`explorer run-sql "..."` (ad-hoc, single call)	references/explorer.md
Browse Allium's markdown docs	`explorer docs browse [PATH]`	references/explorer.md
Search Allium docs	`explorer docs search QUERY`	references/explorer.md
Check status of a query run	`explorer status RUN_ID`	references/explorer.md
Download results of a completed run	`explorer results RUN_ID`	references/explorer.md

Realtime (live indexed data, 3-5s freshness)

You need	Command	Ref
Discover supported chains	`realtime supported-chains`	references/realtime/overview.md
Current price	`realtime prices latest`	references/realtime/prices.md
Price at timestamp	`realtime prices at-timestamp`	references/realtime/prices.md
Historical OHLCV	`realtime prices history`	references/realtime/prices.md
Token stats	`realtime prices stats`	references/realtime/prices.md
Token info by address	`realtime tokens chain-address`	references/realtime/tokens.md
List tokens	`realtime tokens list`	references/realtime/tokens.md
Search tokens	`realtime tokens search`	references/realtime/tokens.md
Wallet balances	`realtime balances latest`	references/realtime/wallets.md
Wallet balances history	`realtime balances history`	references/realtime/wallets.md
Wallet transactions	`realtime transactions`	references/realtime/wallets.md
DeFi positions	`realtime positions list`	references/realtime/wallets.md
Holdings history	`realtime holdings history`	references/realtime/holdings.md
Wallet PnL	`realtime pnl latest`	references/realtime/holdings.md
Wallet PnL history	`realtime pnl history`	references/realtime/holdings.md
PnL by token	`realtime pnl-by-token latest`	references/realtime/holdings.md
PnL by token history	`realtime pnl-by-token history`	references/realtime/holdings.md

If allium <subcommand> --help returns "no such command," upgrade the CLI — see references/setup.md.

Common Tokens

Don't guess addresses. Use these:

Token	Chain	Address
ETH	ethereum	`0x0000000000000000000000000000000000000000`
WETH	ethereum	`0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2`
USDC	ethereum	`0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48`
USDC	base	`0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913`
cbBTC	ethereum	`0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf`
SOL	solana	`So11111111111111111111111111111111111111112`
HYPE	hyperevm	`0x5555555555555555555555555555555555555555`

Chain names are lowercase. ethereum, base, solana, arbitrum, polygon, hyperevm.

Global Flags

Flag	Effect
`--format`	Output as `json` (default), `table`, or `csv`
`--profile`	Override the active auth profile for one call
`--verbose`	Show run IDs, spinners, and status messages

Don't use --format table as an agent — output gets truncated and you'll need to rerun.

Best Practices

Batch requests — --chain/--token-address flags are repeatable for multiple tokens in one call
Use --format json — pipe into jq for structured post-processing
Track spend — allium mp cost shows total; allium mp cost list for itemized history
Handle 429 — wait 1 second, then retry
Switch profiles — allium auth use <name> to change active auth

Endpoint Costs

Explorer

Command	Cost per call
`explorer schemas browse`	$0.01
`explorer schemas search`	$0.01
`explorer docs browse`	$0.01
`explorer docs search`	$0.01
`explorer run-sql`	$0.01
`explorer run`	$0.01
`explorer create-query`	free (API-key only)

Realtime

Command	Cost per call
`realtime prices latest`	$0.02
`realtime prices at-timestamp`	$0.02
`realtime prices history`	$0.02
`realtime prices stats`	$0.02
`realtime tokens search`	$0.03
`realtime tokens chain-address`	$0.02
`realtime tokens list`	$0.03
`realtime balances latest`	$0.01
`realtime balances history`	$0.01
`realtime holdings history`	$0.01
`realtime transactions`	$0.03
`realtime positions list`	$0.01
`realtime pnl latest`	$0.01
`realtime pnl history`	$0.01
`realtime pnl-by-token latest`	$0.01
`realtime pnl-by-token history`	$0.01

Batch calls (multiple --chain/--token-address pairs) cost the same as a single pair.

References

File	When to read
explorer.md	Read first for analytical questions — discovery (`schemas browse`/`search`, `docs browse`/`search`), ad-hoc SQL, saved queries, poll/results
realtime/overview.md	Read first for realtime questions — supported chains, errors, pagination, conventions
realtime/prices.md	Token prices (current, history, stats, timestamp)
realtime/tokens.md	Token lookup (list, search, by address)
realtime/wallets.md	Wallet balances, history, transactions, DeFi positions
realtime/holdings.md	Holdings history, PnL by wallet/token
setup.md	CLI install + auth setup

Comments

Markdown supported

Details

Author: allium-labs
Repository: allium-labs/skills
Category: Data & databases
Installs: 109
GitHub stars: 0

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.7k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

837.7k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

836.2k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

720.7k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).