SQL queries in Yandex WebSQL

You can use Yandex WebSQL to send SQL queries to Managed Service for PostgreSQL cluster databases.

WebSQL is a Yandex Cloud service that allows you to connect to managed database clusters, work with database schemas and tables, and run queries. This service runs in your browser, requires no additional authentication, and simplifies working with SQL queries by providing hints.

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

1. Navigate to the folder dashboard and select Managed Service for PostgreSQL.
2. Click the name of your cluster.
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: PostgreSQL.
   • Cluster: Defaults to your current PostgreSQL cluster.
   • Username: Account you will use to connect to the cluster database.
   • 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 connection you created on the WebSQL tab. See the PostgreSQL reference for supported queries.

For more details on using WebSQL, see its official guides.