dune-sim-onchain-analytics
Standalone skill for on-chain analytics and product work with Dune-choose Sim realtime APIs (EVM and SVM including Solana) vs Dune Analytics SQL, design CU-aware flows, subscriptions and dashboards, and safe key handling. Use when building or analyzing with Dune Sim, wallet or token intelligence, multichain balances and activity, or SQL over Dune datasets-not for legal sanctions conclusions or exposing API keys in browsers.
- License 许可
- Apache-2.0
- 最近更新
- 2026-11-13
- Stars
- ★ 3
- Forks
- 1
01 前言 Front Matter
- name
- dune-sim-onchain-analytics
- description
- Standalone skill for on-chain analytics and product work with Dune-choose Sim realtime APIs (EVM and SVM including Solana) vs Dune Analytics SQL, design CU-aware flows, subscriptions and dashboards, and safe key handling. Use when building or analyzing with Dune Sim, wallet or token intelligence, multichain balances and activity, or SQL over Dune datasets-not for legal sanctions conclusions or exposing API keys in browsers.
03 SKILL.md 正文
Dune Sim and Dune Analytics - on-chain analytics skill
This skill is the primary home for Dune-powered workflows in blockint: how to think, what to call when, and how to ship analytics that combine realtime Sim data with historical SQL where appropriate. It is not a thin link list-use it to structure tasks; open docs.sim.dune.com/llms.txt and openapi.json for exact parameters and auth as you implement.
Educational and integration guidance-users remain responsible for API keys, billing, and Terms.
Mental model: two engines
| Engine | Best for | Typical outputs |
|---|---|---|
| Dune Sim | Live wallet and token state-balances, activity feeds, transactions, NFT collectibles, DeFi positions, stablecoin views, webhook subscriptions | Apps, agents, alerts, “what does this address hold / do now” |
| Dune Analytics API | Historical exploration-SQL over Dune’s curated blockchain tables | Research, cohorts, backtests, dashboards backed by queries |
Rule of thumb: Need streaming or low-latency address/token views across many EVM chains or SVM (Solana / Eclipse, etc.) → start with Sim and chain-specific docs under chains/. Need long-horizon or custom aggregations across Dune SQL models → Analytics API and query execution docs.
When to use which surface (decision flow)
- Single address or small set - balances, recent activity, NFTs, token metadata → Sim EVM or SVM endpoints (see overviews below).
- Ongoing monitoring - balance or activity changes for a watchlist → Subscriptions / webhooks (create, update addresses, lifecycle per docs).
- Token distribution or “top holders” style - Sim token holders / related EVM docs; confirm spam / filtering parameters (e.g. exclude low-liquidity noise) in live API reference.
- Cross-wallet analytics, custom metrics, or historical slices - execute or manage SQL via Dune Analytics API; combine results with Sim in the application layer if needed.
- Multichain - confirm chain ID and supported chains in docs before assuming parity across EVM L2s or SVM deployments.
EVM vs SVM (Solana-class)
- EVM: Broad endpoint family-activity, balances, transactions, collectibles, DeFi positions, stablecoins, subscriptions, token info / holders. Use EVM overview as the map.
- SVM: SVM overview - realtime balances and transactions for Solana-class addresses; align address encoding and chain scope with docs. For Solana-only RPC-depth debugging, pair with solana-tracing-specialist and provider docs (e.g. Helius)-Sim is product API, not a full RPC replacement.
Operations: CUs, errors, keys
- Compute Units (CUs) - Billing is CU-based; estimate cost per workflow (polling vs webhooks, batch sizes). Read Compute Units before production sizing.
- Errors - Implement retries with backoff per Error handling; never treat 429/5xx as permanent failure without reading response bodies.
- Secrets - No Sim API keys in front-end bundles. Use server routes or Cloudflare proxy pattern from docs.
- Spam / noise - Use documented token filtering /
exclude_spam_tokens-style controls where available; labels and prices change-revalidate for reporting.
Agent and IDE integration
- Agent reference - drop-in file for Claude Code, Cursor, Codex, Gemini CLI, etc.
- Build with AI -
llms.txt, Markdown pages, OpenAPI for tool-calling designs.
How this skill fits blockint
| Task | Pair with |
|---|---|
| Abstract “what is blockchain analytics” | blockchain-analytics-operations |
| Solana forensic tracing patterns | solana-tracing-specialist |
| Full investigator narrative | on-chain-investigator-agent |
| Sanctions / compliance screening products | range-ai-investigation-playbook, chainalysis-sanctions-screening - different stacks; do not conflate with Dune outputs |
Guardrails
- Compliance - Dune data supports research; sanctions and legal outcomes need designated tools and counsel.
- Attribution - Wallet labels and heuristics can be wrong; separate fact (chain events) from inference (entity names).
- ToS - Respect Dune’s terms, rate limits, and attribution for published queries or embeds.
Authoritative specs (keep open while coding)
| Resource | URL |
|---|---|
| Doc index | docs.sim.dune.com/llms.txt |
| Quickstart | docs.sim.dune.com/index.md |
| Dune Analytics API (SQL) | docs.sim.dune.com/dune-analytics-api.md |
| OpenAPI | docs.sim.dune.com/openapi.json |
EVM: overview · activity · balances · transactions · subscriptions · supported chains · token filtering
SVM: overview · balances · transactions
04 同仓库更多 Skills
bastion
Programmable Trust Runtime for Autonomous Systems. Orchestrates identity, policy, privacy, durable execution, and multi-chain settlement.
web2-api-firewall-administrator
Guides configuring Bastion Web2 API adapter policies for the Trust Runtime. Covers endpoint allowlists, provider budgets, rate limits, content inspection (PII/secrets detection), header filters, and OpenAPI spec-based auto-configuration. Use when configuring API call security for AI agents, setting provider spending caps, inspecting outbound API traffic, or setting up the Web2 adapter.
transaction-screening-workflow-concepts
Educational map of transaction-centric compliance screening-transfer as the atomic unit, deposit vs withdrawal direction, single and CSV import, transaction list and detail views, per-transfer screening, rescreen, and STR-style exports. Use when the user asks how monitoring UIs treat tx hashes, directions, or regulatory reporting hooks-not for legal filing advice or evading reporting.
solana-tracing-specialist
Guides Solana-specific on-chain forensics-ATA resolution, SPL instruction parsing, transaction history via RPC and indexers (e.g. Helius-style APIs), fund-flow graphs, Solana clustering heuristics, and program authority review. Use when the user investigates Solana wallets, SPL tokens, DEX/Jito flows, rug or phishing patterns on Solana, or needs evidence-structured tracing reports with public data only.
solana-onchain-intelligence-resources
Companion to blockint-skills Solana work-official doc indexes and stacks for RPC/indexers, sanctions and address intel MCP, web research, agent payments, graph UIs, Solana Foundation dev skills, Solana Policy Institute (policy/regulatory education), optional open-source Scrapy collection (BlockchainSpider), Impersonator Solana (dApp dev/testing), coral-xyz sealevel-attacks (security pattern examples), Neodyme Solana Security Workshop (workshop.neodyme.io), and Osec Solana auditor introduction blog (osec.io). Use when the user needs pointers to Helius, Range AI, Tavily, PayAI x402, React Flow, Solana.com skills, or SPI alongside on-chain forensics-not as a substitute for reading current provider docs, legal counsel, or API keys.
solana-defi-vulnerability-analyst-agent
Guides discovery and documentation of Solana DeFi protocol risks from public code and chain state-Anchor/native programs, PDAs, CPIs, oracles, pools, SPL mechanics, and historical tx reconstruction. Use when the user asks for Solana program security review, DeFi vulnerability triage, PDA or CPI safety, oracle or liquidity-pool risk, launchpad/bonding-curve issues, or evidence-backed severity findings without exploits or private keys.