Spellbook (Dune)
Open-source data transformation layer for Dune Analytics built on dbt.
Best for: Web3 data engineers and advanced Dune analysts who want to contribute to or leverage standardized blockchain data models for cross-protocol analytics.Spellbook is Dune Analytics' open-source data transformation framework, built on dbt (data build tool). It provides a community-maintained library of standardized, normalized blockchain data models called "spells" that abstract raw on-chain data into clean, analytics-ready tables used across Dune dashboards.
The key value of Spellbook is standardization: instead of every Dune analyst writing their own SQL to decode Uniswap events or normalize DEX trades, Spellbook provides shared models (like dex.trades) that aggregate and normalize DEX trading data across dozens of protocols and chains into a single queryable table.
Spellbook runs on GitHub and follows an open contribution model. Anyone can submit new spells or improve existing ones via pull requests. The dbt-based approach means data engineers with traditional data warehouse backgrounds can contribute using familiar tooling.
Pricing
Open-source and free. Runs on top of a Dune Analytics subscription.
Chains Supported
All chains supported by Dune (Ethereum, Base, Arbitrum, Optimism, Solana, BNB Chain, and many more)
- Querying normalized DEX trade data across all protocols
- Building reusable data models for Dune dashboards
- Contributing protocol integrations to open-source blockchain data
- Standardizing token, NFT, and DeFi data across chains
- Learning blockchain data engineering via open-source contributions
