Managing database user credentials
Encore provisions your databases automatically, meaning you don't need to manually create database users. However, in some use cases you need access to the database user credentials, so Encore makes it simple to view them.
As an application Admin, open the Cloud Dashboard and go to the Infrastructure page for the relevant environment.
In the section for the relevant Database Cluster, you will find a Users sub-section which lists your database users. Click on the "eye" icon next to each username to decrypt the password.
Note that databases hosted in Encore Cloud currently do not expose usernames and passwords.
To connect to an Encore Cloud-hosted database, use encore db shell.
encore db shell defaults to read-only permissions. Use --write, --admin and --superuser flags to modify which permissions you connect with.
Take care
Do not change or remove the database users created by Encore, as this will prevent Encore from maintaining and handling connections to the databases in your application.