dune-analytics-api
lz-web3 제작
Browser & Automation요약
Dune Analytics API for blockchain data queries.
설명
이 스킬이 하는 일
Queries, analyzes, and uploads blockchain data via the Dune Analytics API. Covers EVM and Solana chains, DEX trade analysis, wallet tracking, SQL optimization for DuneSQL (Trino), and CSV/NDJSON data uploads. Includes scripts for common operations and reference docs to avoid known table pitfalls.
Bundles scripts, reference docs, and anti-pattern guidance together so common mistakes like inflated volume from dex.trades or missing Solana deduplication are caught before they reach production.
사용 시점
- Tracking a wallet's trading volume across EVM chains
- Analyzing DEX activity for a specific token or protocol
- Uploading a CSV of wallet addresses to query against on-chain data
- Finding and inspecting decoded event tables by contract address
- Running parameterized Dune queries and monitoring credit usage
예시 워크플로
User asks: Show me the last 7 days of trading volume for a specific wallet on Ethereum
- 1
Read wallet-analysis.md and common-tables.md references to select correct tables
- 2
Identify dex_aggregator.trades as the correct table for user-level wallet volume
- 3
Write DuneSQL query filtering by wallet address and date range
- 4
Execute query via dune_query.py or DuneClient with is_private=True
- 5
Return results with credits consumed and data freshness note
Table of daily trading volume in USD for the wallet over the past 7 days
요구 사항
- DUNE_API_KEY environment variable
- Dune Analytics account (free tier supports saved query execution; Plus plan required for direct SQL execution via run_sql)
설치
clawhub install lz-web3/dune-analytics-apiCLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.