Add support for SSH tunnels

[ciminelli]

This should be an option to connect to the database instead of connecting to the Postgres host directly.

We'll need to:

1. Add a new option to the "Connect Database" page
2. Update the connect-database endpoint to support the SSH options (server host, connection port, login username, key or password authentication)
3. Support SSH key authentication or password authentication

More info can be found with how Airbyte supports this type of connection: https://docs.airbyte.com/integrations/sources/postgres/#connect-via-ssh-tunnel

[AkshayAwate]

No description provided.

@ciminelli looking for more description.

[ciminelli]

No description provided.

@ciminelli looking for more description.

Just updated the description, let me know if this is something you'd be interested in and I can work with you on it!

[AkshayAwate]

Yeah, This is my understanding:
Current workflow, install inquery and then add details of postgres host, then connect. So now instead of connecting directly to postgres host, now will have "Connect Database" page, so this will connect using ssh as per this doc. Am i right ? please feel free to correct 😄.

[ciminelli]

Yeah, This is my understanding: Current workflow, install inquery and then add details of postgres host, then connect. So now instead of connecting directly to postgres host, now will have "Connect Database" page, so this will connect using ssh as per this doc. Am i right ? please feel free to correct 😄.

Yes, but the SSH connection option will be right on the connect database page! We can make a dropdown to select the SSH connection option.