Episode

PostgreSQL extension for VS Code

with Pamela Fox

PyCon 2025

In this theater session from PyCon US 2025, Cloud Advocate Pamela Fox walks through the new PostgresSQL extension for Visual Studio Code. The PostgreSQL extension for Visual Studio Code is a feature-rich tool designed to simplify PostgreSQL database management and development. This extension empowers developers to connect to PostgreSQL databases, write and execute queries, and manage database objects without leaving the Visual Studio Code environment.

Chapters

  • 00:00 - Intro: New PostgreSQL Extension for VS Code
  • 00:12 - Extension Overview and Feedback Invitation
  • 01:07 - Connecting to Local and Azure PostgreSQL
  • 01:24 - Schema Navigation and Table Browsing
  • 02:09 - Visualizing Database Schema Relationships
  • 02:41 - Writing and Running SQL Queries
  • 03:05 - Exporting Query Results to CSV, JSON, Excel
  • 03:26 - Viewing Query History and Debugging
  • 03:48 - GitHub Copilot Integration for SQL Queries
  • 04:46 - Copilot-Generated Queries and Observations
  • 05:39 - Using Agent Mode with PostgreSQL
  • 06:33 - Creating a New Database with Agent Mode
  • 07:47 - Loading CSV Data into PostgreSQL
  • 09:00 - Verifying Data and Schema with Copilot
  • 10:39 - Querying Geographic Data with PostGIS
  • 12:41 - Reviewing Copilot-Generated SQL Queries
  • 13:25 - Creating a Local Docker PostgreSQL Server
  • 15:21 - Managing Docker Containers via Extension
  • 15:42 - Connecting to External or Azure Servers
  • 16:24 - Querying Azure PostgreSQL Server Details
  • 18:01 - Exploring Allowed PostgreSQL Extensions
  • 19:00 - PGVector and DiskANN for Vector Search
  • 20:28 - Installing PGVector Extension via Copilot
  • 21:04 - Summary: Features and Migration Guidance
  • 21:56 - Feedback and Issue Tracker Invitation

Connect

Developer
Visual Studio
Visual Studio Code

Have feedback? Submit an issue here.