query to find which repos are belongs to which project in crucible .

[microgenesis.swain]

In our environment we have 250 projects and 780repos . 

How to know which repos are belongs to which projects .

we need a db query for this .

[Martin Runge]

Hi @microgenesis.swain

Welcome to the Atlassian Community!

Since this thread is a couple of years old now, did you already get this sorted? If you still need it, here is how I would approach it.

In Crucible, each project defaults to a specific repository, so what you need is a project-to-repository lookup. Instead of querying the database, something Atlassian does not support, I recommend retrieving this information directly from the REST API:

GET /rest-service/projects-v1

That returns all 250 projects, along with their key and default repository name, in a single call. You can view the data in a browser as an admin, or use curl piped through jq to get a clean table.