Explore an Unfamiliar PostgreSQL Database with VS Code and Copilot
The Visual Studio Code team presents a database-discovery workflow for developers working with PostgreSQL databases they did not build, combining direct inspection with Copilot-assisted questions.
Exploring the data model
The episode uses the PostgreSQL extension for Visual Studio Code and GitHub Copilot to move from initial database discovery to a clearer understanding of the data model without leaving the editor.
The workflow covers:
- Inspecting database objects: Use Object Explorer to investigate schemas, tables, views, and functions.
- Understanding relationships: Visualize relationships between database objects to see how the model fits together.
- Asking context-aware questions: Use Copilot Chat to help interpret the database being explored.
- Verifying findings: Check what you learn against the database itself rather than treating Copilot’s answers as authoritative.
Resources
The series is produced by Microsoft in collaboration with AMD, supporting the infrastructure that powers PostgreSQL workloads on Azure.