Support Amazon Aurora DSQL as a connectable database · Issue #20653 · bytebase/bytebase · GitHub
Skip to content

Support Amazon Aurora DSQL as a connectable database #20653

Description

@ouchi2501

Is your feature request related to a problem?

Bytebase can't currently connect to Amazon Aurora DSQL. DSQL speaks the PostgreSQL wire protocol, so it would be natural to manage it as a Postgres-type instance, but two DSQL-specific requirements block the connection today:

  1. SNI is required. Aurora DSQL routes by hostname and rejects TLS handshakes whose ClientHello carries no SNI. On Bytebase's password/SSL path, util.GetTLSConfig builds a tls.Config without ServerName, so no SNI is sent and the handshake is refused.
  2. DSQL needs its own IAM auth token. DSQL does not support password auth; it requires an IAM token signed for the dsql:DbConnectAdmin / dsql:DbConnect actions via aws-sdk-go-v2/feature/dsql/auth. This differs from the RDS/Aurora token produced by feature/rds/auth, which Bytebase uses today, so there is no way to
    authenticate to DSQL.

Describe the solution you'd like

Allow Bytebase to connect to Aurora DSQL endpoints as a PostgreSQL-compatible instance:

  • Send SNI (ServerName) on the PostgreSQL TLS path so DSQL accepts the handshake (skipping literal IPs per RFC 6066).
  • On the AWS IAM authentication path, detect DSQL cluster endpoints (.dsql..on.aws) and sign the correct DSQL token — using the admin variant (dsql:DbConnectAdmin) for the built-in admin role and the regular variant (dsql:DbConnect) for custom database roles. The token is signed against the cluster endpoint
    hostname.
  • Avoid sending session/startup parameters DSQL rejects (e.g. default_transaction_read_only), which would otherwise fail read-only connections (read-only data sources, data export).

Configuration would reuse the existing AWS RDS IAM authentication type and AWS credentials — no new UI option — with DSQL auto-detected from the endpoint.

Additional context

Activity

  1. added theissue type on Jul 23, 2026
  2. zchpeter commented on Jul 23, 2026

    @zchpeter
    Collaborator

    Hi @ouchi2501 , thanks for the feature request, we have created an internal ticket for this, tracked in BYT-9927
    This feature request requires some internal discussion on long term support for this.

  3. ouchi2501 commented on Jul 23, 2026

    @ouchi2501
    Author

    @zchpeter

    Thanks for picking this up and filing BYT-9927! Since I can’t see your Linear board, I’d really appreciate it if any updates from the internal discussion could be shared here on this issue. Thanks!

  4. ouchi2501 commented on Aug 3, 2026

    @ouchi2501
    Author

    Hi @zchpeter ,
    We are currently evaluating Bytebase for adoption within our organization, and this Aurora DSQL support is a hard blocker for us — we cannot move forward with Bytebase until this is resolved.
    Could you share the current timeline or priority level for this work? Any rough estimate of when this might land in a release would be very helpful for our planning.
    Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions