Explore the process of creating a GitHub Copilot chat participant integrated with a SQL database in this 13-minute live coding demonstration. Follow along as Joyce from the VS Code team builds an extension from scratch, covering topics such as setting up dependencies, coding the chat participant, handling user requests, integrating language models, and refining the implementation. Learn how to pass database context to the LLM, add a run query button, integrate smart actions throughout the editor, and implement functionality for database summaries and context menus. Gain insights into live coding techniques, including regex implementation, as you watch the step-by-step development of this VS Code extension.
Overview
Syllabus
- Introduction
- Setting up the VS Code extension and dependencies
- Coding the chat participant
- Handling user requests and integrating language models
- Handling the LLM response
- Testing and refining the chat participant
- Passing database context to the LLM
- Notifying user of progress
- Adding run query button
- Integrating smart actions throughout the editor
- Adding functionality for database summaries and context menus
- Recap
Taught by
Visual Studio Code
