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.
Loading Reviews List....
DbVisualizer Reviews
12 Reviews
Engineering
Search is temporarily unavailable. Filters are still applied.
I initially used DbVisualizer for developing queries for an application I worked on for 13 years. Now I'm in data science I use this tool for analysis.
Pros
Easy configuration of a variety of databases
Nice visualization of explain plans
Intuitive
Cons
Colleagues of mine use TablePlus. The one thing I'm envious of TablePlus is how is displays its data. It has the typical table layout of a result set that all tools have, but if you select a single line it will display that line's data in another pane but horizontally, which I find easier to navigate and digest when the row is very wide.
It would be nice to not have to wrap PL/SQL statements in DbVisualizer markup. Other tools don't require this.
Likelihood to Recommend
I've always found DbVisualizer to be very intuitive to use and easy to manage the many DB connections that I have. I use DbVisualizer in all of my work (application development and data science), so I haven't encountered a scenario where it was not useful.
I use DbVisualizer to write queries and manage databases. It's been my go-to tool for querying databases for over 20 years. It's nice that one tool supports many different database systems, including ones I have used: Oracle, Vertica, Redshift, SQL Server, MySQL, and Postgres. And the few times I've needed support, the DbVisualizer staff has always responded quickly!
Pros
Creating scripts from existing databases (for example, table create)
Data export (in a variety of formats)
Visualization/charting of results
I like that DbVis. updates the software regularly
Cons
I cannot think of any areas where improvement is needed
I like that dbvis updates the software regularly
Likelihood to Recommend
It is particularly well suited if you are working in an organization that uses many different database systems. In my previous position I was regularly connecting to Vertica, SQL Server and Redshift and it was nice to use the same (powerful) tool for all of them!
I use DbVisualizer to manage many database servers that we use in everyday life. Additionally, I appreciate that it supports a lot of different databases. These are in our house MsSQL and MySQL/MariaDB. I especially like the performance of directly editing the values in the table itself, as well as the filter in the view.
Pros
Fast and easy to use
Keep unsafed editor tabs
inline edit
organize many database servers
Cons
functionality for NoSQL databases (e.g. MongoDB)
Database Backup/Restore/Copy
handle many sqls without a ; at the end (e.g. MsSQL)
auto completion should not insert the table namen
Likelihood to Recommend
Thumbs Up - Handle many Databases - To organize tabs in any possible way - Inline edit
I use DBVisualizer as our SQL client of choice for all of my relational database needs on the back of our internal-facing Web Apps, primarily revolving around workflow automation, data visualization/centricity and team connectivity.
Pros
Provides a lightweight SQL client
Easy to setup DB connections
Intuitive interface
Cons
File export process is a bit clunky
No NoSQL support
No way to kill DB connections
Likelihood to Recommend
DBVisualizer is a near-perfect tool for any RDBMS needs. The sleek interface is intuitive for new users, query speed is unmatched, supports all notable database engines, and has plenty of bells and whistles for all use cases. Particularly well-suited for rapid web development, less so for more administrative tasks (DB configuration, creation/restore, etc.)
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.
I use DbVisualizer as a front-end to manage Postgres and MySQL databases in our organization. If you want to use only one tool to access all your databases, I recommend this one.
Pros
View all databases and schemas with one connection.
View/modify rows in a table.
Easily modfiy schemas, tables or generate the SQL code for the modifications.
Visualize relations between tables.
Autocomplete SQL queries.
Cons
Would be nice to have management functionalities, like viewing the number of connections, kill a connection, etc.
Likelihood to Recommend
Well suited for viewing and modifying data, viewing/modeling/modifying database objects like schemas, tables, functions, etc. Not well suited for managing configurations, users, connections, etc.
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.
I use DbVisualizer to develop and maintain on a lot of servers. It has a very wide support for different database systems, however I only use it for mysql, postgres and sqlite. It is really powerful and feature rich. Also, it has great support from the company. I had reported a bug once and it got resolved very quickly in the next release + they notified me to test it and confirm it was fixed. I have tried many different db clients for development and maintenance over my career - once I tried DbVisualizer I have never installed another one. If I had 1 thing that I would like to improve is support to sync and run DbVisualizer across my computers. Would recommend 10/10
Pros
Excellent multi database support
Very powerful and customizable
All-in-one solution
Cons
Cross-device sync / cloud storage support
Likelihood to Recommend
It is a great and powerful tool for development and debugging