
built an ai tool that creates a dune dashboard for any smart contract
i built onchainwizard.ai because analyzing smart contracts on Dune usually takes too many manual steps.
normally the flow is: find the contract, get the ABI, look for decoded tables, write SQL, debug the schema, build charts, then repeat for every new contract.
so i made a tool where you can paste any EVM smart contract address, pick a chain, and it automatically generates a Dune dashboard.
how it works:
- fetches the contract ABI
- detects the important events and functions
- finds matching decoded Dune tables when available
- generates Dune SQL for useful analytics
- creates charts for activity, users, events, and contract behavior
- shows decoded event logs and wallet/user segmentation
- supports chains like Ethereum, Base, Arbitrum, Optimism, Polygon, BNB Chain, and Avalanche
the hardest part was not just generating SQL, but generating SQL that actually tells you something useful about the contract. a dashboard full of raw logs is easy; a dashboard that helps you understand usage, activity, and users is the real problem.
project: https://onchainwizard.ai