[Yandex Cloud documentation](../../index.md) > [Yandex WebSQL](../index.md) > Concepts > About Yandex WebSQL

# About Yandex WebSQL

Yandex WebSQL is a Yandex Cloud service that allows you to connect to public databases and managed database clusters.

Once connected to a database, you will be able to view DB schemas, tables, and views, as well as run queries. A web-based tool, Yandex WebSQL simplifies writing queries with relevant suggestions.


You can connect to managed database clusters from clouds and folders that belong to your Yandex Cloud [organization](../../organization/concepts/organization.md). If you [switch to a different organization](../../organization/operations/manage-organizations.md#switch-to-another-org), you will have access to clusters from other clouds and folders. The connections you added will be available while you are in the current Yandex Cloud organization.



You can connect to Yandex Cloud managed database clusters from Yandex Cloud clouds that belong to your organization. If you switch to a different organization, you will have access to clusters from other clouds. The connections you added will be available while you are in the current organization.


Yandex WebSQL supports the following DB versions:

* PostgreSQL: 12 or higher.
* MySQL®: 5 or higher.
* ClickHouse®: 23 or higher.
* Valkey™/Valkey™ (non-sharded clusters only): 6 or higher.
* MongoDB/Yandex StoreDoc: 6 or higher.
* [Yandex Managed Service for Trino](../../managed-trino/index.md) (currently at the [Preview](../../overview/concepts/launch-stages.md) stage): 454 or higher.
* Greenplum®: 6 or higher.

## GUI {#user-interface}

To work with Yandex WebSQL, use:

* _Control panel_: Far-left panel with icons for ![image](../../_assets/console-icons/folder-tree.svg) **Connections**, ![image](../../_assets/console-icons/floppy-disk.svg) **Saved queries**, and ![image](../../_assets/console-icons/clock-arrow-rotate-left.svg) **Query history**.
* _Connections_: Panel for viewing existing database connections and adding new ones.
* _Data panel_: Far-right panel where you can build queries and view the results of their execution, as well as view connection settings and DB object information.

In the Yandex WebSQL interface, the URL of the current page is automatically appended with the IDs of the Yandex WebSQL entities you open. This enables you to share a direct link to a cluster, connection, database, saved query, or historical query in Yandex WebSQL with other users.

> For example, while using Yandex WebSQL, you saved a query and want to share it with another user. To do this, go to the ![image](../../_assets/console-icons/floppy-disk.svg) **Saved queries** section, select the query you need, and copy its URL from the address bar.
> The URL will look like this:
> ```
> https://websql.yandex.cloud/folders/<your_folder_ID>/saved-queries/<saved_query_ID>`
> ```
> This link will take the user to the page with the saved query in Yandex WebSQL.

## Connections {#connection}

In Yandex WebSQL, you can create, use, and manage DB connections. In the ![image](../../_assets/console-icons/folder-tree.svg) [**Connections**](https://websql.yandex.cloud) section, you can work with the following types of connections:
* [Connections to Yandex Cloud clusters](../operations/create-connection.md#connect-cluster): Connections to databases in managed database clusters via the Yandex Cloud internal network. Such clusters do not necessarily have to be publicly available.
* [External connections](../operations/create-connection.md#connect-db): Connections to custom DB installations over the internet.

The **Yandex Cloud connections** subsection automatically displays PostgreSQL, ClickHouse®, MySQL®, Valkey™/Valkey™, Yandex StoreDoc, Yandex Managed Service for Trino, and Yandex MPP Analytics for PostgreSQL clusters from the current folder if the user has access to them. You can select a different folder in the bar above the **Connections** section. The list of clusters will update automatically.

For each cluster, all database connections are grouped into a drop-down list under the cluster name. You cannot change this name in Yandex WebSQL but you can update the cluster name in the managed database service. The ![image](../../_assets/console-icons/folder-tree.svg) [**Connections**](https://websql.yandex.cloud) section will automatically show this update.

External connections are not grouped together even if database hosts share the same address.

Yandex WebSQL also supports integration with [Yandex MetaData Hub](../../metadata-hub/index.md) at the user folder level. Connections created in Yandex WebSQL automatically appear in Yandex MetaData Hub Connection Manager and vice versa.

You can also [edit connection settings](../operations/change-connection-settings.md) and [delete connections you no longer need](../operations/delete-connection.md). After you connect to a DB, you can [monitor schemas, tables, and views](../operations/view-db-objects-info.md) (`VIEW`). Tables and views within one connection are grouped together. Grouping of views is available if there is at least one view in the DB.

## Queries {#queries}

For each database, you can run queries using tooltips: start typing a query command and select the suitable one from the drop-down list. You can also use ready-made _templates_ or [save your queries](../operations/templates.md#save-query) as [custom templates](#saved-queries).

[Query history](#query-log) allows you to [see](../operations/history.md) and repeat your previous queries.

To learn more about running queries, see [this guide](../operations/query-executor.md).

## Saved queries {#saved-queries}

A _saved query_ is a query saved as a template. You can save any query. It will appear in the ![image](../../_assets/console-icons/floppy-disk.svg) **Saved queries** section on the control panel.

To learn more about using saved queries, see [this guide](../operations/templates.md).

## Historical queries {#query-log}

_Historical queries_ are queries executed in your Yandex Cloud [organization](../../organization/concepts/organization.md) within the current connection session. They are displayed in the ![image](../../_assets/console-icons/clock-arrow-rotate-left.svg) **Query history** section. Next to each query, you can find its status:

* ![image](../../_assets/websql/success.svg): Query executed successfully.
* ![image](../../_assets/websql/error.svg): Query execution failed.
* ![image](../../_assets/websql/unknown.svg): Unexpected error on the Yandex WebSQL side.

To learn more about handling historical queries, see [this guide](../operations/history.md).