# duneanalytics/spellbook

SQL views for Dune

Repository: https://github.com/duneanalytics/spellbook
Canonical: https://ross.abutalabs.com/products/spellbook
Language: Python
License: NOASSERTION
License Family: other
Last push: 2026-08-26T14:57:59+00:00

## Health v2 (maintenance only)
Score: 67/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 8, longevity 100
- inputs: {"age_days": 2406, "days_push": 7, "days_rel": 548, "gap_med": null, "n_releases_24m": 1}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1513, forks 1406 (observed 2026-08-28T04:04:56.270097+00:00)

## What it is
Spellbook is a community-maintained collection of dbt SQL models that define curated, decoded datasets (like dex.trades and NFT data) on Dune Analytics' blockchain data platform. Contributors write SQL transformations that Dune runs to produce standardized tables for crypto analytics.

## Use cases
- query standardized DEX trade data on Dune
- build curated NFT marketplace datasets
- contribute SQL models for blockchain analytics
- run dbt transformations on DuneSQL
- get clean decoded tables for token and protocol analysis

## When to choose
- you need reliable, community-vetted blockchain datasets on Dune
- you want to contribute SQL transformations to Dune's curated tables
- you're analyzing DeX, NFT, or Solana data via Dune

## When to avoid
- you're a Dune enterprise customer who can run a private dbt project via the dbt Connector
- you need data outside Dune's platform
- you want a general-purpose dbt project unrelated to blockchain data

## Facets
- artifact type: dataset
- maturity: active
- function: etl, database, developer-tools
- domain: blockchain, analytics
- platform: python, cloud, self-hosted
- tags: dbt, sql, dune, blockchain-analytics, data-transformations, web3, cryptocurrency, data-engineering

## Member repositories
- duneanalytics/spellbook (main) score 67

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:56.270097+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:32:15.587099+00:00, confidence not recorded.
  - readme: https://github.com/duneanalytics/spellbook (fetched 2026-08-28T04:04:56.270097+00:00, sha 169c9dd4a7cd)
- Data as of 2026-08-30T08:39:29.467469+00:00.