Skip to content

Query manager database configuration

DBeaverDevOps edited this page Sep 3, 2024 · 9 revisions

It is possible to configure a database to store all information from the Query manager.

The configuration for the Query Manager database is located in the configuration file under the qm section. Additionally, you have the option to configure it using environment variables.

Default configuration:

{
    server: {
       ...
    },
    app: {
       ...
    },
    qm: {
        driver: "${CLOUDBEAVER_QM_DB_DRIVER:h2_embedded_v2}",
        url: "${CLOUDBEAVER_QM_DB_URL:jdbc:h2:${workspace}/.metadata/qmdb/qmdb}",
        user: "${CLOUDBEAVER_QM_DB_USER:''}",
        password: "${CLOUDBEAVER_QM_DB_PASSWORD:''}",
        schema: "${CLOUDBEAVER_QM_DB_SCHEMA:''}"
    }

}
Name Variable name Description
driver CLOUDBEAVER_QM_DB_DRIVER Database driver (e.g.postgres-jdbc, oracle-thin, etc).
url CLOUDBEAVER_QM_DB_URL Database JDBC URL (e.g.jdbc:postgresql://localhost:5432/qm).
user CLOUDBEAVER_QM_DB_USER Database user name.
password CLOUDBEAVER_QM_DB_PASSWORD Database user password.
schema CLOUDBEAVER_QM_DB_SCHEMA Database schema.

CloudBeaver Documentation

Clone this wiki locally