I can also create them with ssh

But I prefer to keep that info with the db connection, and have it automatically run when I connect

It's a pretty standard expectation (Navicat, DBeaver, etc)