SQL queries in Yandex WebSQL
You can send SQL queries to databases in a Managed Service for PostgreSQL cluster using Yandex WebSQL.
WebSQL is a Yandex Cloud service that allows you to connect to managed database clusters, work with DBs, tables, and schemas, and run queries. It is a web-based tool that does not require additional authorization and simplifies working with SQL queries by suggesting prompts.
To connect from WebSQL to a Managed Service for PostgreSQL cluster, create a connection:
- Go to the folder page and select Managed Service for PostgreSQL.
- Click the cluster name.
- Enable the WebSQL access option in the cluster settings if it is not enabled yet.
- Select the WebSQL tab.
- Click Create connection and specify the connection parameters:
- Connection name.
- Database type: PostgreSQL.
- Cluster: Defaults to your current PostgreSQL cluster.
- Username you will use to connect to the database in the cluster.
- User password.
- 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.
- Click Create.
To open the SQL editor, click the created connection on the WebSQL tab. See a reference list of supported queries in the PostgreSQL documentation
Note
You cannot use SQL commands to do anything that requires superuser access.
For more information about working with WebSQL, see its documentation.