Azure Data Studio PostgreSQL Extension – Free data management tool to manage your PostgreSQL databases

Azure Data Studio (formerly SQL Operations Studio) is free Cross-Platform DB management tool for for Windows, macOS and Linux. Azure Data Studio was initially only released for managing SQL Server, however with the today’s Microsoft’s announcement , it will now be possible to connect and manage PostgreSQL databases with Azure Data Studio PostgreSQL Extension (Sweet deal!)

In this (and probably next few blog posts) I’ll be exploring this shiny new Azure Data Studio PostgreSQL Extension and will share my experience. So lets get started with Install and Configuration.

This post is written assuming you already have Azure Data Studio Installed on your machine (PC or Mac).  If you haven’t installed it already, the steps are simple and available here

How to Add Azure Data Studio PostgreSQL Extension

1. Select the extensions icon from the sidebar in Azure Data Studio
2. Type ‘PostgreSQL‘ into the search bar. Select the PostgreSQL extension
   
3. Click “Reload Now“
4. Extension Install Notification

   Downloading https://pgtoolservice.file.core.windows.net/download/pgsqltoolsservice-win-x64.zip?sv=2018-03-28&ss=bfqt&srt=sco&sp=rwdlacup&se=2019-06-28T01:59:13Z&st=2019-02-15T18:59:13Z&spr=https&sig=LPGNO%2BGA%2FjWCavlMuLFKevGK%2FkbulFXARRbXwORgkp4%3D
   
   (21434 KB)....................Done!
   
   Installing pgSQLToolsService service to C:\XXXX\.azuredatastudio\extensions\microsoft.azuredatastudio-pgsql-0.1.0\out\pgsqltoolsservice\Windows\1.2.0-alpha.22
   
   Installed

   Note: If you are do not see above notification, consider restarting Azure Data Studio Window

5. Click “New Connection” icon in the SERVERS page
6. Here, you’ll now be able to select “PostgreSQL” in Connection type list
7. Specify the all connection details as below and click

   - Server Name: PostgreSQL host name
   - User name: User name for the PostgreSQL
   - Password: Password for the PostgreSQL user
   - Database Name: Database name in PostgreSQL
   - Server Group: <Optional - if you want to create a server group>
   - Name: <Optional - name this connection>

In the next few posts, I’ll to share my experience using Azure Data Studio PostgreSQL Extension.