Introducing Microsoft's VS Code Extension for PostgreSQL
summary
New VS Code extension claims a full Postgres workflow inside the editor: manage connections, browse objects, run queries with schema-aware autocomplete, and export results to CSV/JSON/Excel; it supports tens of thousands of rows smoothly. It creates local containers with local Docker instance creation, connects to Azure Flexible Server via Azure Entra ID authentication without storing secrets, and integrates psql. In demos Copilot Agent Mode imports the Open Brewery DB CSV, adds PostGIS geometry, logs every SQL action, and scaffolds a FastAPI + Leaflet app end to end.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 0:52Why PostgreSQL in VS Code?
- 2:02Full Featured PostgreSQL Experience in VS Code
- 2:40DEMO #1: Connections
- 7:46DEMO #2: Queries
- 12:32DEMO #3: Advanced Workflows with GitHub Co-Pilot Agent Mode
- 16:48Feedback please!
related talks
20mPostgreSQL Tooling Across AI Editors and Agents
37mEnhancing VS Code extensions with GitHub Copilot
01h 03mVisual Studio Code and SQL Operations Studio
49mNew Client Tool for Developers and DBAs
32mWhat makes Azure Database for PostgreSQL Great for Developers?
13mSupercharge Your Performance With the New VSCode Plugin for Neo4j
20mCrossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
01h 00mUnleash the Power of VS Code