Write and Optimize PostgreSQL Queries Faster in VS Code with Copilot

Description: 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 Close description