Write and Optimize PostgreSQL Queries Faster in VS Code with Copilot

Write, understand, and optimize PostgreSQL queries in Visual Studio Code with context-aware developer tools and AI assistance. In this episode, see how the PostgreSQL extension for VS Code supports SQL authoring with IntelliSense and database context, then use GitHub Copilot to help draft SQL and explain, analyze, and improve queries. Finally, run your query, inspect the results, and export your data, all while staying in VS Code. It’s a practical workflow for moving from an application requirement to reviewed SQL faster, while keeping the developer in control. 🚀 Build with the PostgreSQL extension for VS Code: https://aka.ms/pg-pro-vs-code-repo ▶ Check out the full series: VS Code Edition: https://aka.ms/postgresql-like-a-pro-vscode 📖 Chapters: 00:00 - Introduction 00:21 - About the series and the demonstration 00:47 - Exploring the database schema 00:53 - Writing an initial SQL query 02:49 - Refining the query with GitHub Copilot 03:56 - Analyzing query performance 04:45 - Applying query improvements 05:26 - Closing thoughts and takeaways PostgreSQL Like a Pro: VS Code Edition is brought to you by Microsoft in collaboration with AMD, supporting the infrastructure that powers modern PostgreSQL workloads on Azure. 📲 Follow VS Code: Instagram: https://www.instagram.com/vscode/ X: https://x.com/code Bluesky: https://bsky.app/profile/vscode.dev LinkedIn: https://aka.ms/VSCode/LinkedIn GitHub: https://github.com/microsoft/vscode #postgresql #vscode