how do I query the list of all repositories using SQL

[Abdulqudus Oladega]

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

[Kurt Klinner · Accepted solution]

@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