How to Integrate RDS Performance Insights with Grafana Running Outside AWS (Top Waits, Top SQL , Hosts, etc.)?

Grafana
1

I have successfully configured CloudWatch as the data source in my Grafana instance running outside AWS, and I am able to retrieve relevant RDS metrics (such as CPU utilization, DB connections, etc.). However, I also want to include RDS Performance Insights data (e.g., Top SQL, Top users, Top applications, Top databases etc.) in the same Grafana dashboard.

I’m wondering if there’s any way to access RDS Performance Insights metrics and pull them into Grafana through CloudWatch or any other method, given that I’m running Grafana externally from AWS.

Would appreciate any guidance on how to achieve this integration!

Thanks in advance

2

No guidance, but idea (so you have to figure out actual implementation and improvements):
Use AWS API GW to define own API, which will be proxying requests to AWS Performance Insight API - you can use Infinity datasource to call that your API from Grafana.

Of course better (more Grafana native) option will be if you write datasource plugin for this use case.