For work and fun, I frequently have to dive deeper into databases to setup data schemas, analyze tables and connect backend APIs to their source. I frequently use Dbeaver to help me manage all the different connections needed. The challenge is that I often forget passwords since I have at least 10 different connections.

Here’s a simple code snippet that lets you retrieve the connection credentials from DBeaver on Mac:

openssl aes-128-cbc -d -K babb4a9f774ab853c96c2d653dfe544a -iv 00000000000000000000000000000000 -in "${HOME}/Library/DBeaverData/workspace6/General/.dbeaver/credentials-config.json" | dd bs=1 skip=16 2>/dev/null