Dbeaver – Multi-platform database tool

I can&#x27;t believe how hard it is to find a good database client tool that runs on Linux. I spent hours on Sunday looking for something that worked as well as pgadmin3. I don&#x27;t prefer these Java tools that force you to manage JDBC drivers and usually share dated and cluttered UIs. Plus, I can&#x27;t stand having to manage connections to each database instead of to each server. Let me connect to the server and then select my dB.<p>My notes:<p><pre><code> - Lists - https:&#x2F;&#x2F;wiki.postgresql.org&#x2F;wiki&#x2F;PostgreSQL_Clients - https:&#x2F;&#x2F;wiki.postgresql.org&#x2F;wiki&#x2F;Community_Guide_to_PostgreSQL_GUI_Tools - Clients - Most clients are Java, which is a pain b&#x2F;c - they require you to list the DB in the connection - JDBC drivers can not use a socket connection - UI isn’t great - Valentina Studio - Has free &amp; pro ($199) versions - Was the easiest to get connected initially, but then found bug that showed it wasn’t using socket connection as expected. - Navicat - Linux version is a Wine app - RazorSQL ($100 &#x2F; year) - Is a Java app - Not much different from SQL Workbench, just use that instead? - TeamSQL - Electron, AppImage - Wanted me to enter an email address just to use the software, became privacy concerned about how much stuff would get sent to their servers - DbVisualizer ($197, $69 renewal) - Java - Downloaded &amp; tried it, typical java app - SQL Workbench&#x2F;J (OSS) - Java - Datazenit - web based but still Java? - PgManage - too crude - JetBrains DataGrip ($199 &#x2F; $159) - Java - PgAdmin3 - has lots of errors when used with PostgreSQL 11 - PgAdmin4 - installed, couldn’t get past the splash screen which said it couldn’t find the application server - Sqlectron - Electron - Couldn’t get a DB connection to save - dbForge - Windows only - dbGlass - No longer developed - HeidiSQL - Windows only - DBeaver - OSS and enterprise version</code></pre>

Dbeaver is the best FOSS database UI tool hands down. I&#x27;ve done a lot of searching and haven&#x27;t found anything close. Managed to convert my whole office to it in a matter of months.<p>Favorite features:<p>Well integrated ER diagrams that let you quickly see parts of the db related to current table, or the whole thing if you want.<p>SQL generation from structure or data edits. Great for cranking out DB migrations like a boss.<p>Ability to maintain many database connections at once, and support for doing stuff before&#x2F;after connecting which we widely abuse to setup SSH and VPN connections.<p>Very liberal database support. My original search for a tool like DBeaver was from the need to connect to MySQL, Postgres, and SQL Server and not wanting to use a bunch of different tools. DBeaver supports roughly anything Java supports, which is everything.<p>Wide OS support. Good luck finding another tool that can connect to MS SQL Server on MacOs that isn&#x27;t garbage or money.<p>The icon is also adorable<p>The only downside is a bit of classic FOSS UI clunk. Not nearly as rediculous as Eclipse or Blender or the like, but it takes a few days to get comfortable.

How is no one talking about <a href="https:&#x2F;&#x2F;www.jetbrains.com&#x2F;datagrip&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.jetbrains.com&#x2F;datagrip&#x2F;</a><p>These guys actually fix their bugs. It works on every database known to humans, and also does nearly everything DBeaver appears to do.

I use DBeaver all the time and love it.<p>MySQL, Postgres, SQLite, etc...all the tools I need in one app.<p>I generally try to avoid Eclipse-based projects because they can be very bloated, but in this case it&#x27;s easily justifiable.

Been a user of DBeaver for years - across all my platforms. Its does most things well enough that it has not been a problem to use across SQLite, MSSQL, MySQL and various file based data. Easier to use than SQuirreL which used to be my fav. All of these are java tools I think primarily because of starting from JDBC for which there seems to be a driver for just about everything on the planet.<p>So DBeaver scratches my itch of needing same tool across platforms, across databases.

I like to try out new tools likes this, but whilst on my mac, and I generally use Sequel Pro for my databases (I use mysql and mariadb drop-ins). I have my database locally in a docker container, where I forward 3306 to 3300. Entering host as 127.0.0.1 with correct credentials and port, it gives me this error: &quot;Could not connect: Access denied for user &#x27;root&#x27;@&#x27;172.18.0.1&#x27;&quot;. This does not happen with Sequel, but occurs with Dbeaver. It actually also happened trying TablePlus which is a piece of software that a fellow commenter was mentioning. I&#x27;m sure that it could be solved in my configs by allowing that particular IP, which is the local IP of the virtual machine which is serving docker. However, that is supposed to be completely transparent, thus I should be able to connect through 127.0.0.1. As I haven&#x27;t looked at the source code, it seems like the host lookup logic is flawed, as it translates my `127.0.0.1` to `172.18.0.1`. Why? Dunno. But this occurred in both Dbeaver and TablePlus. Works in my terminal and in Sequel however.

Woah, that ER diagram functionality reminds me of a tool that I tried a long time ago but which I had since forgotten. Back then the tool in question had too many issues and shortcomings, but they may have developed it sufficiently now.<p><a href="https:&#x2F;&#x2F;pgmodeler.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;pgmodeler.io&#x2F;</a><p>Being told about Dbeaver and reminded of pgModeler right now is great because I am currently defining the tables for a project I am working on for a client, and as the number of tables grow jumping back and forth between the files that define each of them adds a still small but noticeable overhead. With a ER diagram tool I might be able to speed up a little part of the definition work.<p>Edit: Hmm, pgModeler might still not be such a great tool <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=17693582" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=17693582</a>

This is a great tool and it makes my life so much easier, so much better than pgadmin4

I stared using Dbeaver a couple months ago, after looking around for an alternative to HeidiSQL on my Windows 10 laptop at work.<p>Used HeidiSQl for a long time but got fed up with issues with it freezing or crashing, especially when switching DB connections.<p>Dbeaver has been fantastic! Has some feautures Heidi didn&#x27;t have, very stable &amp; better looking UI. Thumbs up from me, definitely worth giving a try!

If only it didn&#x27;t have such a PTSD-inducing, eclipse-based UI.<p>HeidiSQL (with WINE) is still by far the best SQL client for me, because the UI is simple yet efficient and very clean.

I&#x27;ve had better experiences with DataGrip, but if I wasn&#x27;t at a place that would pay for proper tools, DBeaver is an OK substitute. Neither, though, have the big thing I want in an analytical SQL workspace:<p>Simple charts<p>A whole lot of my work ends up with a three- or four-column table with one column of buckets, and the other being counts of how many things ended up in that bucket. I&#x27;d love a view where I could render that into a line or bar chart as a sanity check, and have it update in real-time as I change my query. Instead, I end up having to constantly copy&#x2F;paste into Excel and do it there.<p>Yes, I should be using a proper BI or visualization tool for real reports. But sometimes I just need a quick line chart to show that yes, that one count is going in the right direction.

I&#x27;ve used DBeaver at work on Linux to connect to Microsoft SQL servers and also to some PostgreSQL servers.<p>It&#x27;s not <i>perfect</i> but it&#x27;s not bad. My experience was annoying (at best) to get drivers to work; particular the tsql ones (since Microsoft didn&#x27;t provide Linux drivers at the time -- I don&#x27;t know if that&#x27;s been rectified). Once they&#x27;re working though, everything else is fairly intuitive.<p>It&#x27;s been a couple years since I moved to a different team and no longer need to connect to databases (and can&#x27;t anymore... yay security). But I&#x27;ve considered using DBeaver at home for personal use.

I&#x27;ve used TablePlus before (Mac+Windows); its really good, and pretty affordable at a $60 one time charge.<p><a href="https:&#x2F;&#x2F;tableplus.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;tableplus.io&#x2F;</a>

I like DBeaver but I&#x27;ve been having some problems with how it handles timeout of connections. I often end up sitting with it unusable for up to 2 minutes because it can&#x27;t seem to understand that a connection is dead, despite me setting all the available options to use a shorter timeout. I&#x27;m sure this is partly due to my specific network conditions but it nearly destroys its usability while other tools (eg: SquirrelSQL) just don&#x27;t seem to have the same problem.

All of my colleagues use postico (I&#x27;m the only Linux user at my company), which seems quite nice. Can anyone who knows both tell me how this compares to that?

I prefer TablePlus personally, DBeaver just feels clunky in comparison.

I love DBeaver.<p>Long time ago I started searching for a DB-client similar to &quot;TOAD&quot;, but on Linux and targeting only my following key requirements: 1) write &amp; execute single SQLs on a &quot;page&quot; which has multiple SQLs without having to use any terminator (&quot;;&quot;) between them, 2) ability to show the execution plan of the SQL in which the cursor is positioned and 3) ability to connect to different kinds of databases.<p>I ended up with nothing, and I actually even initially excluded DBeaver as running on Java (personal thing - most Java apps I tried always had some kind of bug which made it a no-go for me).<p>After a while I gave it a try and I ended up being extremely happy with it, especially because I can use it with basically all databases that I am&#x2F;was using (I&#x27;m currently using it mostly with MariaDB &amp; Clickhouse, but used it in the past as well with DB2, Kudu, PostgreSQL).

Biggest benefit for me is DBeaver is cross platform so I can use the same tool on Windows (work) and Linux (home).

Love DBeaver, been using it for years now. Engineer(s) is very responsive with github bug reports too.

Pgcli and PgModeler are usually by go-to these days. (Sometimes pgadmin4 if I need to see stats)

I am missing bigger screenshots though, I tried opening them separate but they are quite small.

I use DBeaver to connect to Oracle SQL (among other things) and it works well for this purpose. I tried other alternatives too but DBeaver felt the best among them (layout, options, and general speed).

Just sharing the database management tool I use and love: <a href="https:&#x2F;&#x2F;github.com&#x2F;martingms&#x2F;vipsql" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;martingms&#x2F;vipsql</a>

This looks great. I currently use a few separate applications for working with various databases, looking forward to giving this a shot instead.

I use Navicat, and I&#x27;m very pleased with it.

My company&#x27;s IT team won&#x27;t allow install of non-approved tools. I&#x27;m stuck with oracle sql developer. fml.

It&#x27;s a little buggy but it does everything the paid tools do. The only thing I really dislike is it requires Java.

SSDT and their DACPAC deployments is very good I wish an open source tool will one day try to offer something similar

Dbeaver is great.<p>If you like a cli tool, <a href="http:&#x2F;&#x2F;henplus.sourceforge.net&#x2F;" rel="nofollow">http:&#x2F;&#x2F;henplus.sourceforge.net&#x2F;</a> is ok and easy to modify if you feel inclined.<p>It&#x27;s written in Jython and used jdbc.<p>There is a version with line-editing around using jline.

Doesn&#x27;t work on the Mac right away. It exits with bunch of Java exceptions ranging from JRE versioning issues to Eclipse exceptions I don&#x27;t want to care about. Piece of crap in my opinion. Thanks for the suggestion anyways. Next!

I&#x27;ve been using in on macOS and it just works.<p>There are so many free tools for databases and I&#x27;m wondering : How do the devs survive with free versions and&#x2F;or open source?<p>Don&#x27;t think donations will amount to any relevant amount.

I used Dbeaver for years. Once with MS-SQL, which was quite unstable... But no problem with MariaDB, SQLite and PostgreSQL.<p>Plus, the built-in support of SSH tunnels is a big plus for my use cases!

Cool, can anyone tell how it compares to Datagrip by jetbrains?

After installing solusOS I was looking for a replacement for MySql workbench and was suggested this and I have to say it works really well.

Always used it while ddveloping database connected apps in Eclipse. Never let me down.

Anyone using it with exasol? What&#x27;s your opinion on in memory databases?

Sometimes I use it, but data related for sql server, still prefer HeidiSQL.

What&#x27;s the most convenient tool you&#x27;ve found for Postgres?

Great tool and it supports msaccess files

I use Dbeaver everyday. Thanks for it.

while i kinda like dbeaver on windows. the experience of dbeaver on macOS is terrible.

I&#x27;ve been using DBeaver for years now, and it just keeps getting better and better. I use SQL every day, and DBeaver is the best client I&#x27;ve found.<p>It&#x27;s shocking to me, actually, how absolutely awful most SQL clients are. It truly was an area that was ripe for &quot;disruption&quot;.

Great tool with a great name. Anyone who doesn&#x27;t like it is an idiot :P

Needs Java. I saw it mentioned in the HeidiSQL thread and thought I would try it. Never completed the installation. Not putting Java on my machine, nope. Yes, I do understand the advantages of Java. Runs everywhere, which is nice. I&#x27;m still not installing it.

I would feel uncomfortable saying the word &#x27;beaver&#x27; at work.