First off, the Keychain is cool. Yeah, it can be a pain in the (hind quarters), but from a perspective of a secure place to store passwords and other secure data, it is excellent. The API to access can be a little obtuse, it took 2 days of trial and error to get everything saving just the way I wanted, but in the end, the result is worth the effort.
What brings all of this up? well in working on PGSQLKit, the new common Login dialog will allow the user to save connection information into named connections in the Keychain, as well as pull up saved connections from the keychain, as opposed to using the command line method of dumping this information into a text file in the users home directory.
That said, the work on the PGSQLKit continues, and with a little luck in the form of some free time, the first release of the automator tools built on top of it will come in the next 8 weeks.