{"id":2352,"date":"2022-04-05T09:13:52","date_gmt":"2022-04-05T06:13:52","guid":{"rendered":"http:\/\/kifarunix.com\/?p=2352"},"modified":"2024-03-09T12:18:42","modified_gmt":"2024-03-09T09:18:42","slug":"how-to-install-dbeaver-on-debian","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/how-to-install-dbeaver-on-debian\/","title":{"rendered":"Install DBeaver on Debian 10\/Debian 11"},"content":{"rendered":"\n<p>Follow through this tutorial to learn how to install DBeaver on Debian 10\/Debian 11. <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 Debian 10\/Debian 11<\/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 Debian;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"#use-linux-installer\">Install DBeaver using Debian Binary Package<\/a><\/li>\n\n\n\n<li><a href=\"#install-from-snaps\">Install DBeaver from Snap Store<\/a><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"use-linux-installer\">Install DBeaver on Debian the Linux Debian 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 Debian 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;<\/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 Debian from Snap Store<\/h3>\n\n\n\n<p>You can also be able to install DBeaver from Snap store.<\/p>\n\n\n\n<p>Snaps are not installed by default on Debian. They can be installed as follows;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>apt update<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install snapd<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>snap install core<\/code><\/pre>\n\n\n\n<p>Next, logout of your system and log in again;<\/p>\n\n\n\n<p>Install DBeaver from Snap store;<\/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 Debian 10\/Debian 11<\/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 Debian 10\/Debian 11\" 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 Debian 10\/Debian 11\" 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 Debian 10\/Debian 11\" 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 Debian 10\/Debian 11\" 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 Debian 10\/Debian 11\" 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 Debian 10\/Debian 11\" 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 Debian.<\/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 Debian 10\/Debian 11. 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":[4820,4821,4819,4817,4815,4816,4818],"class_list":["post-2352","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos","tag-dbeaver","tag-dbeaver-ce","tag-dbeaver-db-administration","tag-debian-dbeaver-install","tag-install-dbeaver-on-debian-10","tag-install-dbeaver-on-debian-11","tag-install-dbeaver-on-linux","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\/2352"}],"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=2352"}],"version-history":[{"count":5,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/2352\/revisions"}],"predecessor-version":[{"id":20482,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/2352\/revisions\/20482"}],"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=2352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=2352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=2352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}