Dune Analytics

Dune Analytics is an onchain data analytics platform launched in 2018, designed to allow analysts, researchers, and developers to query blockchain data using standard SQL syntax. The platform provides a browser-based query editor connected to indexed blockchain datasets covering multiple supported networks, enabling users to retrieve transaction histories, wallet activity, protocol metrics, and smart contract event data without setting up local data infrastructure or building custom indexing pipelines

Dune operates under a mixed licensing model — the core platform and query engine are proprietary, while specific tooling such as the Spellbook data model repository and the official Python client library are maintained as open-source projects on GitHub under the duneanalytics organization. Queries and dashboards published on Dune are publicly visible and can be forked by other analysts, enabling a shared body of onchain analytics resources to accumulate across the community over time

The primary interface on Dune is a browser-based SQL editor where analysts write queries directly against indexed blockchain tables. Each supported chain is represented as a collection of database tables — covering raw blocks, transactions, logs, traces, and decoded contract events — allowing analysts to filter, aggregate, and join onchain data using standard SQL without handling raw RPC calls or managing a self-hosted data warehouse

Query results on Dune can be visualized as charts, tables, and metric counters and assembled into named dashboards accessible via a public URL. Dashboards serve as published analytics reports covering protocol activity, token flows, user behavior, and market metrics, with each embedded query viewable as an independent visualization. The public dashboard model allows analysts to share their work broadly without requiring viewers to hold a Dune account or write queries themselves

The SQL query engine on Dune is the central access layer for all indexed onchain data, supporting cross-table joins within a single query where compatible data structures exist across chains. Blockchain-specific tables are organized by network and contract type, with decoded event tables flattening raw Solidity log output into named, human-readable column structures for known protocol contracts. This decoding layer substantially reduces the SQL complexity required to extract meaningful signal from protocol-level event data compared to working directly with raw hexadecimal transaction bytes

Spellbook is an open-source repository of community-maintained SQL view definitions published on GitHub under the duneanalytics organization, providing curated data model layers on top of Dune's raw and decoded blockchain tables. Analysts and development teams contribute SQL transformation logic covering DeFi protocol metrics, NFT activity tracking, DEX volume standardization, and other cross-protocol aggregations — creating reusable curated datasets that are materialized on the platform and available to all users. The open-source contribution model means that improvements to cross-protocol data models are visible to and auditable by the community

Dune provides a REST API that allows external applications and data pipelines to execute saved queries and retrieve their results in JSON format programmatically. The API is documented at docs.dune.com/api-reference/overview/introduction and supports query execution, result retrieval by query ID, and parameterized query input for queries configured with variable fields. A Python SDK is available at docs.dune.com/api-reference/sdks/python, and the official Python client library is published on GitHub at github.com/duneanalytics/dune-client, providing a structured programmatic interface for integrating Dune query results into automated reporting workflows and data pipelines

The APIs and Connectors offering at dune.com/apis-and-connectors extends Dune's data access model beyond the REST API to include integrations with external data engineering and analytics platforms. These connectors enable teams to route Dune query outputs into third-party data warehouses, BI tools, and pipeline orchestration systems, allowing Dune to function as a blockchain data source within a broader data infrastructure stack rather than as a standalone query interface. This integration path serves organizations that need onchain data to coexist alongside off-chain business metrics in a unified reporting and analytics environment

Dune Analytics serves a wide range of onchain data use cases: DeFi researchers query DEX volume, liquidity pool composition, and lending protocol utilization directly from indexed event data to monitor protocol activity over time; NFT market participants analyze minting patterns, secondary sales volumes, and holder distribution across specific collections on supported chains; protocol teams publish dashboards displaying their on-chain activity metrics for community transparency and ecosystem reporting; data engineers integrate Dune query results into downstream systems via the REST API or Python SDK to build automated reporting pipelines; and ecosystem analysts combine Spellbook data models with raw decoded tables to construct cross-protocol comparative studies spanning multiple blockchain networks

Developer integration with Dune is supported through the REST API documented at docs.dune.com/api-reference/overview/introduction, the Python SDK available at docs.dune.com/api-reference/sdks/python, and the official Python client library published on GitHub at github.com/duneanalytics/dune-client. The API supports query execution by saved query ID, parameter injection for templated queries, and JSON-formatted result retrieval for downstream application consumption. Developers building onchain analytics applications, automated reporting systems, or data pipeline integrations can use the Dune API as a managed blockchain data retrieval layer without maintaining independent node infrastructure or raw event indexing pipelines

Dune maintains a Trust Center at trust.dune.com covering platform security practices, compliance documentation, and data handling policies relevant to users, enterprise teams, and institutional integrators. As a data analytics and query platform rather than a smart contract protocol, Dune does not require wallet connections for read-only query and dashboard activity and does not custody user assets. Users and developers integrating Dune's API should review the Trust Center documentation, apply standard API key management practices for credential security, and evaluate the platform's data retention and access control policies against their specific compliance requirements

Dune Analytics provides a mature onchain data platform combining a SQL-based query editor, multi-chain dataset coverage, public dashboard publishing, community-curated data models through Spellbook, and developer access via REST API and Python SDK. The platform's combination of managed query infrastructure with open-source community data models makes it applicable for individual analysts, DeFi research teams, and engineering organizations building onchain data workflows. Teams evaluating Dune should review the API reference documentation, available chain and protocol table coverage, and the Trust Center to assess whether the platform's managed access model fits their analytics, compliance, and integration requirements