{"id":1553,"date":"2019-03-18T00:00:00","date_gmt":"2019-03-18T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres"},"modified":"2025-06-18T13:49:14","modified_gmt":"2025-06-18T20:49:14","slug":"azure-data-studio-an-open-source-gui-editor-for-postgres","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/","title":{"rendered":"Azure Data Studio: An Open Source GUI Editor for Postgres"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor. Even if you typically use command line, you may want to go visual sometimes. At Microsoft we&#8217;ve spent many years building experiences to <a href=\"https:\/\/code.visualstudio.com\/\">enhance developers&#8217; day-to-day productivity<\/a>. Having choices is important. It allows you to go with the tool that works for you.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Today we&#8217;re excited to announce <strong>preview support for PostgreSQL in Azure Data Studio<\/strong>. <a href=\"https:\/\/aka.ms\/azuredatastudio\" target=\"_blank\" rel=\"noopener\">Azure Data Studio<\/a> is a cross-platform modern editor focused on data development. It&#8217;s available for Linux, MacOS, and Windows. Plus, Azure Data Studio comes with an integrated terminal so you&#8217;re never far away from psql.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We&#8217;re also introducing a corresponding <strong>preview<\/strong> <strong>PostgreSQL extension in Visual Studio Code (VS Code)<\/strong>. Both Azure Data Studio and VS Code are open source and extensible &#8211; two things that PostgreSQL itself is based on.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Azure Data Studio inherits a lot of VS Code functionality. It also supports most of VS Code&#8217;s extensions like Python, R, and Kubernetes support. If your primary use case is data, choose Azure Data Studio. You can manage multiple database connections, explore database object hierarchy, set up dashboards, and more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the other hand, if you&#8217;re closer to application development than you are to database administration, then go for our PostgreSQL extension in VS Code. Actually, you don&#8217;t have to choose &#8211; use both, switching according to what works best for you at the time.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"connect-to-postgres\">Connect to Postgres<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Curious about what\u2019s included? Let\u2019s take a deeper look at the development experience for PostgreSQL in Azure Data Studio. You can connect to your Postgres server or establish a connection directly to a database. The Postgres server can be hosted on-premises, in a virtual machine (VM), or from the managed service of any cloud provider.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp\" alt=\"Connect to Postgres in Azure \" style=\"border-radius:0px\" title=\"Connect to Postgres in Azure \" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"organize-your-servers\">Organize your servers<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Often you have multiple Postgres servers you\u2019re working with. Perhaps there\u2019s one production server, a corresponding stage server, and maybe multiple dev\/test servers. Knowing which is which is key, especially being able to clearly identify your production server. In Azure Data Studio you can use server groups to categorize your servers. You can highlight your production server group in red to make it visually distinct from the others.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/08d8d76f-f921-48b8-a6e1-4f9dcf7bcc1c.webp\" alt=\"Organize your servers in Azure \" style=\"border-radius:0px\" title=\"Organize your servers in Azure\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"track-down-database-objects\">Track down database objects<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Your Postgres server evolves as you add new functionality. It\u2019s helpful to be able to clearly see what columns, indexes, triggers, and functions have been created for each database and table. This is especially true when you\u2019re not the only person working on that Postgres instance. Azure Data Studio provides convenient hierarchical navigation in the sidebar. With it you can easily explore and keep track of your server&#8217;s databases, tables, views, and other objects.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/64f5eb2f-824c-44f8-ac28-6e9ec020b9b5.webp\" alt=\"Track down database objects in Azure \" style=\"border-radius:0px\" title=\"Track down database objects in Azure \" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"write-queries-efficiently\">Write queries efficiently<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As you look through the new database objects your teammates have created, it\u2019s helpful to go beyond the name of the object to the DDL that composes it. Even if you\u2019re the only person working on your Postgres instance, there may be objects you created a while back that you want to look up. Checking the DDL is a useful double-check to confirm that an object is doing what you expect.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Azure Data Studio provides \u201cPeek Definition\u201d and \u201cGo to Definition\u201d functionality so you can do that, and even do it as you use the object in a query. For example, let\u2019s say you want to query pg_stat_activity, one of the built-in statistics views that comes with Postgres. You can use \u201cGo to Definition\u201d to see all its columns and understand what this view is based on.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/b25ea555-ebd2-4609-b96a-7f95fc8fc296.webp\" alt=\"Write queries efficiently in Azure Data Studio\" style=\"border-radius:0px\" title=\"Write queries efficiently\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Writing SQL queries is bread and butter when working with Postgres, whether you\u2019re an expert or are just getting started with this RDBMS. Whoever you are, IntelliSense for SQL is integrated into Azure Data Studio to help you write your queries quicker. With IntelliSense\u2019s context-aware code completion suggestions, you can use fewer keystrokes to get the job done.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you use Postgres a lot, you probably have a few SQL queries you end up reusing over and over. Whether they are detailed CREATE statements or complex SELECTs, you can templatize each one into a SQL code snippet. That way you don\u2019t have to retype it afresh each time. Azure Data Studio inherits its <a href=\"https:\/\/code.visualstudio.com\/docs\/editor\/userdefinedsnippets\" target=\"_blank\" rel=\"noopener\">code snippet functionality from Visual Studio Code<\/a>. Code snippets help you avoid errors from retyping code, and overall let you develop faster.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"customize-your-editor\">Customize your editor<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">One advantage of modern development GUIs is the ability to customize them to suit your unique preferences. For example, in this blog we\u2019ve used the <em>Solarized Dark<\/em> theme in screenshots. Honestly, that isn\u2019t everyone\u2019s cup of tea. Well there are ten more color themes you can choose from in Azure Data Studio, not to mention a high contrast option.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The personalization options extend to key bindings as well. Don&#8217;t like using the default Ctrl+N to open a new tab? You can change it. Or maybe you want a keyboard shortcut that doesn&#8217;t come out of the box with Azure Data Studio. You can create and customize key bindings using the Keyboard Shortcuts editor.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/f01bd652-7cb2-44ba-85ce-45179cac32db.webp\" alt=\"Customize your editor in Azure Data Studio\" style=\"border-radius:0px\" title=\"Customize your editor\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-get-started\">How to get started<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">There are even more features to discover, like Git source control integration and customized dashboards and widgets. You can start using the preview for PostgreSQL in Azure Data Studio today &#8211; check out the <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/postgres-extension\" target=\"_blank\" rel=\"noopener\">install instructions<\/a>. To start using our preview PostgreSQL extension for Visual Studio Code, learn more on our <a href=\"https:\/\/github.com\/Microsoft\/vscode-postgresql\" target=\"_blank\" rel=\"noopener\">GitHub page<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These two features are in preview and your feedback is critical to making them better and making them work for you. Share your feedback on our PostgreSQL GitHub pages for <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio-postgresql\" target=\"_blank\" rel=\"noopener\">Azure Data Studio<\/a> or <a href=\"https:\/\/github.com\/Microsoft\/vscode-postgresql\" target=\"_blank\" rel=\"noopener\">Visual Studio Code<\/a> respectively.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[],"audience":[3057,3055,3056],"content-type":[1465],"product":[1565],"tech-community":[],"topic":[],"coauthors":[600],"class_list":["post-1553","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-implementors","content-type-announcements","product-azure-database-for-postgresql","review-flag-1680286581-295","review-flag-1680286581-364","review-flag-never-1680286580-606","review-flag-new-1680286579-546","review-flag-vm-1680286585-143"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure Data Studio: An Open Source GUI Editor for Postgres | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Data Studio: An Open Source GUI Editor for Postgres | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-18T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-18T20:49:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp\" \/>\n<meta name=\"author\" content=\"Rachel Agyemang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rachel Agyemang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/rachel-agyemang\/\",\"@type\":\"Person\",\"@name\":\"Rachel Agyemang\"}],\"headline\":\"Azure Data Studio: An Open Source GUI Editor for Postgres\",\"datePublished\":\"2019-03-18T00:00:00+00:00\",\"dateModified\":\"2025-06-18T20:49:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\"},\"wordCount\":1002,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\",\"name\":\"Azure Data Studio: An Open Source GUI Editor for Postgres | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp\",\"datePublished\":\"2019-03-18T00:00:00+00:00\",\"dateModified\":\"2025-06-18T20:49:14+00:00\",\"description\":\"When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Azure Data Studio: An Open Source GUI Editor for Postgres\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Data Studio: An Open Source GUI Editor for Postgres | Microsoft Azure Blog","description":"When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/","og_locale":"en_US","og_type":"article","og_title":"Azure Data Studio: An Open Source GUI Editor for Postgres | Microsoft Azure Blog","og_description":"When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-03-18T00:00:00+00:00","article_modified_time":"2025-06-18T20:49:14+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp","type":"","width":"","height":""}],"author":"Rachel Agyemang","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Rachel Agyemang","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/rachel-agyemang\/","@type":"Person","@name":"Rachel Agyemang"}],"headline":"Azure Data Studio: An Open Source GUI Editor for Postgres","datePublished":"2019-03-18T00:00:00+00:00","dateModified":"2025-06-18T20:49:14+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/"},"wordCount":1002,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/","name":"Azure Data Studio: An Open Source GUI Editor for Postgres | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp","datePublished":"2019-03-18T00:00:00+00:00","dateModified":"2025-06-18T20:49:14+00:00","description":"When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it\u2019s pretty powerful, but some people much prefer a graphical editor.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/1d90cdd2-552d-4399-9749-a300325674c8.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-studio-an-open-source-gui-editor-for-postgres\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Azure Data Studio: An Open Source GUI Editor for Postgres"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=1553"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1553\/revisions"}],"predecessor-version":[{"id":42412,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1553\/revisions\/42412"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=1553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=1553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=1553"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=1553"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=1553"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=1553"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=1553"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=1553"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=1553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}