Explore an Unfamiliar PostgreSQL Database with VS Code and Copilot

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