TrustRadius: an HG Insights company

DBeaver

Score9.2 out of 10

64 Reviews and Ratings

What is DBeaver?

DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.

Top Performing Features

  • Database change management

    Automated scripts for implementing database changes

    Category average: 8.7

  • Change management

    Automated scripts for implementing database changes

    Category average: 8.2

  • Database status reporting

    Detailed reports on database performance, configuration, security, vulnerabilities, etc.

    Category average: 8.6

Areas for Improvement

  • User management

    Tools to help manage user and role administration

    Category average: 8.6

  • Performance optimization tools

    Performance optimization tools measure and maintain overall responsiveness and efficiency of queries, database structures, etc.

    Category average: 8.4

  • Test data generation

    Generation of randomized or real-world test data

    Category average: 6.9

DBeaver - A Great Open Source Tool

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".

Return on Investment

  • It's hard to estimate ROI as it's a free tool - but it's a great tool to use.
  • By using DBeaver amongst the team, we're more easily able to collaborate.
  • DBeaver is very easy to set up and connect, so there was very little trouble onboarding new engineers and getting them providing value.

Alternatives Considered

Snowflake

Other Software Used

Microsoft SQL Server, MongoDB, Oracle SQL Developer

I regret the years I spent working with databases without knowing DBeaver

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

Return on Investment

  • Reduced substantially the time required by database maintenance operations
  • Reduced the error rate when modifying database objects
  • Improved the speed of query creation for data analysis purposes

Alternatives Considered

Microsoft SQL Server

Other Software Used

dbForge Event Profiler for SQL Server

Awesome connectivity, configurability, organization

Use Cases and Deployment Scope

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

Return on Investment

  • Positive Ability to manage DBeaver and query ad-hoc quickly
  • By having the queries saved it has saved developer time and thereby increased the ROI on the investment on the tool
  • This has made firefighting quicker and freed up resources for more development work.

Great DB development tool!

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.

Return on Investment

  • Saved our development team hours of work handcrafting database deployment scripts by generating DDL scripts for us.

Alternatives Considered

dbForge Studio for PostgreSQL, Microsoft SQL Server and Valentina

Other Software Used

dbForge Studio for PostgreSQL, Microsoft Visual Studio Code, Visual Studio IDE

A single database tool for all users and needs!

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.

Return on Investment

  • Using a single multi-platform tool allows companies to save money not having to buy multiple products from different vendors.
  • The simplicity of use and user friendliness allows companies to spend less time and money on user training.

Other Software Used

MS SharePoint, Adobe Acrobat Reader DC, GIMP, Chrome DevTools, Microsoft 365 (formerly Office 365), OneDrive, Notepad++, OBS Studio