Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics.

MITAuto-check passedDatabases

Install Dune

skills CLI
$ npx skills add TermiX-official/cryptoclaw --skill dune -a claude-code

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

GitHub CLI
$ gh skill install TermiX-official/cryptoclaw dune --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/TermiX-official/cryptoclaw.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/dune .claude/skills/dune && 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
dune
GitHub stars
100
Token cost
~1.3k tokens
SKILL.md length
463 words
Files
1
Skills in repo
33
Repo updated
First seen
Licence
MIT

At a glance

Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics.

  • Works in 3 steps: Execute a Query → Check Execution Status → Get Results
  • Tasks that involve Smart contracts
  • SKILL.md covers Base URL, Core Workflow, Useful Public Query IDs and Writing Custom Queries, plus 3 more sections
  • Reaches api.dune.com; needs DUNE_API_KEY

What it does

Dune is an agent skill from TermiX-official/cryptoclaw. Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics.

Its SKILL.md is about 1.3k 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, covering Smart contracts and SQL. It works with SQL, Ethereum and Arbitrum. The licence is MIT.

When your agent uses it

  • Tasks that involve Smart contracts
  • Tasks that involve SQL

Example prompts

  • “/dune”

Requirements

  • A credential in DUNE_API_KEY

Workflow steps

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

  1. Execute a Query
  2. Check Execution Status
  3. Get Results

What it can do on your machine

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

    No scripts in the folder and no shell commands in SKILL.md (its code samples are json and sql).

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

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • api.dune.com

    Also links to:

    • dune.com

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

  • Credentials

    Names these keys or tokens, usually read from environment variables:

    • DUNE_API_KEY

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

Context cost

Dune loads about 1.3k tokens when it runs. Until then it costs about 23 tokens; SKILL.md has 463 words of instructions outside code blocks.

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

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 TermiX-official/cryptoclaw at commit 9e1c91b, republished under its MIT licence (© TermiX-official). 463 words, ~1,338 tokens.

Download SKILL.mdSave it as .claude/skills/dune/SKILL.md (or your agent's skills folder).
name
dune
description
Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics.

Dune Analytics API

Execute SQL queries on blockchain data, fetch dashboard results, and access curated datasets via the Dune API.

Base URL

https://api.dune.com/api/v1

Requires API key: set DUNE_API_KEY. Free tier available at https://dune.com/settings/api

Pass via header: X-Dune-API-Key: {key}

Core Workflow

1. Execute a Query
POST /query/{query_id}/execute

Body (optional filters):

json
{
  "query_parameters": {
    "wallet_address": "0x...",
    "token_address": "0x..."
  }
}

Returns execution_id for polling.

2. Check Execution Status
GET /execution/{execution_id}/status

States: QUERY_STATE_PENDING, QUERY_STATE_EXECUTING, QUERY_STATE_COMPLETED, QUERY_STATE_FAILED

Poll every 2-3 seconds until completed.

3. Get Results
GET /execution/{execution_id}/results

Returns rows as JSON with column metadata. Use ?limit=100&offset=0 for pagination.

Shortcut: Get Latest Results
GET /query/{query_id}/results

Returns cached results from the last execution without re-running. Fast and free of execution credits.

Useful Public Query IDs

Query IDDescription
3237721Top DEX traders by volume (7d)
3105506Whale token transfers (24h)
2030664Stablecoin flows by chain
1847958NFT marketplace volume comparison
3532352Bridge volume across chains
2474310Gas spent by protocol (Ethereum)

Note: Public query IDs may change or become unavailable. Verify before relying on them.

Writing Custom Queries

Create a Query
POST /query

Body:

json
{
  "name": "My Query",
  "query_sql": "SELECT * FROM ethereum.transactions WHERE \"from\" = {{wallet_address}} ORDER BY block_time DESC LIMIT 100",
  "is_private": false
}
Key Tables
TableChainDescription
ethereum.transactionsETHAll transactions
bnb.transactionsBSCBSC transactions
polygon.transactionsPolygonPolygon transactions
arbitrum.transactionsArbitrumArbitrum transactions
erc20_ethereum.evt_TransferETHERC-20 transfer events
erc20_bnb.evt_TransferBSCBEP-20 transfer events
dex.tradesMultiAggregated DEX trades
nft.tradesMultiAggregated NFT trades
prices.usdMultiToken prices (hourly)
tokens.erc20MultiToken metadata
DuneSQL Syntax Notes
  • DuneSQL is based on Trino (Presto fork)
  • Use double quotes for column names with special chars: "from", "to"
  • Byte arrays (addresses): 0x prefix works, use LOWER() for case-insensitive matching
  • Timestamps: block_time is TIMESTAMP type, use NOW() - INTERVAL '7' DAY for ranges
  • Aggregations: standard SQL — SUM(), COUNT(), AVG(), GROUP BY
  • Use LIMIT always — avoid unbounded queries
Example Custom Queries

Wallet transaction count (last 30 days):

sql
SELECT COUNT(*) as tx_count, SUM(value / 1e18) as total_eth
FROM ethereum.transactions
WHERE "from" = {{wallet_address}}
  AND block_time > NOW() - INTERVAL '30' DAY

Top tokens by transfer volume (24h):

sql
SELECT t.symbol, COUNT(*) as transfers, SUM(evt.value / POW(10, t.decimals)) as volume
FROM erc20_ethereum.evt_Transfer evt
JOIN tokens.erc20 t ON t.contract_address = evt.contract_address AND t.blockchain = 'ethereum'
WHERE evt.evt_block_time > NOW() - INTERVAL '1' DAY
GROUP BY t.symbol
ORDER BY transfers DESC
LIMIT 20
Show full SKILL.md (181 more words)Show less

API Limits (Free Tier)

  • 10 query executions per day (re-execute)
  • 250 datapoints per result
  • Cached results (/query/{id}/results) do not count against execution limits
  • Prefer cached results when freshness is not critical

Usage Notes

  • Prefer cached results (GET /query/{id}/results) over re-executing queries to conserve credits
  • For wallet-specific analysis, pass the address as a query_parameter rather than hardcoding
  • Always use LIMIT in custom SQL to avoid timeouts and large payloads
  • Combine with debank for real-time portfolio data and defillama for protocol-level TVL
  • When building custom queries, test with small limits first
  • Present results in tables or summaries — raw Dune output can be verbose

Example Interactions

User: "Show top DEX traders this week" → Fetch cached results from query 3237721, present top 10 by volume

User: "How many transactions has my wallet done?" → Execute custom query with wallet_address parameter, report count and total value

User: "What are the biggest token transfers today?" → Fetch cached whale transfer query, present top movers

User: "Write a query to find all USDT transfers over $100k on BSC" → Create custom SQL on erc20_bnb.evt_Transfer, filter by USDT address and amount threshold

© TermiX-official, MIT. 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 skills/dune of TermiX-official/cryptoclaw.

Open the folder on GitHubat commit 9e1c91b

Compare with similar skills

Dune 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.

Dune compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Dune this skillTermiX-official/cryptoclaw100—~1.3kAutomated safety check: PassMIT
SurfBlockRunAI/ClawRouter6.6k—~4kAutomated safety check: PassMIT
Trading Evmalsk1992/CloddsBot2.9k—~1.9kAutomated safety check: PassMIT
ClankerBankrBot/skills1.2k1 repos~3kAutomated safety check: NotesNone
Use Usdccirclefin/skills155—~2.4kAutomated safety check: NotesApache-2.0
Ethskillsaustintgriffith/ethskills294—~3kAutomated safety check: PassNone

Similar skills

  • Surf

    BlockRunAI/ClawRouter

    Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls.

    6.6k GitHub stars~4k tokensUpdated 3 days ago
    Business, Finance & HRAuto-check passed
  • Trading Evm

    alsk1992/CloddsBot

    Trade tokens on EVM chains - Uniswap V3, 1inch on Ethereum, Arbitrum, Optimism, Base, Polygon

    2.9k GitHub stars~1.9k tokensUpdated 6 days ago
    Backend & APIsAuto-check passed
  • Clanker

    BankrBot/skills

    Deploy ERC20 tokens on Base, Ethereum, Arbitrum, and other EVM chains using the Clanker SDK.

    1.2k GitHub starsUsed in 1 repo~3k tokens
    DevOps & CloudAuto-check: notes
  • Use Usdc

    circlefin/skills

    USDC is Circle's stablecoin deployed across multiple blockchain ecosystems including EVM chains (Ethereum, Base, Arbitrum, Polygon, Arc) and Solana.

    155 GitHub stars~2.4k tokensUpdated 23 days ago
    Backend & APIsAuto-check: notes
  • Ethskills

    austintgriffith/ethskills

    A skill your agent uses when a request involves Ethereum, the EVM, or blockchain systems.

    294 GitHub stars~3k tokensUpdated 1 mo ago
    Backend & APIsAuto-check passed
  • Alchemy

    BankrBot/skills

    Blockchain API access via Alchemy. An agent skill from BankrBot/skills.

    1.2k GitHub stars~3.5k tokensUpdated 3 days ago
    Backend & APIsAuto-check passed

More from TermiX-official/cryptoclaw

All 33 skills in this repo
  • Coding Agent

    TermiX-official/cryptoclaw

    Delegate coding tasks to Codex, Claude Code, or Pi agents via background process.

    100 GitHub starsUsed in 8 repos~2.7k tokens
    Auto-check passed
  • Prose

    TermiX-official/cryptoclaw

    OpenProse VM skill pack. An agent skill from TermiX-official/cryptoclaw.

    100 GitHub starsUsed in 3 repos~3.8k tokens
    Auto-check: notes
  • Merge PR

    TermiX-official/cryptoclaw

    Merge a GitHub PR via squash after /preparepr. An agent skill from TermiX-official/cryptoclaw.

    100 GitHub stars~1.2k tokensUpdated 4 mo ago
    Auto-check passed
  • Acp Router

    TermiX-official/cryptoclaw

    Route plain-language requests for Pi, Claude Code, Codex, OpenCode, Gemini CLI, or ACP harness work into either OpenClaw ACP runtime sessions or direct acpx-driven sessions ("telephone game" flow).

    100 GitHub starsUsed in 2 repos~1.9k tokens
    Auto-check passed
  • Review PR

    TermiX-official/cryptoclaw

    Review-only GitHub pull request analysis with the gh CLI. An agent skill from TermiX-official/cryptoclaw.

    100 GitHub stars~1.7k tokensUpdated 4 mo ago
    Auto-check passed
  • Coingecko

    TermiX-official/cryptoclaw

    Query CoinGecko API for prices, market data, trending tokens, and historical charts.

    100 GitHub starsUsed in 1 repo~755 tokens
    Auto-check passed

Questions about Dune

What does Dune do?

Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics. Dune is an agent skill from TermiX-official/cryptoclaw. Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics.

When should I use Dune?

Dune fits situations like: tasks that involve Smart contracts; tasks that involve SQL.

How do I install Dune in Claude Code?

Run `npx skills add TermiX-official/cryptoclaw --skill dune -a claude-code`. Or copy the skill folder (skills/dune in TermiX-official/cryptoclaw) into .claude/skills/dune in your project. Claude Code loads it when a task matches its description.

How do I install Dune in Codex?

Run `npx skills add TermiX-official/cryptoclaw --skill dune -a codex`. Or copy the skill folder (skills/dune in TermiX-official/cryptoclaw) into .agents/skills/dune in your project. Codex loads it when a task matches its description.

Can I use Dune 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 TermiX-official/cryptoclaw --skill dune -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/dune, .gemini/skills/dune, .github/skills/dune and .opencode/skills/dune in your project.

What does Dune need to run?

Going by SKILL.md and its folder, Dune needs credentials named DUNE_API_KEY. Our summary lists: A credential in DUNE_API_KEY.

Does Dune access the network?

SKILL.md names 2 domains. In commands or code: api.dune.com; the agent is likely to contact it when it follows the instructions. As links in the text: dune.com. This is read from the text; nothing was executed.

Is Dune 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 Dune use?

Dune is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Dune use?

About 1.3k tokens (SKILL.md is roughly 5.4k 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 Dune?

Skills that share tags, products or a category with Dune: Surf (BlockRunAI/ClawRouter, 6.6k stars), Trading Evm (alsk1992/CloddsBot, 2.9k stars), Clanker (BankrBot/skills, 1.2k stars) and Use Usdc (circlefin/skills, 155 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Dune?

TermiX-official (a GitHub organization) maintains it in TermiX-official/cryptoclaw, which has 100 GitHub stars. The repository holds 33 skills in this directory. The repository was last updated on May 25, 2026.

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