Great DB development tool!
January 23, 2019

Great DB development tool!

Aaron Smith | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with DBeaver

Our development staff uses DBeaver for editing database/table schema (when needed) and for creating production deployment scripts. We are using the free community edition and it is extremely stable and works very well. Since it supports multiple databases, we can also use it for Microsoft's SQL Server, but we currently only use it for PostgreSQL. Compared to other products on the market, it did what we needed to do, even though sometimes the UI can be a little unintuitive compared to what we are used to with SQL Management Studio.

The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.

While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
  • Data import/export and SQL Script generation are quick and simple to do.
  • Fairly intuitive when viewing/editing table data.
  • Ability to save SQL scripts per server and recall them easily.
  • Handy intelligence when writing queries, functions, and stored procs.
  • Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
  • Sorting and filtering in data is nice, but buried in long right-click menus.
  • Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.
  • Saved our development team hours of work handcrafting database deployment scripts by generating DDL scripts for us.
dbForge Studio has a more intuitive UI for die-hard Windows users. It's also easier to use sorting and filtering in their grids. However, that one lacked the script generation and schema editing tools our development team needed to use on an almost daily basis.

Valentina had the features they needed, but the UI was just not palatable for them to use.
Great tool for developers to use to dive into their databases. Not so great if you are a die-hard Windows user with expectations of a SQL Management studio replacement. This is the less suited tool for people looking to just view and edit data. If you need to generate any scripts or import and export data, this is the tool to use.

DBeaver Feature Ratings

Test data generation
Schema maintenance
User management
Database status reporting