Overview

In this schema, the cmdlet models licensing information and high-level overviews of the organizations, projects, and repositories associated with the authenticated account as read-only views.

Key Features

• The cmdlet models GitHub entities as relational views, allowing you to write SQL to query GitHub data.
• Stored procedures allow you to execute operations to GitHub.
• Live connectivity to these objects means any changes to your account are immediately reflected when using the cmdlet.

Views

Views are read-only tables that expose GitHub entities like licenses, organizations, and organization teams, as well as high-level information about projects and repositories tied to the authenticated account.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They are used to perform functions such as getting the currently authenticated user or retrieving and refreshing OAuth access tokens.