How to access Crowd database using Crowd API?

[Kavin Desai]

I am new to JIRA and CROWD and I am trying to get user data along with their attributes from the crowd database. How can I get that data by using the CROWD API?

I am writing the scripts in Python.

[Edwin Kyalangalilwa]

Hi @Kavin Desai,

You can use one of these Python client libraries for Crowd

1. python-crowd
2. crowd-api-python

[Kavin Desai]

Thank you for your reply.

I will look at those packages. I looked at the Crowd database schema page, and they have these tables and they have mentioned SQL queries to get data from them.

Where can I run these SQL queries?

https://developer.atlassian.com/server/crowd/database-schema-and-example-sql-for-crowd/

[Edwin Kyalangalilwa]

Those queries are run in either the terminal when connected to the database or using a SQL client.

What type of database are you using?

[Kavin Desai]

I don't know what database is being used.
Can I open a connection in MySQL workbench to the CROWD database and run queries there?

https://community.atlassian.com/t5/Questions/User-Activity-Usage-Login-Report/qaq-p/107893

This post talks about the crowd DB, accessing those would be perfect for me.