SKILLEMALL.ai
GitHub ↗ RU Sign in

AC dune-analytics-api

Dune Analytics API skill for querying, analyzing, and uploading blockchain data. Use this skill whenever the user mentions Dune, on-chain data, blockchain analytics, token trading volume, DEX activity, wallet tracking, Solana/EVM transaction analysis, or wants to explore crypto data — even if they don't explicitly say 'Dune'. Also use for: running or creating Dune queries, finding blockchain tables and schemas, uploading CSV/NDJSON data to Dune, optimizing SQL for DuneSQL (Trino), checking token prices or trading pairs, analyzing wallet behavior, or any task involving dex.trades, decoded event logs, or raw blockchain transactions. Triggers on: Dune, blockchain data, on-chain, DEX trades, token volume, Solana transactions, wallet analysis, query optimization, data upload, table discovery, contract address lookup, crypto analytics, DuneSQL.

ClawHub Agent Skills author: LZ-Web3 v2.0.0 MIT-0 13 files body ≈ 1 975 tokens Open the sourceclawhub.ai↗ analyzed 3 d ago

As a process C 59/100 · Has gaps — weak spots: result and completion, inputs and preconditions, running it twice

IntegrationData and analyticstype and topics are labelled automatically from the skill text
Runs in: OpenClaw Claude / Claude Code ChatGPT / Codex Gemini CLI Cursor GitHub Copilot / VS Code Qwen Code Kimi Code CLI Z.ai (GLM) DeepSeek (Deep Code) Mistral Vibe LangChain (deepagents) Goose OpenCode
JSON
Technical rating
A
93/100
safety, quality, tests
Safety 60%
97
Quality 40%
87
Run on models
none yet
Process rating
C
59/100
Has gaps
Result and completion w 14
0
Inputs and preconditions w 11
0
Progress reporting w 2
0
the three weakest of ten parameters · all ten

How to improve

    For the model run — optional
    • A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.

    Guard findings · 3

    ✓ No critical or high findings

    Medium and low: 3
    • low Secrets in code secret-high-entropy-token references/table-discovery.md:225
      High-entropy token-like string (may be an id, hash or a credential) (quoted — discussed, not commanded)
      tables = find_tables_by_contract(client, "0x1f…984", "ethereum")
      quoted
    • low Secrets in code secret-high-entropy-token references/wallet-analysis.md:246
      High-entropy token-like string (may be an id, hash or a credential) (quoted — discussed, not commanded)
      'So11…112',  -- WSOL
      quoted
    • low Secrets in code secret-high-entropy-token references/wallet-analysis.md:247
      High-entropy token-like string (may be an id, hash or a credential) (quoted — discussed, not commanded)
      '0xC0…Cc2'   -- WETH
      quoted

    Files scanned: 12. Evidence is masked. Grey chips explain why severity was lowered.

    Against the Agent Skills spec

    • note frontmatter-key unknown frontmatter key "homepage"

    Process rating: all ten parameters 59/100

    • 0Result and completion. Does not say what the result is
    • 0Inputs and preconditions. Does not say what the process needs to start
    • 0Progress reporting. Says nothing while it works
    • 30Running it twice. 7 mutating operations with no state check
    • 60Tools and files. Uses tools (web) that frontmatter does not declare
    • 70When it triggers. States when to use, but not when not to
    • 100Steps. 5 steps
    • 100Failures and branches. 2 branches, has a failure section
    • 100Consistency. Name and required fields are in place
    • 100Execution cost. Instruction body is 1975 tokens
    • medium 4 test cases, all positive: not one "should refuse" or "should ask first"
    • low No test case covers injection arriving through data

    Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.

    Quality signals

    • +5Description has no quoted example phrases that should trigger the skill
    • +4Description does not say when NOT to use the skill (false activations)
    • +3Description length 850: 120–800 characters recommended
    • +3Output format is not stated: the model decides each time
    • +1No license
    • +2Single-language instructions
    • +4Structure: 11 headings
    • +3Step-by-step instructions: 5 items
    • +4Has examples (4 code blocks)
    • +4Reference files are cited in the instructions (6 of 6)
    • +3All 3 scripts are documented

    Quality base 70; lint remarks subtract, signals add up to 100. Result: 87.

    External checks

    ClawHub: suspicious
    This Dune Analytics skill is legitimate in purpose, but it needs review because it can use a Dune API key to make persistent remote changes and expose public Dune artifacts without strong confirmation safeguards.
    LLM: suspicious (high) · VirusTotal: benign · 28 May 2026