Writing Queries
The query editor allows you to query blockchain data using DuneSQL.
The Query Editor is where you construct your queries. You’ll probably spend most of your time here.
This section of the documentation describes the UI features of the query editor.
To learn more about our query engine, check out the query-engine section of the documentation.
Query editor
The Query editor is pretty straightforward. It’s a text editor where you can write SQL code.
The editor has a few features that make your life easier:
Autocomplete
The autocomplete feature will bring up DuneSQL keywords, as well as tables and aliases you’ve already included in your Query.
You can always bring up the autocomplete menu by pressing ctrl/cmd + space.
Turn it on/off in the settings.
Run selection
To save yourself time while testing and debugging your Queries, you can run just a part of your Query.
To do this, highlight a part of your Query. You’ll then see the Run button turn into a Run selection button.
Explain Query
The explain query feature utilizes ChatGPT4 to explain your query in plain English. It’s a great way to get a quick overview of what your query does.
Simply click the explain query button to see a GPT4 generated explanation of the query.
Shortcuts
Here are a handful of shortcuts to make crafting Queries easier:
| Shortcut | Action |
|---|---|
| ctrl + enter | execute the Query |
| ctrl + # or / | comments out the selected code |
| ctrl + space | brings up a list of keywords |
| crtl + z | undoes your last changes |
| ctrl + y | redoes your last changes |
| ctrl + f | search for keywords |
| ctrl + h | search and replace keywords |
These shortcuts work on US/UK Keyboards and might vary based on the language setting on your device.
Query results
The Query results are displayed in a table below the Query editor.
You can sort the results by clicking on the column headers. Click once to sort ascending, click again to sort descending. Results are paginated, so you can click through the pages to see more results. Each page shows 25 results.
You can full text search the results by using the search bar below the results table.
You can format the results according to the rules laid out in the tables section of the documentation.