(I can't add comments so adding as a separate answer to extend/confirm https://stackoverflow.com/a/66156035/1535127):

Within SSH Tunnel of DBeaver it doesn't work but possible with https://github.com/libfuse/sshfs which makes DBeaver think that files are local.

1. Install sshfs (sudo apt-get install sshfs or brew install macfuse sshfs)
2. Create mount point mkdir -p ~/sshfs/myapp-data
3. Mount the remote directory sshfs -o IdentityFile=~/.ssh/id_rsa -o allow_other deploy@$(VM_IP):/opt/myapp/data ~/sshfs/myapp-data where VM_IP is IP of VM or domain.
4. In DBeaver or other SQLite GUI tool:

• New Database Connection → Select SQLite
• Path: ~/sshfs/myapp-data/data.db (or full path: /home/username/sshfs/myapp-data/data.db)

It is quite performant, depends on SSH tunnel performance.