Query manager database

Note

This feature is available in Enterprise and AWS editions only.

The system uses an internal database to store query history, API call logs, and other service data.

Accessing the database

1. Create the target folder inside the container.

   docker compose exec cloudbeaver mkdir -p /opt/cloudbeaver/workspace/sample
   

2. Copy the database folder.

   docker compose exec cloudbeaver cp -r /opt/cloudbeaver/workspace/.metadata/qmdb/ /opt/cloudbeaver/workspace/sample/
   

3. Connect to the internal server database used in your deployment (for example, H2 Embedded V.2):

   • Set the path to ${workspace}/sample/qmdb/qmdb.

   • Default login and password aren't required unless changed in the Query manager database configuration.

   

   Info

   The H2 Embedded V.2 driver might be disabled by default. To enable it, see Server configuration and administration.

4. Explore the internal tables to view stored data:

Table	Description
qm_query	Contains query history
qm_api_call_log	Contains API call logs. For configuration details, see Logger settings.

 ![](images/query_manager/query_history/query-history-data-editor.png)