DBeaver Information Reviews & Insights

DBeaver is used by me to work with SQL Server databases.

It is the perfect sidekick for every day's database work with SQL Server (I guess with other databases as well). Whether you need to browse data, import/export, alter database objects, compare objects, view automatically generated database diagramas, and so on. I regret every day I spent using SSMS without knowing this tool existed.

I use DBeaver as a graphical interface for accessing databases locally and remotely for testing and data analysis. It allows easy access to viewing data and running SQL Queries against the data as well as updating test data locally.

DBeaver does a lot and has a lot of features, especially for free. Sometimes this amount of features makes the UI tricky to navigate and sometimes it will take more time to get to the place you want to get to. I wouldn't recommend DBeaver for beginners as it may overwhelm them. Still, you can't beat how much control it gives you.

DBeaver is used by both software developers and people who are responsible of support services for a web application with large user base. It allows developers to quickly view and modify database as they are developing the application and testing features. For support people it helps to solve customer queries which need to get information from the database. They also use it to modify database when configuration options for the application needs to be changed.

It's really suited for any scenario related to database management. That includes both viewing the database and making changes. It beats doing things from the command line in every way and helps to avoid doing mistakes because doing things from UI is much more intuitive. Supports large amount of different database vendors.

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.

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.