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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.