how do I query the list of all repositories using SQL

Abdulqudus Oladega June 17, 2023

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

1 answer

1 accepted

1 vote
Answer accepted
Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 17, 2023

@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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.21.0
TAGS
AUG Leaders

Atlassian Community Events