Introducing Microsoft's VS Code Extension for PostgreSQL | POSETTE: An Event for Postgres 2025

Video of a conference talk in which you will discover the new VS Code extension for PostgreSQL, designed to streamline database management and exploration within the world’s most popular IDE. This open-source tool minimizes context switching, enabling developers to seamlessly work in their existing VS Code environment and extensions—including GitHub Copilot—directly within the query editor. It supports any PostgreSQL instance, whether hosted locally, in any cloud, or on-premises, providing maximum flexibility. For Azure users, built-in Azure Entra ID authentication simplifies discovering and connecting to Azure-hosted PostgreSQL servers. If you're new to PostgreSQL, the extension also helps you quickly spin up a local instance, making it easier than ever to get started. Join this session to explore key features such as schema-aware autocomplete, data object browsing, query execution, connection management, and data exporting. Get a firsthand look at how it can elevate your PostgreSQL experience. Matt McFarland is a software engineer with over a decade of experience using PostgreSQL in application development. He was a lead engineer on the Microsoft Planetary Computer, a global open geospatial data platform powered by PostgreSQL, and collaborates on pgstac, a tool for managing standards-based geospatial metadata in PostgreSQL. He is currently leading development of Microsoft's PostgreSQL extension for VS Code. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 00:52 Why PostgreSQL in VS Code? ⏩ 02:02 Full Featured PostgreSQL Experience in VS Code ⏩ 02:40 DEMO #1: Connections ⏩ 07:46 DEMO #2: Queries ⏩ 12:32 DEMO #3: Advanced Workflows with GitHub Co-Pilot Agent Mode ⏩ 16:48 Feedback please! 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   LinkedIn - https://www.linkedin.com/company/posettec