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 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.
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)
DbVisualizer allows me to much more efficiently perform my duties as a DBA. For example providing an overview of database structure, allowing me to easily view procedure and table definitions, enabling easy export of result set data for report generation, and the fact that I can keep several SQL Commander tabs open at once allows me to multitask well. I have tried many other similar products, but DbVisualizer is the only one I actually enjoy using.
Pros
Overview of and easy grouping of database connections
Wide variety of export options for result set data
Ability to view procedure definitions in an easy way
Per-connection customizable UI to for example give a visual cue of what kind of database one is connected to.
Cons
Being able to change the maximium heap space from within DbVisualizer would be very useful
There is a popup that appears when I hover over tabs for a moment, but after I move the cursor away and it disappears, it reappears immediately after I hover over the tab again which can get very annoying as it blocks whatever is behind it
The autofill feature is a little annoying as it will sometimes autofill every single column of a table when I press enter to make a new line in a query. It is still useful but I wish there was a way to more easily choose when or when not to autofill
Likelihood to Recommend
I use DbVisualizer in most situations when dealing with normal everyday queries and DBA activities, for producing reports, or for getting an overview of various databas objects. For changing configuration parameters and creating functions or stored procedures I prefer working directly on the machine but that is a personal preference.
VU
Verified User
Administrator in Corporate (Computer Software company, 11-50 employees)
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.
VU
Verified User
C-Level Executive in Information Technology (Information Services company, 1-10 employees)
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
VU
Verified User
Engineer in Research & Development (Computer Software company, 1-10 employees)
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.
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.
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.
VU
Verified User
Employee in Information Technology (Computer Software company, 1-10 employees)
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.
VU
Verified User
Engineer in Engineering (Internet company, 5001-10,000 employees)
