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. It is a web-based tool that requires no additional authentication and simplifies working with SQL commands by suggesting prompts.

To connect to a Managed Service for MySQL® cluster from WebSQL, create a connection:

1. Go to Managed Service for MySQL.
2. Click the cluster name.
3. Enable WebSQL access in the cluster settings if it is not on yet.
4. Select the WebSQL tab.
5. Click Create connection and specify the following connection settings:
   • Connection name.
   • Database type: MySQL®.
   • Cluster: Defaults to your current MySQL® cluster.
   • Username you will use to connect to the database in the cluster.
   • Password: User password.
   • Databases: List of databases you want to access. You can only connect to the databases within the current cluster. The user account you specified must have permissions to access these databases.
6. Click Create.

To open the SQL editor, click the created connection on the WebSQL tab.

For more information on how to work with WebSQL, see these guides.