PostgreSQL Tooling Across AI Editors and Agents
summary
PostgreSQL tools move from a VS Code extension with half a million installs into Cursor and the GitHub Copilot CLI by shipping a standalone MCP server and a packaged client called pgsql-tools. Features include Entra-authenticated connection management, query execution with EXPLAIN ANALYZE and a visual plan inspector, ERD schema diagrams, Azure server management and live performance dashboards. The Copilot CLI runs queries, creates views, runs plans and even generates multi-step refactor plans, and the cross-host setup works end-to-end.
AI-written summary · about
chapters (10)
- 0:00Music & introduction
- 0:33From VS Code to AI-driven developer workflows
- 1:43VS Code extension retrospective: a year of features
- 3:38Azure Database integration in the extension
- 4:13Demo: Azure server management from VS Code
- 6:03Bringing the extension to Cursor IDE
- 6:59DEMO: Cursor IDE: object properties and query plans
- 12:56MCP server: shipping tools across host platforms
- 13:54Demo: pgsql-tools and Copilot CLI
- 19:08Wrap-up: packaging, next steps, and TUIs
related talks
18mIntroducing Microsoft's VS Code Extension for PostgreSQL
21mWhat Microsoft is Building for Postgres in 2025
47mGitHub Copilot for SQL Development: Integrating the Power of AI into Database Development
32mWhat makes Azure Database for PostgreSQL Great for Developers?
52mManaging PostgreSQL changes for the Agile DBA
24mPostgres-powered AI: Running an End-to-End AI Platform with Postgres on Azure
09mHarness Microsoft Copilot in Azure for Azure SQL Database
49mWhen it all GOes right