Can I query something to find the repo URL path from the repo number?

Question

From the admin side of stash, we have the repository numbers. From the command line, can I query something, like the database, to learn the URL path for each number? I know the server name, so I just need the {project}/{repo.git} value.

Thank you,

John

jcurleyWR · Accepted Answer

I found a way to query the DB:

select repository.id,project.project_key,repository.slug FROM repository LEFT JOIN project on project.id=repository.project_id order by repository.id;