TrustRadius: an HG Insights company

DBeaver

Score8.5 out of 10

79 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

  • Schema maintenance

    Maintaining schema integrity via regular maintenance

    Category average: 8.6

  • User management

    Tools to help manage user and role administration

    Category average: 8.4

Areas for Improvement

  • Database security

    Security maintenance such as authorization management, log analysis, database auditing

    Category average: 8.2

  • Change management

    Automated scripts for implementing database changes

    Category average: 7.8

  • Database status reporting

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

    Category average: 8.2

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

Fully functional good tool

Use Cases and Deployment Scope

I use DBeaver every single day as a data engineer. I use it to navigate though the database and to create tailored reporting for needs of the organization.

Pros

  • Helps querying
  • Mapping tools
  • ERD diagram views

Cons

  • Gets overloaded with large queries easily
  • Frustrating saving abilities
  • Crashes semi often

Return on Investment

  • Use daily for data needs
  • Fast querying and testing
  • Mapping views outside of spreadsheets

Usability

Alternatives Considered

pgAdmin

Other Software Used

Salesforce CMS, Google Drive, ChatGPT, OneDrive

DBeaver. The data viewer.

Use Cases and Deployment Scope

I use DBeaver to connect to remote databases and explore and manipulate data when needed

Pros

  • Managing remote connections
  • Query formatting
  • Execution status

Cons

  • Shortcuts
  • Editor
  • Reconnection if the password changes

Return on Investment

  • I can connect to remote databases quickly for debugging
  • Comparing schema is easy
  • Understanding the constraints are easy

Usability

Alternatives Considered

Sequel Pro

Other Software Used

Cursor, Microsoft Visual Studio Code, Slack, Sentry, Linear App, A Cloud Guru (Linux Academy), Pluralsight Skills, Udemy Business, Google Cloud Build, Google Cloud SQL

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

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.