Edit

Share via

Use the GitHub Copilot Chat experience in SQL Server Management Studio (Preview)

The Chat window for GitHub Copilot in SQL Server Management Studio (SSMS) enables enhanced AI-assisted database administration and development in SSMS, helping you be more productive and efficient when working with your SQL database. Currently, the chat window only executes SELECT queries (read-only).

In this article, you learn about using GitHub Copilot Chat in SSMS, a fully integrated AI-powered chat experience from GitHub Copilot that exists directly in SSMS. It enables you to get Transact-SQL (T-SQL) support, including syntax and context-specific help, without leaving the SSMS UI. Use the chat interface to submit your question as prompt and provide intent for better scoped answers.

Why use GitHub Copilot Chat in SSMS?

GitHub Copilot Chat provides AI assistance to help you make informed decisions about your SQL database and write better T-SQL faster. With an integration in SSMS that includes connection context and schema understanding, GitHub Copilot Chat understands what you're working on and can help with tasks including:

  • T-SQL assistance:

    • Get context-specific code suggestions and recommendations
    • Understand and document what a query does
    • Get assistance fixing syntax errors in your query
    • Refactor queries

  • Database administration:

    • Get help managing settings, security, and more
    • Configure and monitor database maintenance
    • Implement new SQL features

  • Database development:

    • Schema design
    • Data type selection
    • Indexing recommendations

Prerequisites

To use GitHub Copilot Chat in SSMS, you need SSMS 22 or a later version, and a GitHub account with Copilot access. Otherwise, you can use Use GitHub Copilot for free in SQL Server Management Studio (Preview).

Use Copilot Chat in SSMS

Ask database and T-SQL questions in natural language and GitHub Copilot Chat will answer them in the context of your database and its connection.

There are two places you can ask Copilot these questions; in the chat window, or directly inline in the code that you're looking to modify, using inline chat. For questions where your goal is to modify or add to the SQL file you have open in the editor, the inline chat view might work best, whereas more general T-SQL questions are best answered in the chat pane.

To improve Copilot chat results, learn how to use slash commands, reference files, and threads to get better answers with scoped context in Copilot Chat.

Ask questions in the chat window

The chat window of Copilot Chat in SSMS enables you to ask your questions and see answers in the chat pane. It's usually the preferred way to work with Copilot for database help and general T-SQL questions.

  1. Open a query editor window and connection to your database.
  2. In SSMS, select View > GitHub Copilot Chat.
  3. Use the example starter prompts in the chat window to start exploring Copilot Chat, or type in a prompt and select Enter or Send to submit your question.
  4. If Copilot Chat offers a T-SQL suggestion you want to use, select Apply to apply the code to the active query editor, Copy code block to copy the suggestion, or Add to new file to insert the code suggestion in a new file.
    • If you ask for help with understanding your code, the Insert in new file option isn't available.
  5. If you select Apply, the code suggestion is applied to the active editor in the diff view pattern. You can review and refine what is being proposed and apply it using Tab, or discard it using Alt+Delete.

Ask questions in the inline chat view

The inline chat view of Copilot Chat in SSMS enables you to ask your questions and see answers inline with the code directly in the editor window. With inline chat, you don't have to go back and forth to the chat window. You might find it easier to work with Copilot on questions that add to or update a currently open SQL file using inline chat.

  1. In SSMS, select Alt+/ to bring up the inline chat view of Copilot Chat in the editor.
  2. Type your T-SQL related question in the Ask Copilot text box, and then select Enter or Send to ask your question.
  3. Code suggestions from Copilot Chat appear in the diff view. You can review and refine what is being proposed and apply the change to your code using Tab, or discard it using Alt+Delete.
  4. You can promote your inline chat thread to the chat window by selecting View in chat window. This preserves the record and context of your conversation, and you can continue in the chat window.
  5. Select Esc to close the inline chat view.

Note

Queries from GitHub Copilot in SSMS are executed under the context of the user's login and permissions, whether from the chat window or inline chat view. There are no separate permissions for GitHub Copilot in SSMS.

Related content

  • Last updated on