From: praba2210 (@praba2210) <noreply+praba2210@github.com>
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
Subject: [postgresql-interfaces/psqlodbc] issue #217: Proposal: Add optional Native Amazon Aurora DSQL Support
Date: Thu, 24 Sep 2026 22:58:49 +0000
Message-ID: <gh-postgresql-interfaces-psqlodbc-217@github.com> (raw)
### Summary
Hi, I’m a developer on the Amazon Aurora DSQL team. Aurora DSQL uses the PostgreSQL wire protocol with IAM authentication and TLS. psqlODBC users currently require external code or proxies to generate and manage IAM tokens, adding operational complexity.
### Proposed Support
Add an optional Aurora DSQL connection mode that:
- Uses the AWS credential chain.
- Resolves the AWS Region from the DSQL endpoint.
- Generates the appropriate IAM token for each new connection.
- Supports standard and admin database roles.
- Handles full-length tokens securely without persisting them.
- Enforces TLS certificate and hostname validation.
- Applies DSQL-compatible connection and session behavior.
The implementation would be isolated so existing PostgreSQL behavior remains unchanged. It may require an optional AWS authentication dependency, and I’m open to guidance on the preferred integration approach.
If this proposal is acceptable, I can prepare and submit a PR for upstream review. Looking forward to your feedback. Thanks!