Sonar Metrics report from SonarQube DB

I am trying to extract code coverage and metrics report (count of bugs, code smells, vulnerabilities) for different application components from sonarqube db. What tables and relevant fields should I consider to extract such report?


is there a specific reason for not to use the recommended Sonarqube web api ?
The Sonarqube database should be regarded as ‘black box’, don’t touch it.

see web api docs => https://yoursonarhost/web_api

You didn’t reveal your Sonarqube version and edition.
Sonarqube 9.x Enterprise edition ($) has project and security reports.
If using Sonarqube Community until 8.9.x LTS you may consider the cnes report plugin as an alternative.


Hi Gilbert,

Below is my sonarqube version and edition
" * Community Edition

  • Version 7.9.4 (build 35981)
  • LGPL v3"

I have read only access to the sonar qube db. My aim is to replicate the db data in to power bi and thus i want reports directly from the sonarqube db. Is there any possible way to do that?