How to install Azure Data Studio on Ubuntu 24.04 LTS Linux

Azure Data Studio, developed by Microsoft is an open source database management and development tool. It is a cross-platform database management tool that runs on all popular operating systems – Windows, macOS, and Linux. The software offers a modern editor and rich interface for managing various database systems such as Microsoft SQL Server, PostgreSQL, and more. It also offers robust language support for SQL, PowerShell, Python, KQL, Apache Spark TM, and PySpark to manage and query database servers.

To start with the tutorial, we need Ubuntu 24.04, nevertheless, users with Ubuntu 22.04, 20.04, or 18.04 can also follow the given steps to install Azure Data Studio.

Step 1. Access Command Terminal

On your Ubuntu 24.04 Linux, open the command terminal. It is quite easy to access the terminal using the keyboard shortcut – Ctrl+Alt+T. Alternatively can search for it in the Application menu.

Once you are on Terminal, run the system update command and also ensure you have the “wget” tool available.

sudo apt update && sudo apt upgrade && sudo apt install wget -y

Step 2. Download Azure Data Studio

Although Azure Data Studio is an open source, it is not available to install using the default Ubuntu system repository because of its proprietary nature. Hence, we have to download the Azure Data Studio Debian package manually using the given command on our Ubuntu 24.04.

wget "" -O azurestudio.deb

Step 3. Installing Azure Data Studio on Ubuntu 24.04

Once we have the Azure Data Studio Debian package on our Ubuntu system, use the DPKKG command line tool to install it. Here is the command to use:

sudo dpkg -i azurestudio.deb

Note: After running the above command, in case, you are getting any dependecies issues then fix that by running:

sudo apt --fix-broken install

Once the dependecies are fixed again the run the DPKG command i.e “sudo dpkg -i azurestudio.deb“.

Step 4. Verify the Installation

To confirm the installation has been done sucessfully, we can run the following command to fetch the version details of Azure Data Studio.

azuredatastudio --version

Step 5. Run Azure Data Studio

We can lunch this Database mangment application directly from our Ubuntu’s Application menu by searching for it or using the command terminal.

Run Azure Data Studio

From terminal:


Step 6: Connect to a Database

To connect to a database click on the New -> select “New Connection“. Enter the connection details such as server name, authentication type, and credentials. Once done, click on the Connect button to establish a connection to the database.

Installing Azure Data Studio on Ubuntu 24.04

Step 7: Install Extensions (Optional)

Furthermore, to extend the functions of Azure Data Studio, we can install various extensions available for it. For that, click on the “extensions” option given on the left side bar or use keyboard shortcut “Ctrl+Shift+X“. Now, search for the extensions you required to work with SQL Server, PostgreSQL and other databases.

Installing Azure Data Studio Extensions


So, we have the sucessfully installed and configured Azure Data Studio on your Ubuntu 24.04 system. But this is not enough, to learn further and know how to manage and interact with databases using it check out its offcial documentation.

Other Articels:

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.