Explore an Unfamiliar PostgreSQL Database with VS Code and Copilot

Description: Need to understand a PostgreSQL database you didn’t build? See how the PostgreSQL extension for Visual Studio Code and GitHub Copilot can help you explore an unfamiliar database and get oriented faster. In this episode, you’ll use Object Explorer to investigate schemas, tables, views, and functions; visualize relationships between database objects; ask context-aware questions with Copilot Chat; and verify what you learn with the database itself. See how to move from database discovery to a clearer understanding of your data model without leaving VS Code.

🚀 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 to database challenges
00:27 Inheriting an unfamiliar database with Kayla
00:45 Using Object Explorer for database discovery
01:03 Visualizing schema relationships
01:14 Using Copilot Chat for context-aware database queries
01:36 Validating database insights with Azure compute
01:58 Verifying data paths with read-only queries
02:12 Conclusion: Navigating databases with confidence

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