SQL queries in Yandex WebSQL
You can use Yandex WebSQL to send SQL queries to Yandex StoreDoc cluster databases.
WebSQL is a Yandex Cloud service that enables you to connect to managed database clusters, work with databases, tables, and schemas, and run queries. It is a web-based tool that requires no additional authorization and simplifies working with SQL commands by prompting the user.
To connect from WebSQL, you must enable the WebSQL access option in the cluster settings. You can enable this option when creating a cluster or modifying a cluster.
In the Yandex StoreDoc cluster, a Connection Manager connection is automatically created for each database user, which you can use to connect to the database from WebSQL. You can also create a new connection if you need one.
To connect to the database from WebSQL:
-
In the management console, select the folder with the cluster of interest.
-
Go to Yandex StoreDoc.
-
Click the cluster name and go to the WebSQL tab.
-
Select the connection.
The connection will open in WebSQL. To go to the query editor, select the required database.
For more information on how to work with WebSQL, see these guides.