DataGrip is the most powerful database management tool from JetBrains. It supports not only MySQL and PostgreSQL databases, but also ClickHouse, Microsoft SQL Server, MongoDB, Apache Cassandra and other databases. You can create databases and tables, view their contents in the program interface, execute raw SQL queries and more.
In this article we will explain how to install DataGrip in Ubuntu 22.04. Also, we will show how to add your database server, and communicate with it.
Table of Contents
Installing DataGrip in Ubuntu 22.04
1. JetBrains Toolbox
JetBrains provides its own tool for installing and continually updating for its products. You can install DataGrip using this tool. I assume that it is installed in your system. If it is not, go to this article and install it. After this open the application and find DataGrip in the list and press the Install button:
After this, wait until the download and installation process is finished.
When the program is installed, you can run it from JetBrains Toolbox or the system menu. Using JetBrains toolbox for installing software has a few advantages. You don’t need to enter your license or log in into your JetBrains account. All the required information will be synchronized from the Toolbox, and you can start a trial period or choose a license without additional manipulations.
2. Software Center
Alternatively, you can install DataGrip in Ubuntu 22.04 from Ubuntu Software. JetBrains developers made a snap package for this program, so you can install and update the application using system tools. Open the Ubuntu Software, click the search button and type DataGrip in the search line:
Choose DataGrip in the list:
Click the Install button on the application page. The installation process may take a few minutes. After this you will have DataGrip installed and will be able to run the application from the system menu or a command line.
If you don’t want to use GUI, you can install the application using the snap package manager from a command line. First, let’s find out the name of the package using the command below:
snap search datagrip
As you can see the package has the same name. Use this command to install it:
sudo snap install datagrip --classic
3. Binary Tarball
Using the two methods described above is better for installing DataGrip because they allow you to receive a new version of the application when it is released without reinstalling it. But if you want to get an older version of DataGrip or you want to take control of application binaries you can install it from tarball.
Open the DataGrip download page and find the version you need. If you want to download the latest version, click the Download button:
Also, you can click the Older Versions link and choose one of the previous versions. The archive will be saved to the ~/Downloads directory. You can extract its content using the Nautilus file manager or a command line. If you want to use the command line open the terminal and change the current directory to ~/Downloads:
cd ~/Downloads
Then, extract archive contents to the current directory using the command below:
tar -xvf DataGrip-2022.1.5.tar.gz
You can place the program directly in the ~/Downloads folder, but Linux systems have a special directory for manually installed programs. It is called /opt. It will be better if you move DataGrip to the /opt directory after extracting. Use the command shown below to do this:
mv ./DataGrip-2022.1.5 /opt/DataGrip-2022.1.5
Now, you can find DataGrip executable in the /opt/DataGrip-2022.1.5 folder. You can run the application using this command:
/opt/DataGrip-2022.1.5/bin/datagrip.sh
How to Use DataGrip
During the first launch, DataGrip will ask you for a license. If you haven’t used this application before, you can get a trial period. The trial evaluation will expire 30 days after the activation. Otherwise, you need to log in to your JetBrains account and buy a license.
Once you are done, the application will prompt you to create a new project. You can add all your database connections to this project. Click the New Project button and type the project name:
1. Create a Shortcut
If you installed the application from the binary tarball create a shortcut to launch it from the system main menu. Open the Tools menu and click Create Desktop Entry:
Then you can check a box if you want to create the shortcut for all users:
That’s it.
2. Add a Database Connection
Next, let’s see how to create a database connection in the DataGrip. You can do it in two ways. Click on the plus button in the Database Explorer area and choose Data Source. Then choose your database engine. For example PostgreSQL:
Another way is to open File -> New -> Data Source and choose your database engine:
Then set database server credentials. You should specify host, port, password, username, database. Also you can change name and comment. For some engines you should click the Download missing driver files button.
Once you are done, click Test connection link to make sure that settings are correct and everything works fine:
3. Create Database
If you want to create a new database, open the contextual menu on the database connection and select New. Then, select Database:
After this type the database name and press OK:
Now a database has been created. By default DataGrip does not display any schema or tables in the databases. Click on the button near the database name and choose the schema you want to see. You can add all schemas or only public ones:
After this they will appear in the list and you can create or manage database tables.
4. Create a folder
You can organize your database connections into folders. To move the connection into the folder, open the contextual menu on it and click Move to Folder:
Then, type the new folder’s name or choose one of existing folders and press Enter:
After this your database connection will be placed in the selected folder.
Wrapping Up
In this article we have explained how to install DataGrip in Ubuntu 22.04. It is a powerful database management tool. You can manage numerous database types in one place but it is not free. If you want to use a free tool you may consider the open-source application DBeaver. We will explain how to install and use it in our future posts.
