Can you install extensions for Azure Data Studio when you are offline ?

Greg Booth 1,296 Reputation points
2021-09-03T11:00:49.22+00:00

We want to install Azure Data Studio (ADS) onto a server - and add the postgres extension.
(The postgres database is local, not in Azure).
The server has no internet access.
We can download an installer for ADS and install it with no internet access, but to add the postgres extension when running ADS the user has to do it - and it needs an internet access.
Is there any way to download the postgres extension manually - and then add it to ADS manually (not using the normal route ) ?

Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Michael Taylor 50,426 Reputation points
    2021-09-03T15:51:14.503+00:00

    Yes you can install without INet. Under the hood an ADS extension is just a VSIX file which is the same thing that VS Code and Visual Studio use for their installers. You can copy this file to any machine you want. In ADS go to the Extensions view and click the additional options (...). At the bottom is an option to install from a file. Alternatively, at least in VS, you can double click the VSIX file directly and run the installer that way.

    The hard part is getting the VSIX. I think it is just downloaded temporarily so capturing it might be hard. Never really tried myself. But a VSIX is a zip file and it gets extracted to your AppData...AzureDataStudio folder so you can go there to get the contents of the zip. In theory if you zip this back up it should be good but I've not tried that. As long as the manifest file is there then it should install fine.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Oury Ba-MSFT 17,236 Reputation points Microsoft Employee
    2021-09-03T15:58:17.753+00:00

    @Greg Booth Thank you for posting your question.
    Yeas you can install Azure data studio and add the Postgresql extension. The documents below explain this in more details.
    https://learn.microsoft.com/en-us/sql/azure-data-studio/extensions/postgres-extension?view=sql-server-ver15.
    https://learn.microsoft.com/en-us/sql/azure-data-studio/quickstart-postgres?view=sql-server-ver15

    Let us know if you have additional queries

    Regards,
    Oury