SequelPro

SequelPro is a MySQL Database Client for OSX available from https://www.sequelpro.com/.

It has support for connecting to databases over an SSH tunnel. The client does support the agent however you need to either launch SequelPro from a Terminal shell or make changes to its Info.plist to ensure it has the correct path for the agent socket as defined in SSH_AUTH_SOCK.

Launching from Terminal

As part of the installation of the Desktop Agent some entries are made to your ~/.bash_profile to point supporting clients to the socket used for communication with the agent. Launching SequelPro from Finder does not pick these up. If you open a terminal and use the open command it will pick up the correct settings

open /Applications/Sequel\ Pro.app/

Changing the Launch PLIST

A more permanent solution for launching SequelPro through Finder is to edit the applications bundle’s Info.plist.

To do this you need to find the application in /Applications using Finder and right-click to get the context menu.

Select the Show Package Contents option. Then you want to find the Info.plist in the listing.

Add following entry to the plist file, changing the path of the socket to suit your environment. A link to the agent’s socket is created in the .desktop-ssh-agent folder under your home directory.

If you do not have XCode installed, double click on the Info.plist file and it will open up in TextEdit. If you do have XCode installed it will open in a PList editor, in that case, use the Open With option in Finder and select TextEdit.

You can put the entry right at the top, paste the following in after the first <dict> element but before the next <key> element. Make sure you change __path_to_home___ to the full path of your own home directory. Please note that using ~/.desktop-ssh-agent syntax is not valid.

<key>LSEnvironment</key>
<dict>
    <key>SSH_AUTH_SOCK</key>
    <string>__path_to_home___/.desktop-ssh-agent/agent.sock</string>
</dict>

Next, before you launch the app, open a terminal, and execute the following command. This is required for the launch subsystem to pick up the changes.

touch /Applications/Sequel\ Pro.app/

Authenticating with the Agent

There is no configuration necessary. Just use the SSH connection option and ensure you do not enter a password or provide the path to a private key. Click on Connect and SequelPro will contact the agent to see if there are any valid keys for authentication.