<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza" -->

---
title: PostgreSQL Tooling Across AI Editors and Agents |...
description: Microsoft's Postgres Developer Tools team presents an evolution of their VS Code extension for PostgreSQL management, now expanding to Cursor IDE and CLI-based...
canonical: https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: PostgreSQL Tooling Across AI Editors and Agents | POSETTE: An Event for Postgres 2026 | daily.dev
og:description: Microsoft's Postgres Developer Tools team presents an evolution of their VS Code extension for PostgreSQL management, now expanding to Cursor IDE and CLI-based...
og:url: https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza
og:image: https://api.daily.dev/og/posts/ILDJqcaZA.png
og:image:alt: PostgreSQL Tooling Across AI Editors and Agents | POSETTE: An Event for Postgres 2026
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL Tooling Across AI Editors and Agents | POSETTE: An Event for Postgres 2026

**[Microsoft Developer](https://daily.dev/sources/microsoftdeveloper)** · 20 min read · 1 upvotes · 0 comments

## Summary

Microsoft's Postgres Developer Tools team presents an evolution of their VS Code extension for PostgreSQL management, now expanding to Cursor IDE and CLI-based AI agent workflows. The extension (over 500K installs) includes an object explorer, query editor with IntelliSense, EXPLAIN ANALYZE visualizer, ERD diagrams, and performance dashboards. A new standalone MCP (Model Context Protocol) server decouples database tooling from VS Code-specific APIs, enabling the same Postgres tools to work across Cursor, GitHub Copilot CLI, and future AI terminals like Codex and Claude Code. A new CLI tool called pgsql-tools packages the MCP server with secure connection profile management (OS keyring storage). Demos show natural language database exploration, query plan analysis, schema diagramming, and agentic database refactoring tasks via Copilot CLI.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.youtube.com/watch?v=3IJsV5T6CPE>

## Questions this post answers

### What is pgsql-tools and how does it work with Postgres and AI agents?

pgsql-tools is a command-line utility from Microsoft that packages standalone Model Context Protocol (MCP) servers for Postgres, letting CLI-based AI agents like Copilot CLI query and manage a database through natural language. It manages connection profiles, stores credentials securely in the OS keyring rather than config files, and registers the MCP server with an agent harness such as Copilot CLI.

_Developers wiring AI agents into Postgres workflows can follow tooling shifts like this one on daily.dev._

### Does the Microsoft Postgres extension work in Cursor IDE?

Yes, the Postgres extension built for VS Code now has a fully supported version for Cursor IDE, since Cursor is a VS Code fork sharing the same extension model. It includes Azure and Entra ID integration points and works with Cursor's built-in agent chat via the same MCP server shipped with the VS Code extension. Cursor's newly launched v3 agent-focused app uses a different extension model that is not yet supported.

_Teams comparing Postgres tooling across VS Code and Cursor can track these integration updates on daily.dev._

### How do AI agents avoid recommending unnecessary database maintenance like VACUUM during query plan analysis?

The Postgres MCP tooling checks actual table statistics before making recommendations, so it won't suggest running a VACUUM on a table if that maintenance was already performed recently. This context comes from tools that let the agent query real table statistics and query plan node details rather than relying on generic advice.

_Engineers tuning Postgres query performance with AI assistance can follow these workflow details on daily.dev._

## Similar posts on daily.dev

- [PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code](https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx) · DevBlogs · 0 upvotes · 0 comments
- [Why pgEdge thinks MCP \(not an API\) is the right way for AI agents to talk to databases](https://daily.dev/posts/why-pgedge-thinks-mcp-not-an-api-is-the-right-way-for-ai-agents-to-talk-to-databases-scei0lm0l) · The New Stack · 1 upvotes · 0 comments
- [Connect database to AI with Devart MCP in ASP.NET Core](https://daily.dev/posts/connect-database-to-ai-with-devart-mcp-in-asp-net-core-egyfuodaw) · NikolaTech · 3 upvotes · 0 comments
- [DataGrip 2026.2: AI Agent Skills, MCP Tools and CLI Commands for Data Source Management, Bundled JDBC Drivers, and Improved Session Control](https://daily.dev/posts/datagrip-2026-2-ai-agent-skills-mcp-tools-and-cli-commands-for-data-source-management-bundled-jdb-tkkx8t4ip) · JetBrains · 4 upvotes · 0 comments

---

Tags: [#ai-agents](https://daily.dev/tags/ai-agents), [#postgresql](https://daily.dev/tags/postgresql), [#mcp](https://daily.dev/tags/mcp), [#vscode](https://daily.dev/tags/vscode)

[View this post on daily.dev](https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"PostgreSQL Tooling Across AI Editors and Agents | POSETTE: An Event for Postgres 2026","url":"https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza"},"datePublished":"2026-06-16T21:08:36.994Z","dateModified":"2026-09-14T09:05:09.324Z","description":"Microsoft's Postgres Developer Tools team presents an evolution of their VS Code extension for PostgreSQL management, now expanding to Cursor IDE and CLI-based...","image":"https://i.ytimg.com/vi/3IJsV5T6CPE/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/3IJsV5T6CPE/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Microsoft Developer","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Microsoft Developer","logo":"https://media.daily.dev/image/upload/s--xZzU3zUq--/f_auto/v1746714872/logos/microsoftdeveloper","url":"https://daily.dev/sources/microsoftdeveloper"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"ai-agents,postgresql,mcp,vscode","timeRequired":"PT20M","video":{"@type":"VideoObject","name":"PostgreSQL Tooling Across AI Editors and Agents | POSETTE: An Event for Postgres 2026","description":"Microsoft's Postgres Developer Tools team presents an evolution of their VS Code extension for PostgreSQL management, now expanding to Cursor IDE and CLI-based...","thumbnailUrl":"https://i.ytimg.com/vi/3IJsV5T6CPE/sddefault.jpg","uploadDate":"2026-06-16T21:08:36.994Z","duration":"PT20M","url":"https://api.daily.dev/r/ILDJqcaZA","embedUrl":"https://www.youtube.com/embed/3IJsV5T6CPE"}}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Microsoft Developer","item":"https://daily.dev/sources/microsoftdeveloper"},{"@type":"ListItem","position":3,"name":"PostgreSQL Tooling Across AI Editors and Agents | POSETTE: An Event for Postgres 2026"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/postgresql-tooling-across-ai-editors-and-agents-posette-an-event-for-postgres-2026-ildjqcaza#faq","mainEntity":[{"@type":"Question","name":"What is pgsql-tools and how does it work with Postgres and AI agents?","acceptedAnswer":{"@type":"Answer","text":"pgsql-tools is a command-line utility from Microsoft that packages standalone Model Context Protocol (MCP) servers for Postgres, letting CLI-based AI agents like Copilot CLI query and manage a database through natural language. It manages connection profiles, stores credentials securely in the OS keyring rather than config files, and registers the MCP server with an agent harness such as Copilot CLI. Developers wiring AI agents into Postgres workflows can follow tooling shifts like this one on daily.dev."}},{"@type":"Question","name":"Does the Microsoft Postgres extension work in Cursor IDE?","acceptedAnswer":{"@type":"Answer","text":"Yes, the Postgres extension built for VS Code now has a fully supported version for Cursor IDE, since Cursor is a VS Code fork sharing the same extension model. It includes Azure and Entra ID integration points and works with Cursor's built-in agent chat via the same MCP server shipped with the VS Code extension. Cursor's newly launched v3 agent-focused app uses a different extension model that is not yet supported. Teams comparing Postgres tooling across VS Code and Cursor can track these integration updates on daily.dev."}},{"@type":"Question","name":"How do AI agents avoid recommending unnecessary database maintenance like VACUUM during query plan analysis?","acceptedAnswer":{"@type":"Answer","text":"The Postgres MCP tooling checks actual table statistics before making recommendations, so it won't suggest running a VACUUM on a table if that maintenance was already performed recently. This context comes from tools that let the agent query real table statistics and query plan node details rather than relying on generic advice. Engineers tuning Postgres query performance with AI assistance can follow these workflow details on daily.dev."}}]}
```

