search

aws / aws-toolkit-vscode

Amazon Q, CodeCatalyst, Local Lambda debug, SAM/CFN syntax, ECS Terminal, AWS resources
https://marketplace.visualstudio.com/items?itemName=AmazonWebServices.amazon-q-vscode
Apache License 2.0
1.5k stars 424 forks source link

RDS: connect to RDS via Secret Manager, etc. #1914

Open david2003542 opened 3 years ago

david2003542 commented 3 years ago

(adapted from #2582 by @justinmk3)

Problem

Connecting to an AWS RDS instance that is backed by AWS SecretManager credentials is manual process, and problematic when password rotation is enabled.

Expected behavior

A similar experience as IntelliJ for 'connect via secretmanager' to RDS from at least one SQL Explorer/editor tool.

https://aws.amazon.com/blogs/developer/seamlessly-connect-to-rds-and-redshift-instances-with-the-aws-toolkit-for-jetbrains/

Alternatives?

various different VSCode extensions, none seem to support 'connect via SecretManager', unsure if this is related to no integration option, or if integration option exists if no (known) extension supports it.

justinmk3 commented 3 years ago

We are interested in this, but no concrete plans yet. Do you have any thoughts on what this would look like? aws-toolkit-jetbrains uses JetBrains builtin data connectors. Does vscode have anything like that? What is the most popular/conventional extension?

I see that sqltools supports AWS Redshift.

At a minimum, we likely want to pass the Toolkit's credentials to extensions like sqltools somehow.