Building your own GitHub Copilot chat participant in VS Code

Learn how to create a GitHub Copilot chat participant that integrates with a SQL database in this live demo where Joyce from the VS Code team builds up an extension from scratch. And live codes some regex. 😱

00:00 - Introduction
00:33 - Setting up the VS Code extension and dependencies
01:15 - Coding the chat participant
02:25 - Handling user requests and integrating language models
03:50 - Handling the LLM response
05:02 - Testing and refining the chat participant
05:35 - Passing database context to the LLM
06:30 - Notifying user of progress
06:45 - Adding run query button
09:47 - Integrating smart actions throughout the editor
10:15 - Adding functionality for database summaries and context menus
12:38 - Recap

#LiveCoding #VSCODE #GitHubCopilot