Skip to main content
Onchain SQL analytics platform for querying blockchain data across Ethereum, Polygon, Arbitrum, and other chains. Use for on-chain analysis like token holder counts, DeFi protocol TVL, or transaction patterns. Supports both saved queries (by ID) and raw SQL execution — raw SQL is more flexible but requires knowing the table schema. 13 endpoints available through Lava’s AI Gateway. See the Dune API docs for full documentation.
Supports both managed (Lava’s API keys) and unmanaged (bring your own credentials) mode.

Endpoints

Execute a saved query by ID

POST https://api.dune.com/api/v1/query/3237721/execute — $0.005 / request
const data = await lava.gateway('https://api.dune.com/api/v1/query/3237721/execute', { body: {"query_parameters":{}} });

Execute raw SQL query

POST https://api.dune.com/api/v1/sql/execute — $0.005 / request
const data = await lava.gateway('https://api.dune.com/api/v1/sql/execute', { body: {"query_sql":"SELECT * FROM ethereum.transactions LIMIT 10"} });

Get query execution results

GET https://api.dune.com/api/v1/query/3237721/results — $0.005 / request
const data = await lava.gateway('https://api.dune.com/api/v1/query/3237721/results', { method: 'GET' });

Get query results as CSV

GET https://api.dune.com/api/v1/query/{id}/results/csv — $0.005 / request

Check execution status

GET https://api.dune.com/api/v1/execution/{id}/status — $0.005 / request

Get execution results by ID

GET https://api.dune.com/api/v1/execution/{id}/results — $0.005 / request

Get execution results as CSV

GET https://api.dune.com/api/v1/execution/{id}/results/csv — $0.005 / request

List available datasets

GET https://api.dune.com/api/v1/datasets — $0.005 / request

Get dataset details

GET https://api.dune.com/api/v1/datasets/{id} — $0.005 / request

Execute a query pipeline

POST https://api.dune.com/api/v1/query/{id}/pipeline/execute — $0.005 / request

Execute a pipeline

POST https://api.dune.com/api/v1/pipelines/execute — $0.005 / request

Check pipeline execution status

GET https://api.dune.com/api/v1/pipelines/executions/{id}/status — $0.005 / request

Get query pipeline configuration

GET https://api.dune.com/api/v1/query/{id}/pipeline — $0.005 / request

Next Steps

All Providers

Browse all supported AI providers

Forward Proxy

Learn how to construct proxy URLs and authenticate requests