Powering lightning fast crypto analytics

DuneSQL is the only query engine custom built for blockchain data

Try Query Engine View docs

0x-encoding

When querying byte arrays directly.

Base58 support

Native support for working with Bitcoin and Solana.

Full precision

Wei-level calculations via UINT256 and INT256.

Trino based

Exceptional performance querying large datasets.

UDF support

Custom logic with user-defined functions.

Key features

DuneSQL shines with unique blockchain capabilities:

Varbinary Data Types

Store blockchain specifics like addresses and hashes efficiently.

Uint256 + Int256 Support

Essential for blockchain’s large numerical data.

Columnar Storage

Optimizes read speed by organizing data by columns.

Query Views

Enables complex query construction and reusability.

Materialized Views

For enhanced query performance through pre-computed results.

LiveFetch NEW

This feature brings the power of the web directly to your queries. Enrich your analyses without leaving the SQL environment. Pull data from ANY public or private API!

Imagine fetching the latest coin lists from CoinGecko or invoking remote procedure calls, all with a simple SQL query. Perfect for users looking to blend external insights with Dune’s rich datasets.

Scalable Deployment

Easily adjust the credit usage to adapt to your queries complexity and speed requirements. Large cluster size is available on higher plan tiers. Upgrade your plan to speed up your more complex workloads.

Bar chart showing hosted blockchain data on Dune.

Dune API

Explore the API

The most reliable blockchain API in crypto. Built for developers,
by developers - Supercharge your analysis with our unified crypto data API, enabling you to achieve tasks 100 times faster.

Effortlessly upload any desired data onto Dune's platform.

Streamline your workflows with the powerful CRUD API.

Transform any query into a limitless API endpoints and actionable data.

Dune is amazing as a monitoring tool! The new API is even more powerful for research and business analytics.

Greg Shestako

Data Analyst

Dune brings critical infrastructure and expertise, transforming on-chain data into meaningful industry insights.

Kevin Tharayil

Chief of Staff

Without Dune, we would need to build another Dune internally.

Michael Silberling

Data Analyst

Dune empowers us to provide cutting-edge insights and bring transparency to everyone.

Tom Wan

Digital Asset Strategy

Dune makes analysis and usage of Polkadot much more accessible.

Robert Habermeier

—

Co Founder

Visualization is a key factor in making technology tangible to most people. This deep integration of Polkadot data into Dune is a key step that makes analysis and consequently usage of Polkadot much more accessible.

Robert Habermeier

—

Co Founder

Outside of Dune's AI feature, theres little to no user experience improvements using LLMs in crypto.

Moses

—

@defi_moses

Ready to get started?

Individuals + Small Teams

Create and explore queries, dashboards and trends with 500,000+ data analysts.

Get started for free

Enterprise

Tailored solutions designed for the largest crypto teams and premier organizations.

Learn more