Thanks for asking - I updated the documentation (deploying soon) but here it is
postgres://user:password@server_address:port/database_name. For MySQL replace ‘postgres’ with ‘mysql’
Concrete example:
postgres://ricardo:secret_password@128.203.134.78:5432/employees
Now, your server port / configuration might differ. Here are the steps I took to test, generally going up the OSI stack (see https://support.rackspace.com/how-to/mysql-connect-to-your-database-remotely/)
- Can I ping the remote server? (sometimes pings are disabled, check with your administrator)
- Can I telnet to the machine?
- Does the user have rights to connect remotely?
- Do I have the right password?
Lots of really good tutorials on how to test out there.
I set up a mysql server for y’all so you can test.
Here are the deets:
mysql://knockknock:whosthere@162.243.34.135:3306/employees
The database loaded on it:
https://dev.mysql.com/doc/employee/en/sakila-structure.html
(Please be kind to the DB, you have full rights to it. If someone renders it unusable, I have an image I can restore from so just ask 
)
Here’s a sample MySQL parameterized query and one way to map returned columns:
And a PostgreSQL query with parameters:
And a full example in the forum app: