TrustRadius: an HG Insights company
Back to Overview
DbVisualizer Logo

DbVisualizer Reviews and Ratings

Rating: 8.9 out of 10
Score
8.9 out of 10

Community insights

TrustRadius Insights for DbVisualizer are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Business Problems Solved

DbVisualizer is a powerful tool that users rely on for a wide range of data management and analysis tasks. With its ability to connect to various data sources, such as Oracle, Informix, and DB2, DbVisualizer eliminates the need for multiple IDEs, providing a seamless experience for users. The software's easy and presentable ER diagram generation has been highly regarded by users, making it an invaluable tool for technical documentation.

DbVisualizer supports a wide range of databases, including Postgres, SQLite, MySQL, and Oracle, making it a versatile choice for users. Its cross-platform compatibility allows for seamless usage on different operating systems like MAC. Users express satisfaction with DbVisualizer as it meets their requirements and expectations after years of research. They appreciate its all-in-one nature, as it allows them to write queries, manage databases, and perform initial data loads.

DbVisualizer's ability to query databases and analyze SQL costs, regardless of the brand of the database, is also praised by users. It has proven to be an indispensable tool for developers, data engineers, data scientists, and data analysts alike. With its simple interface, DbVisualizer enables users to view data subsets efficiently, analyze data structures effectively, and track down issues seamlessly. Furthermore, the software's wide support for different database systems like MySQL, Postgres, and SQLite contributes to its popularity among users.

Overall, DbVisualizer is widely used across various industries and departments for tasks ranging from query development to data analysis and visualization. Users value its reliability and performance in accessing databases and performing crucial data-related tasks. With its extensive features and capability to handle structured data tasks across a variety of databases, DbVisualizer has solidified its position as a go-to tool for managing and administering databases in production environments.

Reviews

57 Reviews

Our go-to database tool.

Rating: 10 out of 10

Use Cases and Deployment Scope

We’re a digital marketing agency with a large data warehouse that uses multiple databases, and we interact with many database types and integrations for our own needs as well as those of our clients. DbVisualizer makes this very simple with easy integrations to every type of database we’ve needed to connect to, with a fantastic UI that makes working across databases easy and all in one spot.

Pros

  • Out-of-the-box support for many different databases.
  • Intuitive UI for interacting with data.
  • Flexibility of SQL Commander for writing scripts.
  • Great support for working with JSON data in recent updates.
  • Database connections over SSH.
  • Table relationship visualization is very helpful.
  • The tree view is well organized in how it splits out schemas.

Cons

  • Would be great if we could update individual JSONB properties directly in the JSON viewer window.
  • Sometimes, when a table structure is changed (e.g., adding columns), the changes are not reflected when viewing the table because the old structure is still cached.

Likelihood to Recommend

It has been immensely helpful for data exploration in relational databases. SQL Commander is very capable (and scriptable) for quickly investigating data and testing queries.

MM
Mike McGugan
COO in Information Technology at Tráfico Digital Marketing (11-50 employees)
Vetted Review
DbVisualizer
5 years of experience
Verified on LinkedIn

DbVisualizer is a great IDE

Rating: 10 out of 10

Use Cases and Deployment Scope

I perform Data Engineering with DbVisualizer to power our the analytics of our entire company. The product is great for not only that, but also writing ad hoc queries and doing deep analytics. Its easy to export data into Excel and also add/update rows or values within the tool without needing to write the UPDATE statement yourself. Its easy to use and I recommend it to anyone looking for a nice IDE.

Pros

  • Export to Excel
  • Object navigation
  • DDL viewing

Cons

  • The Excel export sometimes bugs out

Likelihood to Recommend

Anyone who needs to connect to a database to either run queries or perform data engineering can benefit from DbVisualizer. The only time someone wouldn't benefit is if they're working from a canned Excel or Tableau workbook with an embedded data source they can't change.

TS
Tyler Sellers
Head of Data & Analytics in Engineering at Amplify Life Insurance (51-200 employees)
Vetted Review
DbVisualizer
7 years of experience

My standard way of querying databases for over a decade

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

I need to routintely check data in Oracle, DB2, Cassandra databases

Pros

  • love the ability to edit data in cells like a spreadsheet
  • organising all my connections in to folders and marking them as prod with yellow and black stripes
  • the filters so I can hide database objects that I am not interested in

Cons

  • I would like to see the "References" tab and its functionality expanded to allow it become even more powerful to support documentation requirements

Likelihood to Recommend

In my organisation people use SQL Developer but I prefer DbVisualizer because it is DB agnostic and therefore all of my DB work can be centralised in one GUI.

VU
Verified User
Engineer in Engineering (5001-10,000 employees)
Vetted Review
DbVisualizer
10 years of experience

A great software product

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

As a software developer I build and support products with many different types of database connections. DbVisualizer gives me one coherent workspace to work with a wide variety of data sources that support SQL. And it runs in exactly the same way across different operating systems.

Pros

  • SQL intellisense
  • Exports to spreadsheets
  • Data editing in tables
  • Graphical table altering
  • Remote connections via SSH

Cons

  • Nothing

Likelihood to Recommend

If the colleague works with SQL I will recommend DbVisualizer anytime. For colleagues who are not comfortable working with SQL I am not so sure.

FS
Frank Sørensen
Software Developer in Research & Development at Clondyke Software (1-10 employees)
Vetted Review
DbVisualizer
12 years of experience
View profile

As good as advertised and more! Customer since 2003.

Rating: 9 out of 10

Use Cases and Deployment Scope

@ TECASSURED we are a software plateform provider - our ADMIN system solution provides each client with 2 database priority to their instance. We manage 1000's of database with this DbVisualizer - awesome solution - happy customer for over 20 years. ;)

Pros

  • Manage multi database connection
  • drag and drop SQL statements
  • reporting

Cons

  • Quicker start up
  • scheduler to run Monitors/Files
  • Email from application

Likelihood to Recommend

With my knowledge and needs it is best solution I have found - very robust may be to confusing for general needs I.E. phpAdmin

JP
Joseph Pesce
CEO in Engineering at TECASSURED llc (11-50 employees)
Vetted Review
DbVisualizer
23 years of experience
View profile

That tool replaces your SMSS easy

Rating: 10 out of 10

Use Cases and Deployment Scope

We are using DbVisualizer to manage easy access to a lot of different database systems for fast query and database manipulations.

Pros

  • Multiple Database Systems
  • Alter and Modify Database Structure
  • Mass Import and Export from Data

Cons

  • MSSql Server /Azure Driver connection timeouts/restort
  • Intellisense like behavior (autocomplete)

Likelihood to Recommend

Its well suited to manage your databases from one programm and as well for the mass import of data.

BR
Bernhard Reiter
Software Developer in Engineering at CrossVault GmbH (1-10 employees)
Vetted Review
DbVisualizer
15 years of experience

Ol' Reliable

Rating: 10 out of 10

Use Cases and Deployment Scope

The product I am in charge of requires data from 6 different sources across a handful of different driver types to run monthly processes. DbVis allows my analysts & me to have access to all sources in one convenient program.

Pros

  • Supports numerous drivers (Snowflake, SQL Server, Teradata, Hive, DB2, etc.)
  • Allows for full data set to be extracted (no forced row limits/"sample data" pull before the actual pull)
  • Customizable settings for font colors, processing capacity

Cons

  • Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
  • Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
  • (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)

Likelihood to Recommend

DbVisualizer is most helpful for our team because it allows us (under my Pro license) to have multiple tabs open running different code simultaneously from different platforms. Other than the lack of upload capability (or lack of knowledge of that capability on my part), there isn't much I'd choose other tools for over DbVis.

VU
Verified User
Consultant in Finance and Accounting (10,001+ employees)
Vetted Review
DbVisualizer
7 years of experience

Jeremiah's review

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We use it to request our ERP, select and update, for reporting and error correction, daily with 11 users. As an insurance broker, our data are a critical thing, we also use DbVisualizer to planify requests during the night, we hope DbVisualizer will contain a scheduler in a later version.

Pros

  • batch
  • interactive

Cons

  • integrated scheduler
  • impossible to close other tabs in the actual version !!

Likelihood to Recommend

Good for editing datas in a grid

Good for newbies and non-IT people

VU
Verified User
Project Manager in Information Technology (11-50 employees)
Vetted Review
DbVisualizer
2 years of experience

DbVisualizer Review

Rating: 10 out of 10

Use Cases and Deployment Scope

I use it to test data queries before putting the query into another application for automated reporting and ro pull ad hockey data requests

Pros

  • Easy access to all of my data sources at once
  • Multiple tabs that can keep frequently used queries open
  • Pinpoint errors in coding when you have a typo

Cons

  • When you select a database and schema at the top, you shouldn't have to type it again in the from statement. I found i have to When not pulling from the default schema using my Ms sql server database. Snowflake seems to work.
  • I like auto complete for writing queries. But found it hard to use in DbVisualizer. I've had it off for years. Can give it another try. Don't even remember why I didn't like it
  • I wish I could organize my groupings by schema in a database not just get a long list with all schemas and tables. Would reduce scrolling

Likelihood to Recommend

I found it to be the best tool for multiple data warehouses in one place. Currently use it on snowflake, ms sql server, redshift, and other data

VU
Verified User
Manager in Information Technology (5001-10,000 employees)
Vetted Review
DbVisualizer
14 years of experience

Effective tool for db development and administration

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

SQL Server db development and administration

Pros

  • exports data to csv or Excel easily
  • connects to multiple data sources
  • query visualizer is intuitive

Cons

  • see column descriptions by default

Likelihood to Recommend

formatting and reviewing SQL scripts; dealing with extended properties

VU
Verified User
Director in Information Technology (11-50 employees)
Vetted Review
DbVisualizer
3 years of experience