Getting started with Yandex WebSQL
Note
This feature is in the Preview stage.
Yandex WebSQL is a Yandex Cloud service that allows you to connect to clusters of managed and public databases. You can view database tables and schemas, and run SQL queries. It is a web-based tool that simplifies writing SQL queries by suggesting prompts and commands.
In this section, you will learn how to connect to:
- Managed database clusters within Yandex Cloud
- Public databases via the internet
Getting started
- Go to the management console
and log in to Yandex Cloud or sign up if not signed up 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 managed database cluster within Yandex Cloud
Warning
Yandex WebSQL cannot connect to Managed Service for ClickHouse® clusters with SQL user management enabled. Connect to such a cluster as to an external database.
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. Added connections will be available while you are working in the current Yandex Cloud organization.
To create a connection to a managed DB cluster:
- Make sure Access from the management console is enabled in the 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.
If the connection is successful, you will see the cluster structure in the connection manager tree. Hosts of the same cluster will appear in the connection group.
Connecting to a public database
To connect to a public 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, you will see the database structure in the connection manager tree.
What's next
ClickHouse® is a registered trademark of ClickHouse, Inc