{"id":12085,"date":"2022-04-06T18:42:17","date_gmt":"2022-04-06T15:42:17","guid":{"rendered":"https:\/\/kifarunix.com\/?p=12085"},"modified":"2024-03-09T12:17:26","modified_gmt":"2024-03-09T09:17:26","slug":"install-dbeaver-on-ubuntu-22-04-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-dbeaver-on-ubuntu-22-04-ubuntu-20-04\/","title":{"rendered":"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04"},"content":{"rendered":"\n<p>Follow through this tutorial to learn how to install DBeaver on Ubuntu 22.04\/Ubuntu 20.04. <a href=\"https:\/\/dbeaver.io\/about\/\" target=\"_blank\" rel=\"noreferrer noopener\">DBeaver<\/a> is free and open source universal database tool for developers and database administrators.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Usability is the main goal of this project, program UI is carefully designed and implemented.<\/li>\n\n\n\n<li>It is free and open-source (ASL).<\/li>\n\n\n\n<li>It is multiplatform.<\/li>\n\n\n\n<li>It is based on opensource framework and allows writing of various extensions (plugins).<\/li>\n\n\n\n<li>It supports any database having a JDBC driver.<\/li>\n\n\n\n<li>It may handle any external datasource which may or may not have a JDBC driver.<\/li>\n\n\n\n<li>There is a set of plugins for different databases and different database management utilities (e.g. ERD, data transfer, compare, data export\/import, mock data generation, etc).<\/li>\n\n\n\n<li>It has a great number of&nbsp;features.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04<\/h2>\n\n\n\n<p>DBeaver is available as community edition and an enterprise edition. Based on your requirements, feel free choose your preferred edition.<\/p>\n\n\n\n<p>This guide however focuses on the installation of the Dbeaver CE version.<\/p>\n\n\n\n<p>There are two ways in which you can install DBeaver on Ubuntu;;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"#use-linux-installer\">Install DBeaver on Ubuntu using the DEB Binary Package<\/a><\/li>\n\n\n\n<li><a href=\"#install-from-snaps\">Install DBeaver on Ubuntu from Snap Store<\/a><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"use-linux-installer\">Install DBeaver on Ubuntu the Linux Ubuntu Binary Package<\/h3>\n\n\n\n<p>Navigate to <a href=\"https:\/\/dbeaver.io\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">DBeaver download&#8217;s<\/a> page and grab the DBeaver Linux Ubuntu binary package;<\/p>\n\n\n\n<p>You can also copy the link to the installer and download using curl or wget commands;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wget https:\/\/dbeaver.io\/files\/dbeaver-ce_latest_amd64.deb<\/code><\/pre>\n\n\n\n<p>Once the download is complete, execute the commands below to install DBeaver on Ubuntu;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt install .\/dbeaver-ce_latest_amd64.deb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"install-from-snaps\">Install DBeaver on Ubuntu from Snap Store<\/h3>\n\n\n\n<p>You can also be able to install DBeaver from Snap store. Snaps is installed by default on Ubuntu.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo snap install dbeaver-ce<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Running DBeaver on Ubuntu 22.04\/Ubuntu 20.04<\/h3>\n\n\n\n<p>You can now launch DBeaver from your system activities;<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/luanch-dbeaver.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1792\" height=\"665\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/luanch-dbeaver.png\" alt=\"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-12077\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/luanch-dbeaver.png?v=1649138556 1792w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/luanch-dbeaver-768x285.png?v=1649138556 768w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/luanch-dbeaver-1536x570.png?v=1649138556 1536w\" sizes=\"(max-width: 1792px) 100vw, 1792px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>Dbeaver UI;<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-ui.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1454\" height=\"759\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-ui.png\" alt=\"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-12078\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-ui.png?v=1649138580 1454w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-ui-768x401.png?v=1649138580 768w\" sizes=\"(max-width: 1454px) 100vw, 1454px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>You can choose to load the sample database, by clicking <strong>Yes<\/strong>.<\/p>\n\n\n\n<p>Sample SQLite database is loaded. When you click on it, you will be prompted to download the driver.<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-sample-database.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1454\" height=\"758\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-sample-database.png\" alt=\"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-12079\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-sample-database.png?v=1649138609 1454w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-sample-database-768x400.png?v=1649138609 768w\" sizes=\"(max-width: 1454px) 100vw, 1454px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>The driver will then be downloaded and installed. After which you can now see the database profile setup.<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-database-access.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1452\" height=\"755\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-database-access.png\" alt=\"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-12080\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-database-access.png?v=1649138648 1452w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-database-access-768x399.png?v=1649138648 768w\" sizes=\"(max-width: 1452px) 100vw, 1452px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>You can now administer your database.<\/p>\n\n\n\n<p>For example, you can your SQL queries against your database tables right from DBeaver. Just <strong>right click on the database profile<\/strong> &gt; <strong>SQL Editor<\/strong> &gt; <strong>Open SQL Script<\/strong>.<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1442\" height=\"749\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries.png\" alt=\"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-12081\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries.png?v=1649138683 1442w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries-768x399.png?v=1649138683 768w\" sizes=\"(max-width: 1442px) 100vw, 1442px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>This opens up a query editor. Enter the queries you want to run against your database tables;<\/p>\n\n\n\n<p>See for example, to select everything from the <strong>Employees<\/strong> tables;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from Employees<\/code><\/pre>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries-1.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1447\" height=\"751\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries-1.png\" alt=\"Install DBeaver on Ubuntu 22.04\/Ubuntu 20.04\" class=\"wp-image-12082\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries-1.png?v=1649138720 1447w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/04\/dbeaver-run-sql-queries-1-768x399.png?v=1649138720 768w\" sizes=\"(max-width: 1447px) 100vw, 1447px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>Hover the mouse over the other icons to see what they can do.<\/p>\n\n\n\n<p>You can add more databases into your DBeaver for easy administration. That completes our guide on how to install DBeaver on Ubuntu.<\/p>\n\n\n\n<p>Read more on the <a href=\"https:\/\/github.com\/dbeaver\/dbeaver\/wiki\" target=\"_blank\" rel=\"noreferrer noopener\">DBeaver Wiki Page<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Other Tutorials<\/h3>\n\n\n\n<p><a href=\"https:\/\/kifarunix.com\/install-couchbase-server-on-centos-rocky-linux\/\" target=\"_blank\" rel=\"noreferrer noopener\">Install Couchbase Server on CentOS\/Rocky Linux<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/kifarunix.com\/enable-mssql-server-and-database-level-auditing\/\" target=\"_blank\" rel=\"noreferrer noopener\">Enable MSSQL Server and Database Level Auditing<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Follow through this tutorial to learn how to install DBeaver on Ubuntu 22.04\/Ubuntu 20.04. DBeaver is free and open source universal database tool for developers<\/p>\n","protected":false},"author":3,"featured_media":12084,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[121],"tags":[],"class_list":["post-12085","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/12085"}],"collection":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/comments?post=12085"}],"version-history":[{"count":3,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/12085\/revisions"}],"predecessor-version":[{"id":20480,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/12085\/revisions\/20480"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media\/12084"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=12085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=12085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=12085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}