How to connect with Jira Cloud database?

[Kishor Ghongade]

How to connect with the Jira Cloud database? we want to fetch some details related to login users details from Jira cloud database etc.

[Nic Brough _Adaptavist_]

If by "connect", you mean "log in and use SQL", you do not.  You have no direct access to it.

You have to get to your data via the application, either using the UI or REST APIs.

[Kishor Ghongade]

We wanted to fetch reports kind of data for our Jira cloud site e.g. users logged in in past N days. We wanted to check frequency of users logging-in during weekend or for last one week or for last one month. We need these details so that we can plan our Jira migration task accordingly. Can this be achieved using REST APIs? or is there any other way by which we can fetch this kind of information?

[Nic Brough _Adaptavist_]

That level of tracking is not yet available in the REST APIs, but admins can see last logins in the list of users - a manual check, yes, but it's a simple one.

If you're planning a migration though, it's not really a lot of use.  You shouldn't actually be worrying about it.  You should be simply telling all your users "Migration is happening at this time, you will not have access to the old system from that point"