onchain-analysis
Installation
SKILL.md
On-Chain Analysis Skill
Analyze any verified EVM smart contract by pasting its address. The skill runs a full analysis pipeline:
- ABI Fetching — Retrieves the verified ABI from Etherscan (or accepts a manual ABI)
- Usage Discovery — Queries Dune to find which methods are most called, by whom, and with what value
- Decoded Data Tables — AI generates DuneSQL queries using
decode_evm_function_call()to build raw decoded data tables on Dune - Analytics Generation — A second AI pass generates 6-10 visualization queries (stats, time series, bar charts, pie charts) from the decoded tables
- Execution — All queries are executed on Dune and results returned as structured JSON
When to Use
- User asks "analyze this contract" or "what does this contract do"
- User wants on-chain analytics, usage stats, or dashboards for a smart contract
- User provides a contract address and wants to understand its activity
- User asks about transaction patterns, caller behavior, or function usage
- User wants to compare function usage or identify top callers
- User asks "who uses this contract" or "how popular is this contract"