DBeaver

All in one Database tool

October 1, 2021 by cryan.com

The past few months I have been doing a lot of database work. I was looking for a good application that I could use that wasn't limited on the type of database. I was recommend DBeaver - the free Universal Database tool.

Five Reasons Why I Like DBeaver

1. Database Support - The application pretty much supports any database you need: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto and more. (A total of 89 different database connections are available out of the box!)
2. SQL Generation - You can easily moved text between tables. Simply select a bunch of rows, right-click and select "Generate SQL." You'll get a copy of the SQL statements as insert statements. Useful when you want to delete a row and reinsert it again to test triggers.
3. In Grid Editing - Easily change data in the grid - just like excel. DBeaver makes it so much easier to manipulate the data. Once you make all the changes, simply commit it.
4. SQL Views - Very easy to create/modify views. In one of my projects, I didn't use many database views. When using DBeaver, it was easy to create and modify SQL views.
5. SQL Scripts - Create and Save SQL Scripts for various projects. Makes it very easy to reuse past queries. You can even search through SQL Scripts for code - making it a great resource to reuse SQL commands.