Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Start testing with double trial credits
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex WebSQL
  • Getting started
    • All guides
    • Creating a connection
    • Connection management
    • Viewing information about database objects
    • Working with the query editor
    • Working with saved queries
    • Working with query history
  • Access management
  • Pricing policy
  • Audit Trails events

In this article:

  • Running a query
  • Multi-queries
  • Exporting query execution results
  • Setting up the query editor
  1. Step-by-step guides
  2. Working with the query editor

Working with the query editor

Written by
Yandex Cloud
Updated at April 21, 2025
  • Running a query
  • Multi-queries
  • Exporting query execution results
  • Setting up 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):

Windows/Linux
macOS
  • Show suggestions: Ctrl + I , Ctrl + Space.
  • Comment out a line: Ctrl + /.
  • Run a query: Ctrl + Enter.
  • Show suggestions: ⌘ + I , ⌃ + Space.
  • Comment out a line: ⌘ + /.
  • Run a query: ⌘ + ⏎.

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

Note

A table with multiple rows may be difficult to view. Use the LIMIT condition along with other filters to limit the number of rows to display.

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

Multi-queriesMulti-queries

In the query editor, you can use multi-queries, enabling you to run multiple queries as a single batch.

Multi-query example:

SELECT * FROM <table_1_name> LIMIT 10;
INSERT INTO <table_2_name>;

The Experiments section in Yandex WebSQL settings contains the Multi-queries option that enables separate subqueries within a multi-query. To do this, highlight one or more subqueries and click Run current query. The editor will display the progress status of the highlighted queries.

By default, the Multi-queries option is enabled for all WebSQL users by default. To disable it, go to the settings and disable Multi-queries under Experiments.

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 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. Customize the editor theme (Visual Studio or High Contrast), font size and type, and the following editing feature options:
    • Editor tips
    • Syntax highlighting
    • Error highlighting
    • Editor minimap
    • Autoclosing of quotes
    • Autoclosing of parentheses

ClickHouse® is a registered trademark of ClickHouse, Inc.

Was the article helpful?

Previous
Viewing information about database objects
Next
Working with saved queries
© 2025 Direct Cursus Technology L.L.C.