The issue
AWS Aurora enforces a 15 minute expiration of password. To manage this, popular postgres client tools like pgAdmin have a setting to regenerate passwords in the background. This is missing as of now in the VS Code extension. The settings are Password exec command which is usually set to /opt/homebrew/bin/aws rds generate-db-auth-token --hostname=<hostname> and Password exec expiration (seconds), which I usually set as 840, which means the password is regenerated at 14 minutes.
Screenshot from pgAdmin
VS Code version
Version: 1.108.2
Commit: c9d77990917f3102ada88be140d28b038d1dd7c7
Date: 2026-01-21T13:52:09.270Z (2 wks ago)
Electron: 39.2.7
ElectronBuildId: 12953945
Chromium: 142.0.7444.235
Node.js: 22.21.1
V8: 14.2.231.21-electron.0
OS: Darwin arm64 24.6.0
Kindly look at including this setting asap.