Table: gitlab_my_project

The gitlab_my_project table can be used to query information against projects that the authenticated user is a member of.

Examples

Get all projects you're associated with

select
  *
from
  gitlab_my_project;

Get top 10 projects you're associated with based on stars

select
  *
from
  gitlab_my_project
order by
  star_count desc
limit
  10;

Get project creation information

select
  u.username as creator,
  p.full_path as project,
  p.created_at as created
from
  gitlab_my_project p
  inner join gitlab_user u on p.creator_id = u.id;

Query examples

Schema for gitlab_my_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
allow_merge_on_skipped_pipeline	boolean		Indicates if merges are allowed if the pipeline is skipped.
analytics_access_level	text		The access level for analytics.
approvals_before_merge	bigint		The project setting for number of approvals required before a merge request can be merged.
archived	boolean		Indicates if the project is archived.
autoclose_referenced_issues	boolean		Indicates if referenced issues will be automatically closed by merges in the project.
avatar_url	text		The url for the projects avatar.
builds_access_level	text		The access level for builds.
ci_config_path	text		The path of the CI configuration.
ci_forward_deployment_enabled	boolean		Indicates if ci forward deployments are enabled.
ci_separated_caches	boolean		Indicates if the CI uses separate caches.
commit_count	bigint		The number of commits on the project.
container_expiration_policy	jsonb		JSON Object outlining the expiration policy attached to the container registry.
container_registry_access_level	text		Access level of current user for the container registry.
container_registry_enabled	boolean		Indicates if the project has the container registry enabled.
container_registry_image_prefix	text		The image prefix for the container registry.
created_at	timestamp with time zone		Timestamp of when project was created.
creator_id	bigint		The ID of the projects creator. - link to `gitlab_user.id`
default_branch	text		The projects default branch name.
description	text		The projects description.
empty_repo	boolean		Indicates if the repository of the project is empty.
fork_parent_id	bigint		ID of the fork parent.
fork_parent_name	text		Full name of the fork parent.
fork_parent_path	text		Full path of the fork parent.
fork_parent_url	text		The url of the fork parent.
forking_access_level	text		The access level for forks/forking.
forks_count	bigint		The number of forks of the project.
full_name	text		The projects name including namespace.
full_path	text		The projects path including namespace.
http_url	text		The http url to the project repository.
id	bigint	=	The ID of the project.
import_error	text		Error of importing project (if any).
import_status	text		Status of project import.
issues_access_level	text		The access level for issues.
issues_enabled	boolean		Indicates if project has issues enabled.
job_artifacts_size	bigint		The size of projects job artifacts on disk.
jobs_enabled	boolean		Indicates if the project has jobs enabled.
last_activity_at	timestamp with time zone		Timestamp of when last activity happened on the project.
lfs_enabled	boolean		Indicates if the project has large file system enabled.
lfs_objects_size	bigint		The size of the projects LFS objects on disk.
license	text		The projects license type.
license_key	text		The projects license spdx id/key.
license_url	text		The url for the license of the project.
marked_for_deletion_at	timestamp with time zone		Timestamp of when project was marked for deletion.
merge_method	text		The projects default merge method (merge, squash, rebase, etc).
merge_requests_access_level	text		The access level for merge requests.
merge_requests_enabled	boolean		Indicates if merge requests are enabled on the project
mirror	boolean		Indicates if the project is a mirror
mirror_overwrites_diverged_branches	boolean		Indicates if the mirror can overwrite diverged branches.
mirror_trigger_builds	boolean		Indicates if the mirror can trigger builds.
mirror_user_id	bigint		ID of the user whom configured the mirror
name	text		The projects name.
namespace_full_path	text		The full path of the namespace to which the project belongs.
namespace_id	bigint		The ID of the namespace to which the project belongs.
namespace_kind	text		The kind of the namespace to which the project belongs.
namespace_name	text		The name of the namespace to which the project belongs.
namespace_path	text		The path of the namespace to which the project belongs.
only_allow_merge_if_all_discussions_are_resolved	boolean		Indicates if merges are only allowed when all discussions are resolved.
only_allow_merge_if_pipeline_succeeds	boolean		Indicates if merges are only allowed when the pipeline succeeds.
only_mirror_protected_branches	boolean		Indicates if only protected branches are mirrored.
open_issues_count	bigint		A count of open issues on the project.
operations_access_level	text		The access level for operations.
owner_id	bigint		The projects owner ID. (null if owned by a group) - link to `gitlab_user.id`
owner_name	text		The display name for the projects owner.
owner_username	text		The projects owner username. (null if owned by a group) - link to `gitlab_user.username`
packages_enabled	boolean		Indicates if the project has packages enabled.
pages_access_level	text		The access level for pages.
path	text		The projects path.
public	boolean		Indicates if the project is public
public_jobs	boolean		Indicates if the project has/allows public jobs.
readme_url	text		The url for the projects readme file
remove_source_branch_after_merge	boolean		Indicates if source branches are removed after merge by default on the project.
repository_access_level	text		The access level for the repository.
repository_size	bigint		The size of the projects repository on disk.
repository_storage	text		The type of storage used by the repository.
request_access_enabled	boolean		Indicates if the project has request access enabled.
resolve_outdated_diff_discussions	boolean		Indicates if outdated diff discussions should be resolved.
runners_token	text		The token used for runners by the project.
shared_runners_enabled	boolean		Indicates if the project has shared runners enabled.
snippets_access_level	text		The access level for snippets.
snippets_enabled	boolean		Indicates if the project has snippets enabled.
ssh_url	text		The ssh url for the project repository.
star_count	bigint		The number of stars given to the project.
storage_size	bigint		The size of the project on disk.
tag_list	jsonb		An array of tags associated to the project.
topics	jsonb		An array of topics associated to the project.
visibility	text		The projects visibility level (private/public/internal)
web_url	text		The projects url.
wiki_access_level	text		The access level for the wiki.
wiki_enabled	boolean		Indicates if the project has the wiki enabled.