Connecting and executing SQL statements

• Connection alias: Type the name to be used when referring to this connection.
• Driver: Select the alias that you provided for your driver from the drop-down menu.

• Database URL: Copy and paste your connection URL into this field. The following examples show how to connect using either Basic or OAuth 2.0 access token grant authentication.
  Note: You can also generate connection strings using GitHub Configuration Manager. For more information, see Generating connection URLs with the Configuration Manager.

  Basic

  jdbc:datadirect:github:ServerName=api.github.com;AuthenticationMethod=Basic;
  User=jsmith;Password=secret;

  Note: See Basic authentication for details.

  OAuth 2.0 access token grant

  jdbc:datadirect:github:ServerName=api.github.com;AuthenticationMethod=OAuth2;
  AccessToken=token;

  Note: See OAuth 2.0 authentication for details on this and other supported grant types.
• Database UserId: If required by the authentication method being used, enter the user name. Alternatively, this value can be specified with the User property in the connection string.
• Database Password: If required by the authentication method being used, enter the password. Alternatively, this value can be specified with the Password property in the connection string.

• Database Connection: Select connection alias you provided for the connection from the drop-down menu.
• Schema: Select the schema you want to execute queries against from the drop-down menu.

To select all of the rows from the BRANCHES table:

SELECT * PUBLICREPOS 

To select the URLs for a specified issue:

SELECT ID FROM PUBLICREPOS WHERE ID = <REPOID> 

See "Supported SQL statements and extensions" for the supported syntax used to execute SQL statements.