Working with the query editor

The query editor opens in the data panel when you select a database, a table, or a view in the Connections section.

Running a queryRunning a query

To perform a database query, establish or activate a connection with the database.

To build a query:

1. Under Connections, select a database, table, or image.

2. In the data panel, you will see a form with the default query:

   SELECT * FROM <table_name> LIMIT 10;
   

3. Use this query or edit it. The interface will suggest relevant parts of the query and highlight errors.

4. Click Run.

In the results panel, you will see a table with the query results.

When editing or running a query, you can use the following keyboard shortcuts (click to see the full list):

Click Open Command Palette to view a complete list of available commands and their corresponding keyboard shortcuts.

You can view your executed queries in query history and save them as templates.

Exporting query execution resultsExporting query execution results

To save the results in a format you like:

1. Click Export in the top-right corner of the panel with the results table.
2. Select the appropriate format: JSON,CSV, or TSV.

A file with the results will be added to your browser's downloads section.

Setting up the query editorSetting up the query editor

Yandex WebSQL enables you to quickly edit your queries, including with features, such as context help or SQL syntax and error highlighting. To manage these features:

1. Click Settings in the bottom-left corner.
2. Go to the Query editor section.
3. Set up the editor theme (Visual Studio or High Contrast), font size and type, and the editing features:
   • Editor tips
   • Syntax highlighting
   • Error highlighting
   • Editor minimap
   • Autoclosing of quotes
   • Autoclosing of parentheses