Post Content
Follow how PostgreSQL tooling is evolving across AI editors and agents. Matt McFarland (Microsoft) walks through this in his talk “PostgreSQL Tooling Across AI Editors and Agents” at POSETTE: An Event for Postgres 2026. Abstract: Developers interact with PostgreSQL through a mix of editors, terminals, query consoles, plan viewers, and monitoring tools. As AI-native editors and agent-driven tools become part of everyday workflows, it’s increasingly valuable for PostgreSQL capabilities to be available wherever developers and agents operate, building on the strong foundation established in the VS Code PostgreSQL extension.
In this session, we’ll show how PostgreSQL connection management, query execution, schema analysis, plan inspection, and performance insights are being extended from the VS Code PostgreSQL extension to Cursor and the GitHub Copilot CLI using an MCP server as the shared interface. Rich editor environments like VS Code and Cursor support interactive query execution, visualized results, and AI-assisted plan inspection and tuning. The same MCP-backed foundation enables the GitHub Copilot CLI to establish connections, run queries, analyze schemas, inspect plans, and reason about performance without a visual UI.
We’ll also discuss how this architecture positions PostgreSQL tooling to continue expanding as new AI-driven environments emerge, allowing core database capabilities to surface naturally wherever AI developers work.
Matt McFarland is a software engineer at Microsoft 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 chapters:
⏩ 00:00 Music & introduction
⏩ 00:33 From VS Code to AI-driven developer workflows
⏩ 01:43 VS Code extension retrospective: a year of features
⏩ 03:38 Azure Database integration in the extension
⏩ 04:13 Demo: Azure server management from VS Code
⏩ 06:03 Bringing the extension to Cursor IDE
⏩ 06:59 DEMO: Cursor IDE: object properties and query plans
⏩ 12:56 MCP server: shipping tools across host platforms
⏩ 13:54 Demo: pgsql-tools and Copilot CLI
⏩ 19:08 Wrap-up: packaging, next steps, and TUIs
📕 Everything you need to know about POSETTE: An Event for Postgres 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/posetteconf/
X – @PosetteConf, https://x.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://aka.ms/posette-on-bluesky
#PosetteConf #PostgreSQL #VSCode Read More Microsoft Developer
