SQL queries in Yandex WebSQL
You can use Yandex WebSQL to send SQL queries to Managed Service for MySQL® cluster databases.
WebSQL is a Yandex Cloud service that allows you to connect to managed database clusters, work with databases, tables, and schemas, and run queries. This service runs in the browser, requires no extra login, and simplifies work by providing hints for SQL commands.
To connect to a cluster from WebSQL, you must enable the WebSQL access option in the cluster settings. You can enable it when creating or updating a cluster.
The Managed Service for MySQL® cluster automatically creates a Connection Manager connection for each database user, enabling database access from WebSQL. You can also create a new connection if needed.
To connect to the database from WebSQL:
-
In the management console, select the folder containing your cluster.
-
Navigate to Managed Service for MySQL.
-
Click the cluster name and navigate to the WebSQL tab.
-
Select the required connection.
The connection will open in WebSQL. To open the query editor, select the required database.
Check this MySQL® reference for supported queries.
For more information on WebSQL, see this guide.