October 1, 2021

DBeaver

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.

DBeaver Logo

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.

Add your Comments

Feel free to leave a comment about this post.

- Feel Free to add HTML to your comment!