Projects are used by teams to organize repositories.
bitbucket_project table can be used to query information about ANY repository, and you must specify which repository in the where or join clause (
where workspace_slug =,
join bitbucket_project on workspace_slug =).
To list all the your projects use the
bitbucket_my_project table instead. The
bitbucket_my_project table will list projects you own, you collaborate on, or that belong to your workspaces.
Get information about a specific project
selectname,uuid,key as project_key,workspace_slug,owner_display_name,is_privatefrombitbucket_projectwhereworkspace_slug = 'np1981';
A Bitbucket project. Projects are used by teams to organize repositories.
|created||timestamp without time zone||Timestamp when project was last updated.|
|description||text||A usefule description for thr project.|
|is_private||boolean||Indicates whether the project is publicly accessible, or whether it is private to the team and consequently only visible to team members. Note that private projects cannot contain public repositories.|
|key||text||The project's key.|
|name||text||The name of the project.|
|owner_display_name||text||Display name of the owner of this project.|
|owner_type||text||Type of the owner of this project.|
|owner_uuid||text||UUID of the owner of this project.|
|self_link||text||A self link to this project.|
|title||text||Title of the resource.|
|type||text||Type of the Bitbucket resource.|
|updated||timestamp without time zone||Timestamp when project was last updated.|
|uuid||text||The project's immutable id.|
|workspace_slug||text||Slug name of the workspace to which this project belongs.|