Repositories

Provides comprehensive details about user-owned or managed repositories, including configuration and metadata.

Table-Specific Information

Select

The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

Name supports the '=,!=' comparison operators.
OwnerLogin supports the '=,IN' comparison operators.
ForkCount supports the '=,>,>=,<,<=' comparison operators.
StargazerCount supports the '=,>,>=,<,<=' comparison operators.
TopicCount supports the '=,>,>=,<,<=' comparison operators.
IsArchived supports the '=' comparison operator.
IsFork supports the '=' comparison operator.
IsMirror supports the '=' comparison operator.
IsPrivate supports the '=' comparison operator.
LicenseKey supports the '=,!=' comparison operators.
LanguageName supports the '=,!=' comparison operators.
PushedAt supports the '=,>,>=,<,<=' comparison operators.
CreatedAt supports the '=,>,>=,<,<=' comparison operators.

For example, the following queries are processed server-side:

SELECT * FROM [Repositories]
SELECT * FROM [Repositories] WHERE [Name] = 'Val1'
SELECT * FROM [Repositories] WHERE [OwnerLogin] = 'Val1'
SELECT * FROM [Repositories] WHERE [ForkCount] = 123
SELECT * FROM [Repositories] WHERE [StargazerCount] = 123
SELECT * FROM [Repositories] WHERE [TopicCount] = 123
SELECT * FROM [Repositories] WHERE [IsArchived] = true
SELECT * FROM [Repositories] WHERE [IsFork] = true
SELECT * FROM [Repositories] WHERE [IsMirror] = true
SELECT * FROM [Repositories] WHERE [IsPrivate] = true
SELECT * FROM [Repositories] WHERE [LicenseKey] = 'Val1'
SELECT * FROM [Repositories] WHERE [LanguageName] = 'Val1'
SELECT * FROM [Repositories] WHERE [PushedAt] = '2023-01-01 11:10:00'
SELECT * FROM [Repositories] WHERE [CreatedAt] = '2023-01-01 11:10:00'

The 本製品 processes other filters client-side within the 本製品.

Insert

You can use the following columns to create (insert) a new record:

Name
OwnerId
Visibility
Description
HomepageUrl
HasIssuesEnabled
HasWikiEnabled
IsTemplate

You can use the following pseudo-column to create a new record: TeamId

INSERT INTO [Repositories] ([Name], [OwnerId], [Visibility], [HasWikiEnabled]) VALUES ('APIRepo', 'MDQ6VXNlcjg3ODExMTEx', 'PRIVATE', true)
INSERT INTO [Repositories] ([Name], [OwnerId], [Visibility], [HomepageUrl], [TeamId]) VALUES ('OrgRepo', 'O_kgDOCfyf0Q', 'PRIVATE', 'www.test.com', 'T_kwDOCfyf0c4AmRiX')

Update

You can use the following columns to update a record:

Name
Description
HomepageUrl
HasDiscussionsEnabled
HasIssuesEnabled
HasProjectsEnabled
HasWikiEnabled
HasSponsorshipsEnabled

You can use the following column to archive a record: IsArchived

You can use the following column to unarchive a record: IsArchived

UPDATE [Repositories] SET [Name] = 'NewRepoNameTest', [Description] = 'Test description.', [HasProjectsEnabled] = true WHERE [Id] = 'R_kgDOML7svg'
UPDATE [Repositories] SET [IsArchived] = false WHERE [Id] = 'R_kgDOML7svg'
UPDATE [Repositories] SET [IsArchived] = true WHERE [Id] = 'R_kgDOML7svg'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier (node ID) of the repository.
DatabaseId	Int	True		The primary key identifier for the repository in the database, used for internal reference.
Name	String	False		The name of the repository, as set by its owner.
NameWithOwner	String	True		The repository's name, prefixed with the owner's username or organization (for example, 'owner/repository-name').
OwnerId	String	True		The unique identifier (node ID) of the owner of the repository, which could be a user or organization.
OwnerLogin	String	True		The login (username) of the repository's owner, which could be a user or organization.
Visibility	String	True		The visibility level of the repository ('public', 'private', or 'internal').
DiskUsage	Int	True		The amount of disk space (in kilobytes) occupied by the repository.
ForkCount	Int	True		The total number of forks created from this repository across the network.
StargazerCount	Int	True		The total number of users who have starred this repository.
WatcherCount	Int	True		The total number of users watching this repository for updates.
TopicCount	Int	True		The number of topics assigned to the repository to improve discoverability.
TempCloneToken	String	True		A temporary authentication token for cloning the repository.
WebCommitSignoffRequired	Bool	True		Indicates whether contributors must sign off on web-based commits to this repository.
UsesCustomOpenGraphImage	Bool	True		Indicates whether the repository uses a custom image for Open Graph instead of the owner's avatar.
Description	String	False		A brief text description of the repository, as provided by the owner.
DescriptionHTML	String	True		The HTML-rendered version of the repository's description for display purposes.
ShortDescriptionHTML	String	True		A simplified version of the repository's description, rendered in HTML without links.
ResourcePath	String	True		The relative HTTP path to access the repository on GitHub.
ProjectsResourcePath	String	True		The relative HTTP path listing the projects associated with this repository.
Url	String	True		The absolute HTTP URL to the repository's main page on GitHub.
HomepageUrl	String	False		The URL of the repository's homepage, if specified.
MirrorUrl	String	True		The URL of the repository's original mirror, if applicable.
ProjectsUrl	String	True		The absolute HTTP URL listing the projects associated with this repository.
SecurityPolicyUrl	String	True		The URL pointing to the repository's security policy, if available.
SSHUrl	String	True		The SSH URL used for cloning the repository.
OpenGraphImageUrl	String	True		The image used to represent this repository in Open Graph metadata.
MergeCommitTitle	String	True		Specifies how the default commit title is generated when merging a pull request (for example, 'pull request title').
MergeCommitMessage	String	True		Specifies how the default commit message is generated when merging a pull request (for example, 'pull request description').
SquashMergeCommitTitle	String	True		Specifies how the default commit title is generated when squash-merging a pull request (for example, 'pull request title').
SquashMergeCommitMessage	String	True		Specifies how the default commit message is generated when squash-merging a pull request (for example, 'pull request description').
DeleteBranchOnMerge	Bool	True		Indicates whether branches are automatically deleted after being merged in this repository.
HasDiscussionsEnabled	Bool	False		Indicates whether the Discussions feature is enabled for this repository.
HasIssuesEnabled	Bool	False		Indicates whether the Issues feature is enabled for this repository.
HasProjectsEnabled	Bool	False		Indicates whether the Projects feature is enabled for this repository.
HasWikiEnabled	Bool	False		Indicates whether the Wiki feature is enabled for this repository.
HasVulnerabilityAlertsEnabled	Bool	True		Indicates whether vulnerability alerts are enabled for this repository.
HasSponsorshipsEnabled	Bool	False		Indicates whether the repository displays a Sponsor button for financial contributions.
IsInOrganization	Bool	True		Indicates whether the repository is owned by an organization or is a private fork of an organization repository.
IsBlankIssuesEnabled	Bool	True		Indicates whether blank issue creation is allowed for this repository.
IsSecurityPolicyEnabled	Bool	True		Indicates whether the repository has a security policy in place.
IsUserConfigurationRepository	Bool	True		Indicates whether the repository is a user configuration repository.
IsArchived	Bool	True		Indicates whether the repository is archived and unmaintained.
IsDisabled	Bool	True		Indicates whether the repository is disabled.
IsEmpty	Bool	True		Indicates whether the repository is empty.
IsFork	Bool	True		Indicates whether the repository is a fork of another repository.
IsLocked	Bool	True		Indicates whether the repository has been locked.
IsMirror	Bool	True		Indicates whether the repository is a mirror of another repository.
IsPrivate	Bool	True		Indicates whether the repository is private and not publicly accessible.
IsTemplate	Bool	False		Indicates whether the repository is a template that can be used to generate new repositories.
LockReason	String	True		Specifies the reason why the repository has been locked, if applicable. 使用できる値は次のとおりです。BILLING, MIGRATING, MOVING, RENAME
TemplateRepositoryId	String	True		The unique identifier (node ID) of the template repository from which this repository was generated, if any.
ParentId	String	True		The unique identifier (node ID) of the parent repository, if this repository is a fork.
ForkingAllowed	Bool	True		Indicates whether forking is allowed for this repository.
AutoMergeAllowed	Bool	True		Indicates whether Auto-merge can be enabled on pull requests for this repository.
SquashMergeAllowed	Bool	True		Indicates whether squash-merging is enabled for pull requests in this repository.
RebaseMergeAllowed	Bool	True		Indicates whether rebase-merging is enabled for pull requests in this repository.
MergeCommitAllowed	Bool	True		Indicates whether pull requests can be merged with a merge commit in this repository.
AllowUpdateBranch	Bool	True		Indicates whether pull request head branches that are behind their base branches can always be updated even if not required for merging.
ViewerPermission	String	True		Specifies the permission level of the viewer on the repository (for example, 'read', 'write', 'admin'). Returns null if authenticated as a GitHub App. 使用できる値は次のとおりです。ADMIN, MAINTAIN, READ, TRIAGE, WRITE
ViewerSubscription	String	True		Indicates whether the viewer is watching, not watching, or ignoring the repository. 使用できる値は次のとおりです。IGNORED, SUBSCRIBED, UNSUBSCRIBED
ViewerHasStarred	Bool	True		Indicates whether the viewing user has starred this repository.
ViewerDefaultCommitEmail	String	True		The email address used by the viewer for their most recent commit in this repository.
ViewerDefaultMergeMethod	String	True		The last merge method used by the viewer (for example, 'merge', 'squash', 'rebase') or the repository's default merge method.
ViewerPossibleCommitEmails	String	True		A list of email addresses available for the viewer to use for committing in this repository.
ViewerCanAdminister	Bool	True		Indicates whether the viewer has administrative permissions on this repository.
ViewerCanSubscribe	Bool	True		Indicates whether the viewer can change their subscription status for the repository.
ViewerCanCreateProjects	Bool	True		Indicates whether the viewer can create new projects associated with this repository.
ViewerCanUpdateTopics	Bool	True		Indicates whether the viewer can update the topics (tags) of this repository.
CodeOfConductId	String	True		The unique identifier (node ID) of the Code of Conduct associated with this repository.
CodeOfConductName	String	True		The formal name of the Code of Conduct applied to this repository.
CodeOfConductBody	String	True		The full text of the Code of Conduct describing its rules and guidelines.
CodeOfConductKey	String	True		The unique key identifier for the Code of Conduct.
CodeOfConductUrl	String	True		The absolute HTTP URL to access the Code of Conduct for this repository.
CodeOfConductResourcePath	String	True		The relative HTTP path to access the Code of Conduct for this repository.
DefaultBranchRefId	String	True		The unique identifier (node ID) of the default branch in this repository.
DefaultBranchRefName	String	True		The name of the default branch in this repository (for example, 'main', 'master').
InteractionAbilityLimit	String	True		The current interaction restriction applied to this repository (for example, 'collaborators only').
InteractionAbilityOrigin	String	True		The source or reason for the currently active interaction restriction (for example, account settings, admin action).
InteractionAbilityExpiresAt	Datetime	True		The expiration date and time of the current interaction restriction, if applicable.
LatestReleaseId	String	True		The unique identifier (node ID) of the latest release in this repository.
LatestReleaseName	String	True		The title of the latest release in this repository.
LicenseId	String	True		The unique identifier (node ID) of the license associated with the repository.
LicenseKey	String	True	Licenses.Key	The SPDX key of the license associated with the repository (for example, 'mit', 'apache-2.0').
LanguageId	String	True		The unique identifier (node ID) of the primary programming language used in this repository.
LanguageName	String	True		The name of the primary programming language used in this repository (for example, 'JavaScript', 'Python').
LanguageColor	String	True		The hexadecimal color code associated with the primary programming language used in the repository.
PushedAt	Datetime	True		The date and time when the repository was last pushed to, in ISO 8601 format.
ArchivedAt	Datetime	True		The date and time when the repository was archived, in ISO 8601 format.
CreatedAt	Datetime	True		The date and time when the repository was created, in ISO 8601 format.
UpdatedAt	Datetime	True		The date and time when the repository was last updated, in ISO 8601 format.
PlanFeaturesCodeOwners	Bool	True		Indicates whether reviews can be automatically requested and enforced using a CODEOWNERS file.
PlanFeaturesDraftPullRequests	Bool	True		Indicates whether pull requests can be created as drafts or converted to drafts.
PlanFeaturesMaximumAssignees	Int	True		The maximum number of users that can be assigned to an issue or pull request in this repository.
PlanFeaturesMaximumManualReviewRequests	Int	True		The maximum number of manually requested reviews allowed on a pull request in this repository.
PlanFeaturesTeamReviewRequests	Bool	True		Indicates whether teams can be requested to review pull requests in this repository.

Pseudo-Columns

疑似カラムは、明示的にリストされているステートメントの型でのみ使用できるフィールドです。これらは標準のカラムではなく、特定の操作のための追加機能を提供するものです。


Name	Type	Description
TeamId	String	Specifies the team ID to be granted access to the repository when an organization is set as the owner.