Server database

Team Edition supports the following internal databases:

• PostgreSQL (default)
• MariaDB
• Oracle
• SQL Server

Before you start

Note

This section applies only to Docker Compose deployments.

By default, the cloudbeaver-te service runs on cloudbeaver-te-common-net, while postgres runs on the isolated cloudbeaver-te-private-net. The two services can't reach each other across these networks.

To temporarily allow access, add cloudbeaver-te-private-net to the list services.cloudbeaver-te.networks in docker-compose.yml:

cloudbeaver-te:
  networks:
    - cloudbeaver-te-common-net
    - cloudbeaver-te-private-net  # add temporarily

Then apply the change:

docker compose up -d

Warning

This exposes the internal database to the application network. Revert this change when you're done.

Accessing the database

1. Identify database connection parameters used by the server

   Tip

   Look for CLOUDBEAVER_DB_* in the .env file or backend.cloudbeaver_db_*in k8s/values.yaml.

2. Create a connection

   Example

   Typical PostgreSQL connection settings.

   Use web client to connect:

   • Host: postgres
   • Port: default is 5432
   • Database: default is cloudbeaver
   • User: value of CLOUDBEAVER_DB_USER
   • Password: value of CLOUDBEAVER_DB_PASSWORD

   Default credentials depend on your deployment configuration and may differ from standard PostgreSQL defaults.

   

3. Open the cloudbeaver database. > Tip: Open the qm schema to view Query Manager data. Query history is stored in the qm_query table.

Changing the database password

1. Change passwords value:

   • for compose compose/cbte/.env value of CLOUDBEAVER_DB_PASSWORD variable
   • for k8s in k8s/cbte/values.yaml value of backend.cloudbeaver_db_password variable

   Example

   CLOUDBEAVER_DB_PASSWORD=**********.

2. Login into postgres container:

   • for compose from compose/cbte/ dir run docker compose exec -it postgres psql -U postgres
   • for k8s with kubectl kubectl-do exec -it postgres-*********-***** psql -U postgres

3. Change postgres password:

   • ALTER USER postgres WITH PASSWORD '**********';

4. Restart or redeploy cluster services:

   • for compose in compose/cbte execute docker compose up -d command
   • for k8s in k8s/ dir execute helm upgrade cloudbeaver ./cbte