how do I query the list of all repositories using SQL

Question

What is the SQL query to get the list of all repositories present in a Bitbucket server?

Kurt Klinner · Accepted Answer

@Abdulqudus Oladega

Welcome to the Atlassian community

select rep.name AS "Repository Name"
     , rep.slug AS "Repository Slug"
FROM repository rep

if you would like to join also the project which the repos belong to you can take a look to

https://confluence.atlassian.com/bitbucketserverkb/how-to-obtain-a-list-of-all-projects-and-repositories-from-bitbucket-database-975027747.html

Cheers

Kurt