How to make TablePlus use 1Password-stored SSH keys
On this page
I set up an SSH key on my server and stored it on 1Password, but recently, I wanted to access the database on that server via Tableplus.
It was tricky because I couldn't find a way to send the SSH key information to TablePlus via the UI.
After googling around, it turns out it's very easy to do it via the command line; here's the code:
export SSH_AUTH_SOCK=~/Library/Group\ Containers/2BUA8C4S2C.com.1password/t/agent.sock; open -a /Applications/Setapp/TablePlus.app
Just replace /Applications/Setapp/TablePlus.app
with your TablePlus installation path.
I set this up as an alias so it's easy for me to remember:
alias tableplus="export SSH_AUTH_SOCK=~/Library/Group\ Containers/2BUA8C4S2C.com.1password/t/agent.sock; open -a /Applications/Setapp/TablePlus.app"