Getting started with Yandex WebSQL
Note
This feature is in the Preview stage.
In this section, you will learn how to connect to clusters of managed databases using Yandex WebSQL.
Getting started
- Go to the management console
and log in to Yandex Cloud or create an account if you do not have one yet. - On the Billing
page, make sure you have a billing account linked and it has theACTIVE
orTRIAL_ACTIVE
status. If you do not have a billing account, create one. - Select the organization to work with Yandex WebSQL in or create a new one.
Connecting to a database
Create your first connection to the database.
If you have a PostgreSQL, ClickHouse®, or MySQL cluster set up in Yandex Cloud, you can connect directly to it:
Warning
You can establish connections to managed DB clusters from your Yandex Cloud organization's clouds and folders. If you switch to a different organization, a set of clusters from other clouds and folders will be available to you.
- Make sure the Access from the management console option is enabled in the PostgreSQL, MySQL, or ClickHouse® cluster settings.
- In Yandex WebSQL, go to the Connection manager section and click
in the top-right corner. - Specify the connection parameters:
- Cloud: Select a cloud.
- Folder: Select the folder where you created the database cluster.
- Cluster: Select the cluster.
- Click Connect to connect to the selected cluster.
Imported connections will be available while you are working in the current Yandex Cloud organization.
You can also connect to a publicly available database via the internet.
- Go to the Connection manager (
) section and click in the top-right corner. - Click External connection.
- Specify the connection parameters:
- Database type: Select PostgreSQL, ClickHouse®, or MySQL.
- Database URL: Specify the DB host address in
https://<address>
format. - Port: Specify the number of the port for connections.
- Database: Enter the DB name.
- User and Password: Enter the username and password to access the database.
- SSL certificate: Enable this option if your cluster uses a secure SSL connection. The Yandex WebSQL certificate is used by default.
- Click Connect.
If the connection is successful, the structure of the cluster or database will show up in the connection manager tree. Hosts of the same cluster will appear in the connection group.
What's next
ClickHouse® is a registered trademark of ClickHouse, Inc