TrustRadius: an HG Insights company

DbVisualizer Information Reviews & Insights

Score8.8 out of 10

86 Reviews and Ratings

Get a Demo

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.

DbVisualizer Reviews

13 Reviews
InformationComputer Software9Internet2Telecommunications1Information Services1

Easy to manage data in any db server

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

DbVisualizer is my companion in all task about interacting with databases: mysql, clickhouse, mongodb, postgresql and sqlite.It's very easy to handle load of data from csv or xls and also export data from different databases. The new UI is very clean and easy to use. Testing query on different systems and have a single tool to interact with databases. By centralizing database interactions, DbVisualizer has reduced errors, accelerated troubleshooting, and enabled scalable data governance—critical for our cloud-native, microservices-driven architecture. As Developer I use it for debugging and optimizing SQL queries, analysts generate reports via its visual analytics tools. Its role-based access controls enhance security, while shared connections and saved snippets improve collaboration.

Pros

  • Show database structure
  • Navigate data and quick change values of rows
  • Import data from csv into existing or new tables

Cons

  • It will be great to have an AI assistant for query optimization or specific knowledge about sql dialects or mongodb pipelines
  • Data migration tool from one database to another
  • Programming language code generation from code template: create PHP code to do this query or this data migration. Create a prepared statement

Likelihood to Recommend

It suits perfect for developer having to connect to multiple environment of customer sites and make all connections organized. A great companion for daily activity.
Testing query and debugging issues related to data into the database.

Alternatives

phpMyAdmin, DataGrip and DBeaver
Easy to run as a standalone application, largest sets of db drivers and very efficient UI/UX for the data manipulations task.
DR
Dario Rigolin
CTO in Information Technology at Comperio srl (Computer Software, 1-10 employees)
Vetted Review
DbVisualizer
10 years of experience
View profile

One stop SQL tool with wide database type support

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

We use DbVisualizer for many things daily but primarily for quick queries to prod and dev database systems monitoring and triaging complex data issues as they arise. We also use it to develop ad-hoc "report" SQL for customer and internal requests.

Pros

  • Wide database support. One tool for all database flavors
  • Easy to save and re-use complex SQL in the future
  • Clear UI that is easy to spend hours each day looking at and using.

Cons

  • We have some issue with dropped connection, but I believe the root of this is not with DbVisualizer

Likelihood to Recommend

I've used this specific tool for many years now, on a daily basis. It's my go-to database tool. It works, has wide support for various database flavors and is easy to use. I recommend it
VU
Verified User
C-Level Executive in Product Management (Computer Software company, 11-50 employees)
Vetted Review
DbVisualizer
8 years of experience

DbVisualizer Review: My multi-year experience

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

This product has become an indispensable part of my developer repertoire. Whenever I'm dealing with a database, either one of my own creations or someone else's, this is the product I turn to. It allows me to discover database schemas, run queries, alter tables, indices, views, etc., and basically do anything and possibly everything I can do to a database - be it SQL based or NoSQL based, large or small.

Pros

  • Provides simple access to all tables, indexes, views, triggers, stored procedures, etc., to just about every database on the market
  • Allows me to develop and run queries in a simple, easy to read and understand manner
  • Allows me to create entire new schemas as well as alter existing schemas
  • Gives me access to databases without the need to install specific drivers for any particular database

Cons

  • The record limit, while usually accessible on-screen, moves around based on what the current view is or is not there at all sometimes
  • Pressing the STOP button on a query does not immediately stop the query
  • Updates, while always welcome, sometimes seem to come with too much frequency

Likelihood to Recommend

I cannot emphasize enough how much this product has made my life easier when dealing with databases. It is my sole go-to source regardless of the type of database I need to deal with when I need to crack open a table or two. I used the free version for a couple of months, many years ago, and have paid for it ever since. It's worth the price to help keep this product on the market and keep it growing.

Alternatives

MySQL Workbench, Microsoft SQL Server, Oracle Database and PostgreSQL
The only time I use a product that is specific to a particular database is when I need to perform some product-specific function on that database. Otherwise, for everything else, I use DbVisualizer.
VU
Verified User
C-Level Executive in Information Technology (Information Services company, 1-10 employees)
Vetted Review
DbVisualizer
8 years of experience

DbVisualizer in 5 minutes

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

DbVisualizer is used as a basic tool for accessing databases. For data analysis, transformation and verification. Most database operations are performed using DbVisualizer. Also, fast implementation of new databases thanks to scripts is performed without errors and, most importantly, the process is 100% reproducible. The tool is the basic software used by developers as well as administrators.

Pros

  • DB data reading
  • Interaction with external drivers
  • Export of data to external formats

Cons

  • Administrative tasks
  • Import data from text files
  • Analysis of database sessions

Likelihood to Recommend

Great for daily work with many different databases
Not enough administrative and diagnostic options

Alternatives

Oracle SQL Developer and Toad Edge
DbVisualizer is cheaper but more powerful than TOAD
SQL Developer is a free, very basic tool with limited capabilities
VU
Verified User
Engineer in Research & Development (Computer Software company, 1-10 employees)
Vetted Review
DbVisualizer
3 years of experience

Quick and easy cross DB interrogation and data structure overview.

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

As a software development consultant with projects across multiple databases back ends, we use DBVisualizer as an SQL debugging and investigation tool as it provides simple and seamless connection across all of our DB environments. The simple interface for viewing data subsets as well as an instant view of data structures makes tracking down issues so straightforward compared with using (and learning) a different tool for each database.

Pros

  • Multi database support in same interface.
  • Quick graphical representation of data structures from table relationships.
  • Easy extraction an export of data subsets in many formats.

Cons

  • More of a java driver issue but daylight saving date/time translation in non-timezone field types can be problematic (DB2 timezone fields in particular).

Likelihood to Recommend

Multi DB issue tracking/debugging is a strength. Support for non-standard SQL features with some databases could be better although this could be JDBC related.

Alternatives

Oracle SQL Developer
DbVis supports every DB we use. SQL developer is only Mysql and Oracle (although it is the go-to for any complex Oracle issues).
GW
Gerard Weidland
Managing Director in Information Technology at Datawealth Pty Ltd (Computer Software, 1-10 employees)
Vetted Review
DbVisualizer
12 years of experience

Great Database Client

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

I use DbVisualizer on a daily basis to monitor and analyze what is happening in our data store. Usage is mostly for RDBMS systems (Oracle, DB2, Postgres, MySQL.

Pros

  • Snappy.
  • Intuitive.
  • Large number of supported Datasources supported out of the box.
  • Great visualizations to reverse engineer schema.

Cons

  • Support for more NoSQL datasources (DynamoDB, for example).

Likelihood to Recommend

For any use case, I can imagine DbVisualizer is the best general-purpose SQL client that I have ever used. I have tried others, but keep coming back to DbVisualizer every time.

Alternatives

The big advantage DbVisualizer has over a lot of the DB clients out there is that it is not tied to a particular database. It can be easily used across many data sources. Its other advantage is that it is intuitive to use and you can be up and running in a couple of minutes.
RA
Robert Arseneault
Chief Architect in Research & Development at Amira Learning (Computer Software, 11-50 employees)
Vetted Review
DbVisualizer
14 years of experience
View profile

DbVisualizer - The Swiss Army Knife For Your Databases

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

DbVisualizer is used mostly by our development team as their main tool to work with the various databases we have. We use it to run queries, perform data analysis, and more. DbVisualizer supports most of the common databases available on the market. This means we only need this one tool for all our databases, instead of having to have a different tool for each database.

Pros

  • Supports most common databases on the market
  • Available for Windows, Mac, and Linux
  • Clean and easy to use interface

Cons

  • Would be great to support NoSQL databases

Likelihood to Recommend

DbVisualizer is a great tool to use with relational databases such as MySQL, PostgreSQL, etc... If your organization has different databases, then having DbVisualizer will allow you to have a standard tool to work with all of them. However, if you only have one type of database and your DBA is highly skilled with that particular database, then you probably should go with whatever tool he/she is most comfortable with. In either case, you can't go wrong with having DbVisualizer in your toolbox.

Alternatives

DbVisualizer was our go-to solution and we didn't really consider other alternatives.
VU
Verified User
Employee in Information Technology (Computer Software company, 1-10 employees)
Vetted Review
DbVisualizer
9 years of experience

Best DB Querying Tool

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

DbVisualizer is the mostly used Data Tool in our org. It is widely used by Data Engineering community, Data Scientists and Data Analysts.
DbVisualizer querying tool helps with importing and exporting data. Timed SQL execution and real-time graphs are the killer features. It is a multiple-platform tool, based on Java but with a native look and feel.


Pros

  • Timed queries that add their result to the result grid for every execution are helpful. Creation of graphs also extremely helpful.
  • Query history and auto-recover feature makes sure we don't lose our queries.
  • Actions like exporting grids to Excel or other tools is a very easy task.

Cons

  • Having the JDBC drivers in a fixed location outside of the application package helps during upgrades.
  • Sometimes the app crashes if we export huge amount of data but that's expected.
  • Navigating to the configuration section is quite difficult for beginners.

Likelihood to Recommend

[DbVisualizer is] extremely useful with Salesforce (assuming availability of an appropriate JDBC driver).
Easy to discover schema, save schema, duplicate databases for multiple environments.
Shows all data in a specified table Data exportable and importable as CSV.
Has most useful features - SQL History, Format SQL, SQL Preview, View data, Explore tables, Generic connection support, Search function.

Alternatives

DBeaver and IntelliJ IDEA
[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.
VU
Verified User
Engineer in Engineering (Internet company, 5001-10,000 employees)
Vetted Review
DbVisualizer
2 years of experience

Now I don't have to search anymore ... :)

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

[DbVisualizer] is the ultimate database management software.
I was looking for a tool that also had easy and presentable ER diagram generation for technical documentation.
We use it for Postgres, SQLite, MySQL and Oracle with excellent results, but it supports many other databases.
Another advantage is that DbVisualizer is cross-platform, I use it on a MAC without any problem.
After years of research, we finally found what we were looking for.

Pros

  • Multiplatform
  • Easy to use
  • ER diagram
  • All-in-one

Cons

  • In-place blob visualizer
  • Simplify ssh tunnel connection

Likelihood to Recommend

DbVisualizer is useful for any data related purpose.
Not easy for customers who are not part of the IT department and not good for Business Intelligence analytics.

Alternatives

DBeaver
DbVisualizer is closer to my user experience patterns
AA
Antonio Arcucci
Senior Software Engineer in Information Technology at Logicos s.r.l. (Computer Software, 1-10 employees)
Vetted Review
DbVisualizer
2 years of experience

DbVisualizer--solid DB tools for 15+ years

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

I use DbVisualizer to query RDBMS and non-relational data. For us, it solves the problems of determining a structure in an org that doesn't have a dedicated DBA role. It further helps our DBA-lacking org with evaluating query performance and updating live data.

Pros

  • Visualizing existing table relations
  • Query performance reporting
  • Multiple database support

Cons

  • Support other non-RDBMS structures--Dynamo, memcached, redis
  • An option when clicking in the tree to always open a new window
  • Import/address parquet tables

Likelihood to Recommend

DbVisualizer is really useful where there's a JDBC connection to an existing data store and that data store supports a SQL interface. It's less useful, although functional, at many non-relational stores. I'd recommend it for small departments where the engineers need to poke around on an existing database. I'm not sure I'd recommend it at an organizational level since the use cases for DbVisualizer tend to be very team and data specific.

Alternatives

IntelliJ IDEA
DbVisualizer is a more complete and more functional universal tool than IntelliJ's built-in SQL client. It supports more storage systems than SquirrelSQL or MySQL Workbench. I've also had a license for DbVisualizer since 2006, so there's a bit of inertia on my end.
KS
Keith Sader
in Engineering at All of them (Internet, 1001-5000 employees)
Vetted Review
DbVisualizer
15 years of experience
View profile