[RDS] Support for database-insights-mode

[dhumphries-sainsburys]

What problem are you facing?

On 30th November 2025 performance insights is being removed from AWS in favour of cloudwatch database insights. In theory this is meant to be a seamless transition with the performance insights APIs still working but it would be better to outright support the options for database insights rather than relying on this.

We can see the options in the AWS CLI to manage this here under --database-insights-mode I assume that means it is technically possible to use for such as this

How could Crossplane help solve your problem?

Support setting database insight mode

[github-actions]

Crossplane does not currently have enough maintainers to address every issue and pull request. This issue has been automatically marked as stale because it has had no activity in the last 90 days. It will be closed in 14 days if no further activity occurs. Leaving a comment starting with /fresh will mark this issue as not stale.

[dhumphries-sainsburys]

/fresh not stale just not getting love

[tejavegesna-lb]

performanceInsightsEnabled
enablePerformanceInsights
and performanceInsightsRetentionPeriod

These are only options we see as of now

It would be great if you guys can support --database-insights-mode advanced

i agree with @dhumphries-sainsburys we need this before they remove insights in next month