Create Queries
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.
These shortcuts work on US/UK Keyboards and might vary based on the language setting on your device.
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 pressingctrl/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 |