Github Copilot - Azure Data Studio

---

---

GitHub Copilot is an AI pair programmer that helps you write code faster and with less effort. It is available as a plugin for various IDEs and code editors. In this article, we will learn how to use GitHub Copilot in Azure Data Studio.

How to Setup Copilot in Azure Data Studio?

Follow these steps to set up GitHub Copilot in Azure Data Studio:

Step 1: Install Azure Data Studio

If you don't already have Azure Data Studio installed on your system, you can download it from the official website. Choose the appropriate version for your operating system and follow the installation instructions.

Step 2: Install GitHub Copilot Extension

Once you have Azure Data Studio installed, you can install the GitHub Copilot extension from the Azure Data Studio Marketplace. For this go to extension section and search for copilot, the first search result will be Github Copilot.

Step 3: Sign in to Copilot

After installing the GitHub Copilot extension, A pop up to sign in to copilot will be displayed on bottom right corner of you screen as shown in the image. Click on "Sign in to Copilot" button

Step 4: Login in to GitHub

After clicking on "Sign in to Copilot" button, you will be redirected to github login page. Enter your github credentials and click on "Sign in" button. Make sure to that you already registered for copilot in your github account. We have a separate article on register for copilot.

Step 5: Start Using Copilot

Now you copilot is ready to use. Open any project directory you are working, you can see copilot icon at bottom right corner of your vscode screen. When you start typing a yellow symbol will be displayed near to cursor caret. By click on this yellow symbol you can ask copilot to generate code or fix existing code. You can also see a copilot chat section just below extension tab, this can be used to ask doubt while coding.

Getting Code Suggestion

GitHub Copilot will provide inline code suggestions while working with SQL databases in Azure Data Studio. For example, when writing a query like joining tables, Copilot can suggest the join condition based on the columns in the editor, other files in the workspace, and common syntax patterns."

GitHub Copilot will automatically suggest a join condition in grayed text. To accept the suggestion, press Tab.

Accepting Alternative Suggestions

For some suggestions, GitHub Copilot may provide multiple alternatives. If you want to see alternative suggestions, you can press the down arrow key to cycle through the suggestions. This will help you choose the best suggestion for your query.

Accepting Partial Suggestions

GitHub Copilot may provide suggestions that are partially correct or incomplete. In such cases, you can accept the partial suggestion and continue typing to complete the code. Following is the shortcut code to accept next word in copilot's suggestion.