Query manager database

By default, the system uses an internal PostgreSQL database to store Query manager.

Accessing the database

1. Identify database connection parameters used by the server.

   Tip

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

2. Create a connection to the database used by Query Manager.

   Example

   Typical PostgreSQL connection settings:

   • Host: postgres
   • Port: default is 5432
   • Database: default is cloudbeaver
   • User: value of CLOUDBEAVER_QM_DB_USER
   • Password: value of CLOUDBEAVER_QM_DB_PASSWORD

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

   

3. Open the qm schema to view Query Manager data.

   

   Tip

   Query history is stored in the qm_query table.