# PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code

DevFeed: [PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code](<https://devfeed.tech/articles/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-100852.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/blog/postgresql-like-a-pro-vscode/>)

Author: Cynthia Zanoni, Pooja Yarabothu

Published: 2026-10-26T15:05:12Z

Content type: tutorial

Language: en

Sources: [Developer Blogs](<https://devfeed.tech/sources/developer-blogs.md>)

Topics: [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>)

Tags: [azure](<https://devfeed.tech/tags/azure.md>), [build](<https://devfeed.tech/tags/build.md>), [copilot](<https://devfeed.tech/tags/copilot.md>), [database](<https://devfeed.tech/tags/database.md>), [entra-id](<https://devfeed.tech/tags/entra-id.md>), [extension](<https://devfeed.tech/tags/extension.md>), [extensions](<https://devfeed.tech/tags/extensions.md>), [github-copilot](<https://devfeed.tech/tags/github-copilot.md>), [microsoft-for-developers](<https://devfeed.tech/tags/microsoft-for-developers.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [troubleshoot](<https://devfeed.tech/tags/troubleshoot.md>), [visual-studio-code](<https://devfeed.tech/tags/visual-studio-code.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>)

## AI overview

The PostgreSQL extension for VS Code brings database browsing, SQL editing, and Copilot-assisted work into the editor. Connect to on-premises or cloud databases, save reusable profiles, and browse schemas and objects; Azure connections can use Microsoft Entra ID. IntelliSense assists with SQL syntax and database names, while Copilot can help refine queries or interpret plans. The article advises reviewing generated SQL, execution plans, and results before adopting changes. For unfamiliar databases, use Object Explorer and schema visualization, then verify Copilot's database-context answers with the object tree and a read-only query. For performance issues, Database Agent in the Azure PostgreSQL experience is presented as an upcoming feature that assembles evidence and recommendations; actions are manual, availability and Azure requirements may apply, and automated remediation is described as future capability.

## Source excerpt

Build, query, and troubleshoot without leaving VS Code. The post PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code appeared first on Microsoft for Developers.