DBeaver is used to connect, query, update and manage a variety of databases through many configurations. I personally use it because it can store many queries and associate them with a particular database or on a particular sheet with related queries. It can make diagnosing problems much more quickly than without organizational features.
Pros
Complex connection configurations
Managing and organizing queries for a large number of different databases
Ability to make proposed updates and then write those once we are ready
Cons
Better navigation especially on the main query screen
Make icons fewer, simpler and more intuitive
vim integration
Likelihood to Recommend
DBeaver is very well suited to general purpose DB interaction, adhoc querying, for complex setups. It does need some time to learn and come up to speed.
DBeaver is used by me to work with SQL Server databases.
Pros
Identify types of DB connections by color code: development, testing and production.
Predictive typing, it is incredibly accurate and saves me a lot of time.
Jump between different simultaneous DB connections.
Navigate through the schema object tree.
Provide all the tools I need in one window.
Cons
Some icons are kinda small and difficult to understand what they do
The spanish translation could be better
I think there are many functions that could be useful for me but I don't know what they do
Likelihood to Recommend
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.
We use DBeaver to connect to our Snowflake instance, as well as our on-premises Microsoft SQL servers. It is very nice because we can query both without having to have an application for each. I find that DBeaver is able to generate the DDL behind Snowflake views much easier than in the Snowflake IDE.
Pros
Querying against Snowflake
Personalizing formatting of T-SQL
Easily connect to Snowflake and other servers
Engaged and caring community
Cons
I would like an option to configure key shortcuts further.
I would like an option to automatically invalidate /refresh connections after a period.
It would be helpful if there was a more intuitive way to "code together".
Likelihood to Recommend
If you are connecting to Snowflake and want to query from your laptop, I find that this is much easier to use than Snowflake's IDE. It allows us as a business intelligence team to more easily connect to our servers, and code with much less hassle. It would be less appropriate if you are only on an on-premises SQL server, in that case, I would just use SSMS.
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.
Pros
Running SQL Queries
Displaying data
Sorting data
Viewing multiple tables
Cons
UI can be cumbersome and confusing
Constant updates creates multiple reminders
Likelihood to Recommend
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 our company as a go-to application to access data and manage relational databases. It is used across multiple departments and addresses the need to conveniently and easily access, read and manipulate the data. Due to its simplicity and at the same time broad functionality, it is successfully used by both technical and non-technical categories of users.
Pros
All-in-one solution that allows connecting to most types of relational and non-relational databases, which eliminates the need to use separate applications for similar tasks.
Allows to auto-generate different types of queries, which saves a lot of time that otherwise would be spent on typing.
Great syntax highlighting, autocompletion and error handling, which allows to swiftly type complex queries.
Cons
It would be great if DBeaver highlighted possible errors in queries in real time manner as the user types.
Likelihood to Recommend
DBeaver is a great all-in-one database tool that would be well suited for any user that requires accessing or modifying data in any of the common database types. Its broad functionality and, at the same time, ease of use make the application easy to use for users of any technical level - from application developers to QA engineers to business analysts.
VU
Verified User
Employee in Information Technology (51-200 employees)
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.
Pros
Easy to make and restore backups.
Good UI for viewing table data & schema. No more command line ever again!
Overall has a large feature set for all database related tasks (users, events etc...)
Cons
The UI is not very modern and looks dated.
A barely noticeable delay when changing views.
Likelihood to Recommend
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.
VU
Verified User
Employee in Information Technology (1001-5000 employees)
A lot of developers use DBeaver for its ease of use. It lets me as a developer do a lot more than a typical SQL client. I especially like the visualization that this tool offers to me. I can easily see how all the tables are connected in an ER diagram and I can make changes and modify it.
Pros
Visuals.
Autocomplete your SQL.
Cons
Sometimes it's clunky and slow.
One time it made changes to prod without me asking it to do anything.
Likelihood to Recommend
For read-only work in dev, I highly recommend it. It will save you time especially with its autocomplete features and ease of use. To modify the data and work in the prod environment I would stay away from this open-source tool. It will still get the work done but you might encounter some issues.
VU
Verified User
Contributor in Information Technology (10,001+ employees)
Its really great to view and manage data in development, staging, and even production databases. DBeaver supports any SQL database nicely, we are using three different kinds of SQL databases (MySQL, PostgreSQL, and SQL server) and I don't need multiple database client tools since all of them could be handled with DBeaver. By doing that, I save a lot of time and PC resources viewing all of the databases we have, which is really great.
Pros
Support a lot of popular database types.
Support SSH tunneling so you could connect to the production database quite easily.
Supports inline editing which is very convenient. Also, you need to click "save" for inline editing to avoid miss clicks or miss typing on the production database.
Cons
No support for NoSQL databases.
The interface could be confusing for first-time users.
No support for multiple queries in one editor.
Likelihood to Recommend
Really good if you have a lot of databases to connect to. Especially if most of them are different types of databases. However, if you only use one type of database, there are other options that might be better suited for your needs since the functionality will be focused on that particular database type.
VU
Verified User
Engineer in Information Technology (11-50 employees)
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.
Pros
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.
Cons
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.
Likelihood to Recommend
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.