Dune Analytics

Dune is an onchain analytics platform launched in 2018 that enables analysts, researchers, and developers to query indexed blockchain data using standard SQL. It offers a browser-based editor connected to multi-chain datasets, allowing users to analyze transactions, wallet activity, protocol metrics, and smart contract events without managing local infrastructure or custom indexing.

Dune uses a mixed licensing approach where the core platform remains proprietary while Spellbook data models and official client libraries are open-source on GitHub under the duneanalytics organization. Published queries and dashboards are public by default and can be forked, fostering a growing community library of shared onchain analytics.

Dune's main interface is a browser-based SQL editor for writing queries against indexed blockchain tables. Supported chains appear as structured database schemas with raw blocks, transactions, logs, traces, and decoded events, letting analysts filter, join, and aggregate data using familiar SQL without direct RPC calls or self-hosted warehouses.

Results can be turned into charts, tables, and counters, then combined into shareable public dashboards accessible by URL. These dashboards function as published reports on protocol activity, token flows, user behavior, and market metrics, with individual queries viewable as standalone visualizations that require no account for viewers.

Dune's SQL engine supports cross-table joins and organizes blockchain-specific tables by network and contract type, with decoded event tables converting raw logs into readable columns. This abstraction layer greatly simplifies extracting protocol insights compared to parsing raw hexadecimal data directly.

Spellbook is Dune's open-source GitHub repository of community-curated SQL models that build reusable views and tables on top of raw and decoded data. Contributors add transformations for DeFi metrics, NFT tracking, DEX standardization, and cross-protocol aggregations, which are materialized and available platform-wide under an auditable open-source model.

Dune offers a comprehensive Analytics API for programmatically executing saved queries, retrieving JSON results, and managing data. Official SDKs for Python, TypeScript, and Go (with an execute() helper for polling and pagination) are available, along with documentation at docs.dune.com, enabling integration into automated pipelines and reporting workflows.

Beyond the core REST API, Dune provides connectors and integrations such as Datashare for streaming curated data into Snowflake, BigQuery, or Databricks, plus links to external BI tools via Trino and other pipelines. These options let teams incorporate onchain data into broader data stacks alongside off-chain metrics.

Dune supports diverse onchain analytics needs: DeFi researchers track DEX volumes, liquidity, and lending metrics; NFT participants examine mints, secondary sales, and holder distributions; protocol teams publish transparent activity dashboards; data engineers build automated pipelines with the API and SDKs; and analysts leverage Spellbook models alongside raw tables for cross-chain comparative studies.

Developers integrate via the Analytics API at docs.dune.com, official SDKs for Python, TypeScript, and Go, and the dune-client library on GitHub. The API supports executing queries by ID or raw SQL, parameter handling, result retrieval in JSON, and usage monitoring. It serves as a managed layer for onchain data access without requiring independent nodes or indexing infrastructure.

Dune maintains a Trust Center at trust.dune.com detailing security practices, compliance, and data policies. As a query and analytics platform, it does not require wallet connections for read-only use and does not custody assets. Integrators should review the Trust Center, follow standard API key practices, and align data policies with their compliance needs.

Dune delivers a mature onchain data solution with SQL querying, coverage of 100+ chains, public dashboards, community Spellbook models, and robust API/SDK access. Its managed infrastructure paired with open data models suits individual analysts, research teams, and organizations building analytics workflows. Evaluators should consult the API docs, chain coverage, and Trust Center to match the platform to their requirements.