Adding ability to get password from Azure CLI

[mkursadulusoy]

As a security improvement, my company changed passwords to access tokens for postgreSql database.

pgAdmin has Password exec command in the connection tab which can trigger a powershell script, uses Azure CLI, gets access token according to my user account and apply it as a password for database connection. It has a expiration time which is 60 minutes. After that time, pgAdmin gets the password again from AzureCLI and i can use the database without any interruption.

Even i searched all around the web, i couldn't find the equivelant way in Dbeaver. I have created a bat file doing:

@echo off
:: Get the Azure access token and store it in a variable
for /f "delims=" %%A in ('az account set --subscription "subscription name" ^& az account get-access-token --resource-type oss-rdbms --query accessToken -o tsv') do set TOKEN=%%A

:: Run the DBeaver CLI with the access token
"AppData\Local\DBeaver\dbeaver-cli.exe" -con "driver=postgresql|host=ip address|port=port number|database=database name|user=username|password=%TOKEN%|name=dbName|create=false|save=true"

This works okey for 1 hour but after that time, i need to run the same bat file again and lose my unsaved changes.

Is it possible to add a password exec command in dBeaver.

[ged-yuko]

There were at least these two discussions about the question on password-related scripting and automation:
https://github.com/orgs/dbeaver/discussions/36536
https://github.com/orgs/dbeaver/discussions/36531

[mkursadulusoy]

Thank you very much for the discussions. Even i made my own search i couldn't find them but this discussions explanatory enough for me.