TablePlus icon indicating copy to clipboard operation
TablePlus copied to clipboard

Feature request: retrieve temp password token by executing command

Open KingMob opened this issue 4 years ago • 3 comments

Our org recently switched to using ADFS IAM authentication for our Aurora Pg credentials. This means we don't have a static, saved password any more, but we have to get credentials on the fly via something like:

export RDSHOST="mypostgres-cluster.cluster-123456789012.us-west-2.rds.amazonaws.com"
export PGPASSWORD="$(aws rds generate-db-auth-token --hostname $RDSHOST --port 5432 --region us-west-2 --username jane_doe )"

It would be great if TablePlus could run a script to retrieve the password, so we don't have to do it manually every time.

(While less important, this would be useful for the hostname, too. AWS IAM ADFS doesn't support CNAMEs for clusters yet, so while rare, it's possible for the dynamic hostname to change as well.)

KingMob avatar Jun 25 '21 15:06 KingMob

This would be really helpful for those of us on Azure Cloud as well who utilize security groups via IAM to authorize user access.

AlexDCraig avatar Oct 13 '21 16:10 AlexDCraig

This would also be very helpful for us a Lenus eHealth

janmeier avatar Oct 27 '21 09:10 janmeier

I believe it should support dynamic usernames as well so it could be used with Hashicorp Vault.

fernandocarletti avatar Jul 13 '22 15:07 fernandocarletti

TablePlus now supports getting the password via Command Line IAM.

CleanShot 2022-09-23 at 15 09 27@2x

if you have a chance, please try this patch: https://www.dropbox.com/s/3rkgc4yylrr9buj/TablePlus.dmg?dl=0 Please let me know if you're seeing any issue.

huyphams avatar Sep 23 '22 08:09 huyphams

@huyphams sorry to comment on a closed PR; is it possible to not hide the password input, when the type is Command Line?

zoispag avatar Oct 17 '23 12:10 zoispag