To store the passphrase for your default key in the Keychain open a Terminal and run:
And to store the passphrase for a different key run:
ssh-add -K /path/to/private/key/file
When prompted for your passphrase enter it and that is it.
You will never need to run ssh-add nor enter your passphrase again.