Export JIRA portfolio data from database

[Heshan Manamperi]

Is any one know how to export following data directly from JIRA db. These are portfolio data. 

column I requires in output of db query is:
-User's Name
-weekly hours
-Team name
-Plan name
-Team velocity

[Nic Brough -Adaptavist-]

That would take days to work out, probably.  Using the database for reporting in Jira is the single worst possible option.  It is not designed for reporting at all, it is a data store and hence even the most simple questions you think might be easy in SQL are a nightmare.

I'd suggest you have a look at the reports and reporting add-ons in the marketplace.