--- title: PostgreSQL Like A Pro: Build, query, and troubleshoot... description: Microsoft's PostgreSQL extension for VS Code lets developers browse database objects, write and run SQL, and use database context with GitHub Copilot without... canonical: https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code | daily.dev og:description: Microsoft's PostgreSQL extension for VS Code lets developers browse database objects, write and run SQL, and use database context with GitHub Copilot without... og:url: https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx og:image: https://api.daily.dev/og/posts/iOlbAeONx.png og:image:alt: PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code 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 Like A Pro: Build, query, and troubleshoot without leaving VS Code **[DevBlogs](https://daily.dev/sources/devblogs)** · 5 min read · 0 upvotes · 0 comments ## Summary Microsoft's PostgreSQL extension for VS Code lets developers browse database objects, write and run SQL, and use database context with GitHub Copilot without leaving the editor. The post walks through four workflows: connecting and exploring tables, writing and reviewing SQL with Copilot's help on query plans, understanding an unfamiliar database via Object Explorer and schema visualization, and investigating performance issues. A composite-index recommendation example shows how Database Agent surfaces supporting metrics and rollback guidance in the Azure PostgreSQL experience. Database Agent is introduced as an upcoming experience with actions applied manually; automated remediation is a future capability. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How can I browse and query a PostgreSQL database without leaving VS Code? Microsoft's PostgreSQL extension for VS Code adds a connection manager in the Activity Bar that supports on-premises and cloud databases, including an Azure path with Microsoft Entra ID sign-in. Once connected, you can expand servers and schemas to browse tables, views, functions and sequences, and use the built-in query editor with IntelliSense and GitHub Copilot to write and analyze SQL. _Developers evaluating in-editor database tooling can track VS Code and PostgreSQL extension updates on daily.dev._ ### What is Database Agent in the Azure PostgreSQL VS Code experience? Database Agent is an upcoming feature in the Azure PostgreSQL experience inside VS Code that gathers evidence like what changed, when, and which workload is affected, then surfaces recommendations such as a composite index along with supporting metrics and rollback guidance. Actions are applied manually for now, with automated remediation discussed as a future capability. _Anyone planning database performance workflows can keep tabs on Database Agent's rollout via daily.dev._ ## Similar posts on daily.dev - [PostgreSQL on Azure supercharged for AI](https://daily.dev/posts/postgresql-on-azure-supercharged-for-ai-jtprqmakm) · Microsoft Azure · 4 upvotes · 0 comments --- Tags: [#github](https://daily.dev/tags/github), [#azure](https://daily.dev/tags/azure), [#postgresql](https://daily.dev/tags/postgresql), [#vscode](https://daily.dev/tags/vscode) [View this post on daily.dev](https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx) ```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 Like A Pro: Build, query, and troubleshoot without leaving VS Code","url":"https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx"},"datePublished":"2026-10-26T16:05:37.109Z","dateModified":"2026-10-26T16:06:06.207Z","description":"Microsoft's PostgreSQL extension for VS Code lets developers browse database objects, write and run SQL, and use database context with GitHub Copilot without...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/f536636cd36b2f5a9910984a85b0cf54?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/f536636cd36b2f5a9910984a85b0cf54?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"DevBlogs","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":"DevBlogs","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8f68b453325f482ebeb73fb780092713","url":"https://daily.dev/sources/devblogs"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"github,azure,postgresql,vscode","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"DevBlogs","item":"https://daily.dev/sources/devblogs"},{"@type":"ListItem","position":3,"name":"PostgreSQL Like A Pro: Build, query, and troubleshoot without leaving VS Code"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/postgresql-like-a-pro-build-query-and-troubleshoot-without-leaving-vs-code-iolbaeonx#faq","mainEntity":[{"@type":"Question","name":"How can I browse and query a PostgreSQL database without leaving VS Code?","acceptedAnswer":{"@type":"Answer","text":"Microsoft's PostgreSQL extension for VS Code adds a connection manager in the Activity Bar that supports on-premises and cloud databases, including an Azure path with Microsoft Entra ID sign-in. Once connected, you can expand servers and schemas to browse tables, views, functions and sequences, and use the built-in query editor with IntelliSense and GitHub Copilot to write and analyze SQL. Developers evaluating in-editor database tooling can track VS Code and PostgreSQL extension updates on daily.dev."}},{"@type":"Question","name":"What is Database Agent in the Azure PostgreSQL VS Code experience?","acceptedAnswer":{"@type":"Answer","text":"Database Agent is an upcoming feature in the Azure PostgreSQL experience inside VS Code that gathers evidence like what changed, when, and which workload is affected, then surfaces recommendations such as a composite index along with supporting metrics and rollback guidance. Actions are applied manually for now, with automated remediation discussed as a future capability. Anyone planning database performance workflows can keep tabs on Database Agent's rollout via daily.dev."}}]} ```