# Dune Docs

> Official documentation for building with Dune's data platform, query engine, and API.

## Docs

- [Dune Docs](https://docs.dune.com/index.md): Dune is the onchain data platform for analytics, data engineering, and application development.
- [Products Overview](https://docs.dune.com/docs/product-comparison.md): Compare Dune's core products: Data Hub and Datashare
- [Changelog](https://docs.dune.com/docs/changelog.md)
- [Data Changelog](https://docs.dune.com/docs/data-changelog.md)

### Use Cases

- [Analytics](https://docs.dune.com/docs/use-cases/analytics.md): Query, visualize, and analyze blockchain data with Data Hub and Datashare
- [Engineering](https://docs.dune.com/docs/use-cases/engineering.md): Transform, model, and pipeline onchain data with dbt, Datashare, and APIs
- [Accounting, Audit & AML](https://docs.dune.com/docs/use-cases/accounting-audit-aml.md): Power transaction monitoring, reconciliation, and compliance workflows with onchain data

### Data Hub

- [Data Hub Overview](https://docs.dune.com/web-app/overview.md): The Dune Data Hub is your central workspace for querying, visualizing, and sharing blockchain data insights.
- [Share and Embed](https://docs.dune.com/web-app/share.md): Share your Dune queries, dashboards, and visualizations via links, social media, or embedded iframes.
- [Search and Discover Content](https://docs.dune.com/web-app/search.md): Find dashboards, queries, analysts, and data across Dune using search, discovery, and your library.
- [Enterprise Plan](https://docs.dune.com/enterprise/data-hub/overview.md): Enterprise features for crypto native or crypto adjacent teams with advanced security, unlimited resources, and dedicated support.

#### Write and Run Queries

- [Query Editor Overview](https://docs.dune.com/web-app/query-editor/index.md): Navigate and use the Dune Query Editor to write, run, and manage SQL queries against blockchain data.
- [Create your first query](https://docs.dune.com/learning/how-tos/create-your-first-query.md): Learn to analyze daily DEX trading volumes across different blockchains
- [Writing Queries](https://docs.dune.com/web-app/query-editor/query-window.md): Write and execute SQL queries against blockchain data using Dune's query editor.
- [Find Data Tables with the Data Explorer](https://docs.dune.com/web-app/query-editor/data-explorer.md): Use the Data Explorer in Dune's query editor to browse, search, and inspect blockchain data tables for your analysis.
- [Using Parameters](https://docs.dune.com/web-app/query-editor/parameters.md): Parameters allow you to implement variables in certain parts of your Query. This is useful if you want to create a Query that you can reuse with different parameters.
- [Query Templates](https://docs.dune.com/learning/how-tos/query-templates.md): Pre-built query templates to jumpstart your Dune journey with common blockchain analytics patterns
- [AI Query Tools](https://docs.dune.com/web-app/dune-ai.md): Use AI-powered tools to generate, edit, and debug SQL queries in the Dune query editor.

#### Visualize and Present Results

- [Create your first visualization](https://docs.dune.com/learning/how-tos/create-your-first-visualization.md): How to create a combination bar chart and line chart to visualize the monthly $ gas spent for your wallet
- [Charts and Graphs](https://docs.dune.com/web-app/visualizations/charts-graphs.md): Create bar charts, line charts, area charts, scatter charts, pie charts, and mixed visualizations from query results.
- [Counters](https://docs.dune.com/web-app/visualizations/counters.md): Display a single key metric prominently using counter visualizations.
- [Tables](https://docs.dune.com/web-app/visualizations/tables.md): Format and customize table visualizations including column alignment, number formatting, and progress bars.
- [Build Dashboards](https://docs.dune.com/web-app/dashboards.md): Create, customize, and schedule interactive dashboards to present your query results and visualizations.

#### Automate and Monitor

- [Schedule Queries and Dashboards](https://docs.dune.com/web-app/query-editor/query-scheduler.md): Schedule queries and dashboards to run automatically at defined intervals to keep your data fresh.
- [Set Up Alerts](https://docs.dune.com/web-app/alerts.md): Configure email and webhook notifications that trigger each time a scheduled query runs.
- [Query Lineage](https://docs.dune.com/web-app/query-editor/query-lineage.md): Visualize and trace all tables, views, and nested query dependencies within a query to understand data relationships efficiently.
- [Version History](https://docs.dune.com/web-app/query-editor/version-history.md): Queries have a version history, where you can compare and revert to previous query versions.

#### Import and Export Data

- [Upload Data](https://docs.dune.com/web-app/upload-data.md): Upload your own data to Dune
- [Export Data](https://docs.dune.com/learning/how-tos/export-data-out.md): Export query results from Dune via CSV download or the API.

#### Decode Smart Contracts

- [How Contract Decoding Works](https://docs.dune.com/web-app/decoding/decoding-contracts.md): Dune decodes smart contract bytecode into human-readable, queryable data tables using contract ABIs.
- [Submission Best Practices](https://docs.dune.com/web-app/decoding/best-practices.md): Best practices for submitting smart contracts for decoding on Dune, covering all contract types and patterns.
- [Contract Submission Guide](https://docs.dune.com/web-app/decoding/short-guide-contract-submission.md): A guide for chains and protocols to submit contracts for decoding on Dune.
- [Solana Program Decoding Submissions](https://docs.dune.com/web-app/decoding/solana-decoding-submissions.md): How to submit Solana programs for IDL decoding on Dune — UI flow, requirements, IDL validation, new vs upgrade submissions, and what to expect.
- [Multichain Decoding](https://docs.dune.com/web-app/decoding/multichain-decoding.md): Consolidate decoded contract data across EVM chains into unified, queryable tables.
- [Decoding FAQs](https://docs.dune.com/web-app/decoding/faqs.md): Frequently asked questions about decoding contracts on Dune.

#### Manage Your Team

- [Teams and Roles](https://docs.dune.com/web-app/teams.md): Create and manage team workspaces, invite members, assign roles, and collaborate on shared queries and dashboards.
- [Organizations](https://docs.dune.com/web-app/organizations.md): Enterprise organizations group multiple teams under one subscription, shared usage, and centralized security and billing controls.
- [Google SSO Domain Restriction](https://docs.dune.com/web-app/google-sso-domain-restriction.md): Restrict team join requests via Google SSO to the admin's email domain.
- [Okta SSO Setup](https://docs.dune.com/web-app/okta-sso.md): Configure Okta SSO (OIDC) for your Dune team, including domain verification and redirect URLs.

### Data API

- [Data API Overview](https://docs.dune.com/api-reference/api-overview.md)

### Agents

- [Dune MCP](https://docs.dune.com/docs/agents/mcp.md): Connect AI agents to Dune's official MCP server for onchain analytics workflows.
- [Dune CLI & Skills](https://docs.dune.com/docs/agents/cli-and-skills.md): Give your AI coding agent direct access to Dune's blockchain data through the Dune CLI and Agent Skills.
- [Dune MPP](https://docs.dune.com/docs/agents/mpp.md): Access Dune's API with pay-per-request micropayments using the Machine Payment Protocol.

### Transform your Data

- [dbt Connector Overview](https://docs.dune.com/api-reference/connectors/dbt/overview.md): Run production-grade dbt projects directly on Dune with full incremental model support
- [Getting Started](https://docs.dune.com/api-reference/connectors/dbt/getting-started.md): Set up your dbt project and connect to Dune
- [Incremental Models](https://docs.dune.com/api-reference/connectors/dbt/incremental-models.md): Efficiently update large tables with merge, delete+insert, and append strategies
- [dbt Connector + Datashare](https://docs.dune.com/api-reference/connectors/dbt/datashares.md): Sync dbt-managed tables from Dune into your configured datashare target
- [CI/CD & Workflows](https://docs.dune.com/api-reference/connectors/dbt/cicd-workflows.md): Set up development workflows and GitHub Actions for dbt on Dune
- [Pricing & Best Practices](https://docs.dune.com/api-reference/connectors/dbt/pricing-best-practices.md): Credit consumption, optimization tips, and best practices for dbt on Dune
- [Supported SQL Operations](https://docs.dune.com/api-reference/connectors/sql-operations.md): Comprehensive reference of DDL and DML statements supported for data transformations

### BI Visualization Tools

- [Trino Connector Overview](https://docs.dune.com/api-reference/connectors/trino/overview.md): Access Dune's blockchain data through Trino/Presto-compatible tools and SDKs
- [Hex](https://docs.dune.com/api-reference/connectors/trino/hex.md): Connect Dune to Hex's notebook-native analytics platform
- [Metabase](https://docs.dune.com/api-reference/connectors/trino/metabase.md): Connect Dune to Metabase for BI dashboards
- [DBeaver](https://docs.dune.com/api-reference/connectors/trino/dbeaver.md): Connect Dune to DBeaver for direct SQL access
- [Trino SDKs](https://docs.dune.com/api-reference/connectors/trino/sdks.md): Connect to Dune using Trino SDKs in your preferred programming language

### Dune Datashare

- [Datashare Overview](https://docs.dune.com/datashare/datashare.md): Access all of Dune's blockchain data directly in your data warehouse for privacy and control.
- [Getting Started with Datashare](https://docs.dune.com/datashare/datashare-trial.md): Interested in Dune Datashare? Test out our data on Snowflake or BigQuery!
- [Databricks Datashare](https://docs.dune.com/datashare/datashare-databricks.md): Access Dune's blockchain data directly in your Databricks environment
- [Snowflake Datashare](https://docs.dune.com/datashare/datashare-snowflake.md): Access Dune's blockchain data through the Snowflake Marketplace
- [BigQuery Datashare](https://docs.dune.com/datashare/datashare-bigquery.md): Access Dune's blockchain data directly in your BigQuery environment
- [S3 Datashare](https://docs.dune.com/datashare/datashare-s3.md): Publish your Dune tables as Iceberg tables in a Dune-managed S3 bucket
- [Datashare FAQs](https://docs.dune.com/datashare/datashare-faqs.md): Frequently Asked Questions about Dune Datashare
- [Datashare Enterprise](https://docs.dune.com/enterprise/datashare/overview.md): Enterprise data delivery with SLAs and dedicated support.

- [Data Catalog (1401 pages)](https://docs.dune.com/_llms/data-catalog.md): Documentation for Data Catalog.

## API Reference

### Introduction

- [Overview](https://docs.dune.com/api-reference/overview/introduction.md)
- [Getting Started](https://docs.dune.com/api-reference/overview/getting-started.md): Learn how to authenticate and make your first API request to Dune
- [Authentication](https://docs.dune.com/api-reference/overview/authentication.md)
- [Troubleshooting Errors](https://docs.dune.com/api-reference/overview/troubleshooting.md)

### Quick Start

- [Analyze Onchain Data](https://docs.dune.com/api-reference/apis/quickstart-analyze.md): Execute SQL queries and build custom analytics pipelines with Dune's query execution engine
- [Build Custom Dashboards & Reports](https://docs.dune.com/api-reference/apis/quickstart-dashboards.md): Fetch query results, manage executions, and create dynamic visualizations in your own applications

### Executions and Results

- [Overview](https://docs.dune.com/api-reference/executions/execution-object.md)
- [Execute SQL](https://docs.dune.com/api-reference/executions/endpoint/execute-sql.md): Execute raw SQL queries directly without needing to create a saved query first
- [Execute Query](https://docs.dune.com/api-reference/executions/endpoint/execute-query.md): Execute, or run a query for the specified query ID
- [Execute Query Pipeline](https://docs.dune.com/api-reference/executions/endpoint/execute-query-pipeline.md): Builds a query pipeline from the specified query and executes it. A pipeline allows you to chain multiple queries together and execute them as a single unit.
- [Get Execution Status](https://docs.dune.com/api-reference/executions/endpoint/get-execution-status.md): Check the status of an execution request
- [Get Execution Result](https://docs.dune.com/api-reference/executions/endpoint/get-execution-result.md): Given an execution ID, returns result of a an execution request
- [Get Execution Result in CSV](https://docs.dune.com/api-reference/executions/endpoint/get-execution-result-csv.md): Given a query ID, returns the latest executed result of a query on Dune in CSV format
- [Get Latest Query Result](https://docs.dune.com/api-reference/executions/endpoint/get-query-result.md): Given a query ID, returns the latest executed result of a query on Dune in JSON format
- [Get Latest Query Result in CSV](https://docs.dune.com/api-reference/executions/endpoint/get-query-result-csv.md): Given a query ID, returns the latest executed result of a query on Dune as CSV
- [Cancel Execution](https://docs.dune.com/api-reference/executions/endpoint/cancel-execution.md): Cancel a triggered execution request given the execution ID

### Query Management

- [Overview](https://docs.dune.com/api-reference/queries/endpoint/query-object.md)
- [List Queries](https://docs.dune.com/api-reference/queries/endpoint/list.md): Retrieve a paginated list of queries owned by the account tied to the API key
- [Get Query Pipeline](https://docs.dune.com/api-reference/queries/endpoint/get-query-pipeline.md): Builds a query pipeline from the specified query and returns the pipeline definition containing all the nested materialized views that the query depends on. A pipeline allows you to chain multiple queries together and execute them as a single unit.
- [Create Query](https://docs.dune.com/api-reference/queries/endpoint/create.md): This API allows for anyone to create a query. The owner of the query will be under the context of the API key.
- [Update Query](https://docs.dune.com/api-reference/queries/endpoint/update.md): This API allows for anyone to update the sql text, parameters, name, tags, and state of a query. Only the API key generated under the context of the owner of that query will work.
- [Read Query](https://docs.dune.com/api-reference/queries/endpoint/read.md): This API allows for anyone to read the sql text, parameters, name, tags, and state of a query. For private queries, only the API key generated under the context of the owner of that query will work.
- [Archive Query](https://docs.dune.com/api-reference/queries/endpoint/archive.md): This API allows for anyone to archive a query. Only the API key generated under the context of the owner of that query will work. This does not delete the query, but will make it uneditable/unexecutable
- [Unarchive Query](https://docs.dune.com/api-reference/queries/endpoint/unarchive.md): This API allows for anyone to unarchive a query. Only the API key generated under the context of the owner of that query will work.
- [Private Query](https://docs.dune.com/api-reference/queries/endpoint/private.md): This API allows for anyone to private a query. Only the API key generated under the context of the owner of that query will work.
- [Unprivate Query](https://docs.dune.com/api-reference/queries/endpoint/unprivate.md): This API allows for anyone to unprivate a query. Only the API key generated under the context of the owner of that query will work.

### Data Uploads

- [Overview](https://docs.dune.com/api-reference/tables/endpoint/overview.md)
- [List Uploaded Tables](https://docs.dune.com/api-reference/tables/endpoint/uploads-list.md): Get a paginated list of uploaded tables
- [Create Table](https://docs.dune.com/api-reference/tables/endpoint/uploads-create.md): Creates an empty uploaded table that can be inserted into with the /insert endpoint. Each successful table creation consumes 10 credits.
- [Insert Data](https://docs.dune.com/api-reference/tables/endpoint/uploads-insert.md): Inserts data into an existing table. Accepts CSV (text/csv) or NDJSON (application/x-ndjson) content types.
- [Upload CSV](https://docs.dune.com/api-reference/tables/endpoint/uploads-csv.md): Upload a CSV file to create a table with automatic schema inference. The size limit per upload is 500MB. Storage limits: 100MB (free), 1GB (analyst), 15GB (plus).
- [Clear Data](https://docs.dune.com/api-reference/tables/endpoint/uploads-clear.md): Removes all data from the specified uploaded table while preserving the table structure and schema.
- [Delete Table](https://docs.dune.com/api-reference/tables/endpoint/uploads-delete.md): Permanently deletes the specified uploaded table and all its data.
- [Migration Guide](https://docs.dune.com/api-reference/tables/endpoint/migration.md): Migrate from deprecated /v1/table/* endpoints to /v1/uploads/*

### Datasets

- [Overview](https://docs.dune.com/api-reference/datasets/introduction.md)
- [List Datasets](https://docs.dune.com/api-reference/datasets/endpoint/list.md): Retrieve a paginated list of datasets with optional filtering by owner and type
- [Get Dataset](https://docs.dune.com/api-reference/datasets/endpoint/get.md): Retrieve dataset information including columns, metadata, and ownership details
- [Search Datasets](https://docs.dune.com/api-reference/datasets/endpoint/search.md): Search for datasets across the Dune catalog, with filtering by categories, blockchains, schemas, and more
- [Search Datasets by Contract Address](https://docs.dune.com/api-reference/datasets/endpoint/search-by-contract.md): Find decoded datasets associated with a smart contract address

### Contract Decoding

- [Overview](https://docs.dune.com/api-reference/contracts/introduction.md)
- [Submit Contracts for Decoding](https://docs.dune.com/api-reference/contracts/endpoint/decode.md): Submit up to 100 contracts (with their ABIs) for decoding in one request. Each item is validated and queued independently; the response reports a per-item result matched by index. Successful items are queued as "pending" and can be tracked with GET /v1/contracts/submissions or at dune.com/workspace.…
- [List Contract Submissions](https://docs.dune.com/api-reference/contracts/endpoint/list.md): List the contract decoding submissions made by your account

### Materialized Views

- [Overview](https://docs.dune.com/api-reference/materialized-views/overview.md)
- [Get Materialized View](https://docs.dune.com/api-reference/materialized-views/get.md): This fetches a materialized view given a name
- [Upsert Materialized View](https://docs.dune.com/api-reference/materialized-views/create.md): This upserts a materialized view from an existing query. If the materialized view with the given name
- [Delete Materialized View](https://docs.dune.com/api-reference/materialized-views/delete.md): This deletes a materialized view given a full name
- [List Materialized Views](https://docs.dune.com/api-reference/materialized-views/list.md): This lists all materialized view owned by the account tied to the API key
- [Refresh Materialized View](https://docs.dune.com/api-reference/materialized-views/refresh.md): This refreshes a materialized view

### Pipelines

- [Overview](https://docs.dune.com/api-reference/pipelines/overview.md)
- [Execute Pipeline](https://docs.dune.com/api-reference/pipelines/endpoint/execute-pipeline.md): Executes a specified pipeline. A pipeline allows you to chain multiple queries and materialized view refreshes together and execute them as a single unit.
- [Get Pipeline Execution Status](https://docs.dune.com/api-reference/pipelines/endpoint/get-pipeline-status.md): Retrieves the status of a pipeline execution, including the status of each node in the pipeline.

### Account Management

- [Overview](https://docs.dune.com/api-reference/usage/overview.md)
- [Get Usage](https://docs.dune.com/api-reference/usage/endpoint/get-usage.md): Retrieve customer usage data for billing periods

### Post-processing

- [Result Filtering](https://docs.dune.com/api-reference/executions/filtering.md): Filter query results server-side using SQL-like WHERE clauses - unique to Dune's API
- [Pagination](https://docs.dune.com/api-reference/executions/pagination.md)
- [Sorting](https://docs.dune.com/api-reference/executions/sorting.md)
- [Sampling](https://docs.dune.com/api-reference/executions/sampling.md)

### Webhooks

- [Create Webhook](https://docs.dune.com/api-reference/webhooks/webhook.md): How to receive data into webhooks from Dune queries

### Client SDKs

- [Python](https://docs.dune.com/api-reference/sdks/python.md): Official Python SDK for Dune Data API
- [TypeScript](https://docs.dune.com/api-reference/sdks/typescript.md): TypeScript/JavaScript SDK for Dune Data API
- [Go](https://docs.dune.com/api-reference/sdks/go.md): Go SDK for Dune Data API

#### Quickstart

- [Execution & Results](https://docs.dune.com/api-reference/quickstart/results-eg.md)
- [Query Management](https://docs.dune.com/api-reference/quickstart/queries-eg.md)
- [Tables Management](https://docs.dune.com/api-reference/quickstart/tables-eg.md)

### Resources

- [Rate Limits](https://docs.dune.com/api-reference/overview/rate-limits.md)
- [Billing](https://docs.dune.com/api-reference/overview/billing.md)
- [FAQ](https://docs.dune.com/api-reference/overview/faq.md)

## SQL Query Engine

- [Query Engine](https://docs.dune.com/query-engine/overview.md): DuneSQL, a Trino fork, is fine-tuned for blockchain analytics.

### Functionality

- [Query Executions](https://docs.dune.com/query-engine/query-executions.md): Learn about query execution triggers and which engine size is best for your workload.
- [Query Views](https://docs.dune.com/query-engine/query-a-query.md): The "Query View" feature in DuneSQL allows you to use an existing query as a view in another query. This powerful functionality enables you to create reusable queries, build complex queries, and take advantage of existing queries as views.
- [Materialized Views](https://docs.dune.com/query-engine/materialized-views.md): Materialized tables are a way to store the results of a query in a table that can be queried like any other table. This is useful when you have a query that takes a long time to run, or when you want to use the results of a query in another query.
- [Incremental Queries](https://docs.dune.com/query-engine/incremental-queries.md): Dramatically reduce query costs and execution time by only processing new data since your last run.

### DuneSQL

- [DuneSQL Architecture](https://docs.dune.com/query-engine/dunesql-architecture.md): Understand how DuneSQL's query engine works.
- [Writing Efficient Queries](https://docs.dune.com/query-engine/writing-efficient-queries.md): Get the most out of DuneSQL by writing efficient queries.
- [Datatypes](https://docs.dune.com/query-engine/datatypes.md): Overview of the data types supported in DuneSQL.
- [Reserved keywords](https://docs.dune.com/query-engine/reserved-keywords.md): The following table lists all of the keywords that are reserved in DuneSQL, along with their status in the SQL standard. These reserved keywords must be quoted (using double quotes) in order to be used as an identifier.

### Functions & Operators

- [Overview](https://docs.dune.com/query-engine/Functions-and-operators/index.md): DuneSQL supports a wide range of built-in functions and operators.

### Core SQL

- [Comparisons](https://docs.dune.com/query-engine/Functions-and-operators/comparison.md)
- [Logical operators](https://docs.dune.com/query-engine/Functions-and-operators/logical.md)
- [Conditional expressions](https://docs.dune.com/query-engine/Functions-and-operators/conditional.md): Guide to CASE, IF, and other conditional logic in DuneSQL.
- [Conversions](https://docs.dune.com/query-engine/Functions-and-operators/conversion.md)

### Aggregate & Window

- [Aggregate functions](https://docs.dune.com/query-engine/Functions-and-operators/aggregate.md)
- [Window functions](https://docs.dune.com/query-engine/Functions-and-operators/window.md): Documentation for ranking and analytic window functions.
- [ASOF Join](https://docs.dune.com/query-engine/Functions-and-operators/asof-join.md): ASOF JOIN in DuneSQL performs nearest-neighbor matching using inequality predicates, making it ideal for temporal lookups like "latest price at trade time" or forward-fill balance snapshots.

### Data Types

- [Array functions and operators](https://docs.dune.com/query-engine/Functions-and-operators/array.md)
- [Map functions and operators](https://docs.dune.com/query-engine/Functions-and-operators/map.md)
- [JSON functions](https://docs.dune.com/query-engine/Functions-and-operators/json.md)
- [Binary](https://docs.dune.com/query-engine/Functions-and-operators/binary.md): Overview of binary operators and functions in DuneSQL.
- [Decimal functions and operators](https://docs.dune.com/query-engine/Functions-and-operators/decimal.md)

### String & Text

- [String functions and operators](https://docs.dune.com/query-engine/Functions-and-operators/string.md)
- [Regular expression functions](https://docs.dune.com/query-engine/Functions-and-operators/regexp.md)
- [Lambda expressions](https://docs.dune.com/query-engine/Functions-and-operators/lambda.md): Lambda expressions are anonymous functions which are passed as arguments to higher-order SQL functions.
- [URL functions](https://docs.dune.com/query-engine/Functions-and-operators/url.md)
- [UUID functions](https://docs.dune.com/query-engine/Functions-and-operators/uuid.md)

### Math & Statistics

- [Mathematical functions and operators](https://docs.dune.com/query-engine/Functions-and-operators/math.md)
- [Bitwise](https://docs.dune.com/query-engine/Functions-and-operators/bitwise.md)
- [HyperLogLog functions](https://docs.dune.com/query-engine/Functions-and-operators/hyperloglog.md)
- [Quantile digest functions](https://docs.dune.com/query-engine/Functions-and-operators/qdigest.md)
- [T-Digest functions](https://docs.dune.com/query-engine/Functions-and-operators/tdigest.md)
- [Set Digest functions](https://docs.dune.com/query-engine/Functions-and-operators/setdigest.md): Functions for computing set digests and HyperLogLog structures.
- [Machine learning functions](https://docs.dune.com/query-engine/Functions-and-operators/ml.md): Use SVM-based classifiers and regressors directly within DuneSQL.

### Date & Time

- [Date and time functions and operators](https://docs.dune.com/query-engine/Functions-and-operators/datetime.md)

### Blockchain Functions

- [Varbinary functions (DuneSQL)](https://docs.dune.com/query-engine/Functions-and-operators/varbinary.md)
- [EVM Decoding Functions](https://docs.dune.com/query-engine/Functions-and-operators/evm-decoding-functions.md): Functions to decode raw EVM events and function calls in DuneSQL.
- [EIP-8021 calldata table function](https://docs.dune.com/query-engine/Functions-and-operators/eip-8021.md): Parse EIP-8021 builder codes from calldata with the `functions.base_l2.call_data_8021` table function.
- [Chain Utility Functions](https://docs.dune.com/query-engine/Functions-and-operators/chain-utility-functions.md): Helper functions for linking to chain explorers and transactions.
- [Base58 functions](https://docs.dune.com/query-engine/Functions-and-operators/base58.md)
- [SS58 functions](https://docs.dune.com/query-engine/Functions-and-operators/ss58.md): Explanation of the SS58 address encoding scheme used in Substrate chains.
- [TON address functions](https://docs.dune.com/query-engine/Functions-and-operators/tonaddress.md): Helpers for encoding and decoding TON blockchain addresses.
- [Tron address functions](https://docs.dune.com/query-engine/Functions-and-operators/tronaddress.md): Utilities for working with TRON's custom address format.
- [Varchar Utility Functions](https://docs.dune.com/query-engine/Functions-and-operators/varchar-utility-functions.md): Reference guide to string helper functions in Dune SQL.

### External Data

- [LiveFetch functions](https://docs.dune.com/query-engine/Functions-and-operators/live-fetch.md): LiveFetch functions send HTTP requests to a specified URL.

### System & Compatibility

- [System information](https://docs.dune.com/query-engine/Functions-and-operators/system.md)
- [Teradata functions](https://docs.dune.com/query-engine/Functions-and-operators/teradata.md)

## Resources

### Credits & Billing

- [Overview](https://docs.dune.com/resources/credits-billing/overview.md): What is the credit system on Dune and how credits work on Dune
- [How Credits Work](https://docs.dune.com/resources/credits-billing/how-credits-work.md): How Dune's usage-based credit system works for fair and flexible querying

### Learning

- [Web3 Data Resources](https://docs.dune.com/resources/web3-data-resources.md): Navigate the Ever-Expanding World of Web3 Data with Ease, from Beginners to Experts
- [Measuring User Activity](https://docs.dune.com/web-app/user-activity.md): Explains how Dune tracks contributions across queries and dashboards.
- [Video Tutorials](https://docs.dune.com/resources/learning/video-tutorials.md): Watch step-by-step video guides covering all aspects of Dune

### Support

- [Support & Contact](https://docs.dune.com/resources/support/overview.md): Get help with Dune and contact our team
- [FAQs](https://docs.dune.com/learning/how-tos/pricing-faqs.md): Frequently asked questions about Dune's pricing, credits, billing, plans, and more
- [Migrating from Flipside to Dune](https://docs.dune.com/learning/flipside-migration-guide.md): A comprehensive guide for Flipside users transitioning to Dune, including table mappings and SQL syntax differences

### Bug Bounty

- [Bug Bounty Submission](https://docs.dune.com/web-app/bug-bounty.md): Found a security issue within our application?

## OpenAPI Specs

- [analytics-openapi](/analytics-openapi.json)
- [markets-openapi](/api-reference/markets/markets-openapi.json)

> The links below point to documentation indexes. Follow each `/_llms/` index recursively until you reach documentation pages.

## Indexes

- [Data Catalog (1401 pages)](https://docs.dune.com/_llms/data-catalog.md): Documentation for Data Catalog.
- [Data Catalog / EVM Networks (895 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks.md): Documentation for Data Catalog / EVM Networks.
- [Data Catalog / EVM Networks / ApeChain (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/ape-chain.md): Documentation for Data Catalog / EVM Networks / ApeChain.
- [Data Catalog / EVM Networks / Arbitrum One (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/arbitrum-one.md): Documentation for Data Catalog / EVM Networks / Arbitrum One.
- [Data Catalog / EVM Networks / Arbitrum Nova (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/arbitrum-nova.md): Documentation for Data Catalog / EVM Networks / Arbitrum Nova.
- [Data Catalog / EVM Networks / Avalanche (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/avalanche.md): Documentation for Data Catalog / EVM Networks / Avalanche.
- [Data Catalog / EVM Networks / Berachain (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/berachain.md): Documentation for Data Catalog / EVM Networks / Berachain.
- [Data Catalog / EVM Networks / Blast (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/blast.md): Documentation for Data Catalog / EVM Networks / Blast.
- [Data Catalog / EVM Networks / BNB (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/bnb.md): Documentation for Data Catalog / EVM Networks / BNB.
- [Data Catalog / EVM Networks / Boba (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/boba.md): Documentation for Data Catalog / EVM Networks / Boba.
- [Data Catalog / EVM Networks / Celo (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/celo.md): Documentation for Data Catalog / EVM Networks / Celo.
- [Data Catalog / EVM Networks / Corn (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/corn.md): Documentation for Data Catalog / EVM Networks / Corn.
- [Data Catalog / EVM Networks / Ethereum (16 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/ethereum.md): Documentation for Data Catalog / EVM Networks / Ethereum.
- [Data Catalog / EVM Networks / Fantom (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/fantom.md): Documentation for Data Catalog / EVM Networks / Fantom.
- [Data Catalog / EVM Networks / Gnosis (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/gnosis.md): Documentation for Data Catalog / EVM Networks / Gnosis.
- [Data Catalog / EVM Networks / Linea (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/linea.md): Documentation for Data Catalog / EVM Networks / Linea.
- [Data Catalog / EVM Networks / Mantle (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/mantle.md): Documentation for Data Catalog / EVM Networks / Mantle.
- [Data Catalog / EVM Networks / opBNB (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/op-bnb.md): Documentation for Data Catalog / EVM Networks / opBNB.
- [Data Catalog / EVM Networks / Optimism (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/optimism.md): Documentation for Data Catalog / EVM Networks / Optimism.
- [Data Catalog / EVM Networks / Polygon (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/polygon.md): Documentation for Data Catalog / EVM Networks / Polygon.
- [Data Catalog / EVM Networks / Polygon-zkEVM (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/polygon-zk-evm.md): Documentation for Data Catalog / EVM Networks / Polygon-zkEVM.
- [Data Catalog / EVM Networks / Scroll (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/scroll.md): Documentation for Data Catalog / EVM Networks / Scroll.
- [Data Catalog / EVM Networks / Sei (21 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/sei.md): Documentation for Data Catalog / EVM Networks / Sei.
- [Data Catalog / EVM Networks / Shape (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/shape.md): Documentation for Data Catalog / EVM Networks / Shape.
- [Data Catalog / EVM Networks / Sonic (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/sonic.md): Documentation for Data Catalog / EVM Networks / Sonic.
- [Data Catalog / EVM Networks / Sophon (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/sophon.md): Documentation for Data Catalog / EVM Networks / Sophon.
- [Data Catalog / EVM Networks / Unichain (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/unichain.md): Documentation for Data Catalog / EVM Networks / Unichain.
- [Data Catalog / EVM Networks / World Chain (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/world-chain.md): Documentation for Data Catalog / EVM Networks / World Chain.
- [Data Catalog / EVM Networks / zkSync (15 pages)](https://docs.dune.com/_llms/data-catalog/evm-networks/zk-sync.md): Documentation for Data Catalog / EVM Networks / zkSync.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.