Creating a connection

In Yandex WebSQL, you can create a connection to:

• Managed database clusters in Yandex Cloud
• Public database via the internet

Connecting to a managed database cluster in Yandex CloudConnecting to a managed database cluster in Yandex Cloud

In Yandex WebSQL, you can connect to databases in the following clusters:

• Yandex Managed Service for PostgreSQL
• Yandex Managed Service for ClickHouse®
• Yandex Managed Service for MySQL®
• Yandex Managed Service for Redis

Before creating a connection, make sure that you have selected the required folder. If you have access to PostgreSQL, ClickHouse®, MySQL®, or Redis clusters previously created in that folder, they will automatically appear in the Yandex Cloud connections subsection. You will only need to create a connection to the appropriate database in the cluster.

Connections to clusters created in Yandex MetaData Hub Connection Manager will also be displayed automatically, provided you have roles to manage these connections in Connection Manager.

To create a connection to a managed database cluster:

1. Make sure WebSQL access is enabled in the cluster settings.
2. Open Yandex WebSQL Connections.
3. Under Connections, click .
4. Name the connection.
5. In the Database type field, select the DB you need: PostgreSQL, ClickHouse®, MySQL®, or Redis.
6. In the Cluster field, select the managed database cluster you want to connect to.
7. Specify the Username you will use to connect to cluster databases.
8. Enter the user Password.
9. List the Databases you want to connect to. You can only connect to the databases that exist in this cluster. The user you specified must have access to them configured.
10. Click Create.

You can also create a connection to a cluster in Yandex MetaData Hub Connection Manager. This connection will automatically appear in Yandex WebSQL. But DB username, password, and name should be entered manually.

If the connection is successful, you will see the cluster structure in the connection tree. Connections to databases within a single managed database cluster are grouped into an expandable list under the name of that cluster.

Connecting to a public databaseConnecting to a public database

To connect to a public database via the internet:

1. Open Yandex WebSQL Connections.

2. In Connections, click .

3. In the bottom-left corner of the window that opens, click External connection.

4. Name the connection.

5. In the Database type field, select the database you need: PostgreSQL, ClickHouse®, MySQL®, or Redis.

6. Under Hosts, configure the hosts:

   • Specify the database host FQDN and port number for connecting to the database.

   • For ClickHouse®, also specify the Native Protocol port and shard name.

   • (Optional) Enable TLS.

     If your company has a certification authority (CA), the certificate issued by the CA will be used by default. If the company has no CA, upload the server's TLS certificate.

7. Specify the Username you will use to connect to the database.

8. Enter the user Password.

9. List the Databases you want to connect to. You can only connect to existing databases. The user you specified must have access to them configured.

10. Click Create.

If the connection is successful, you will see the database structure in the connection tree.