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
23 Reviews
Small Businesses (1-50 employees)
Search is temporarily unavailable. Filters are still applied.
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.
Our company is a system integrator. We have several clients with different database systems and we can use a single tool to connect to all the systems.
Pros
Connection to any type of database
Graphical support for creating a query
SQL command composition for various operations
Likelihood to Recommend
It's perfect if you need to interact with various types of databases and copy data from one place to another.
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 (11-50 employees)
I access Databases for personal and professional purposes, across different system. I am a software engineer to use DbVisualizer to create, maintain and query schemas.
Pros
Export all table Schemas with one operation
Search a result set for a string value quickly
Export entire schema table data to a single file with a single command
Export data options very detailed and comprehensive - CSV, text, excel - all are handled
Ability to quickly edit and rename tables and fields
generate DDL and SQL scripts from a table easily
Cons
code formatting in SQL Editor would be nice
Basic autocomplete in SQL editor
Ability to create text shortcuts/macros to fill commonly used strings eg. create a shortcut/macro so that typing 'sel' then hitting TAB key will insert 'select'
Likelihood to Recommend
Really good tool for accessing a new DB schema to understanding e.g. DB schemas in big organisations with zero documentation. I can dump entire DDL to a single file and the data as well, so I can search entire database using grep for a string occurrences, and then figure out the data model in this bottom-up fashion.
It's less well suited for writing/designing large SQL and DDL files because of lack of formatting, autocompletion - I need to use an IDE to create all my big scripts, then test them in the tool.
VU
Verified User
Engineer in Information Technology (1-10 employees)
In my line of work these are the databases used with DbVisualizer. MS SQL, Oracle, MS Access (awesome that this is supported!), MySQL and SQLite. DbVisualizer is frequently used for data management, data retrieval, and running queries to perform specific actions such as calculations, writing procedures, functions and triggers. Extensively using the excellent support of exporting/importing data to and from Excel (or csv file) for further data operations and analysis. DbVisualizer is undoubtedly the best DB tool for daily work with databases, especially the fact that DbVisualizer can handle vast number of different database connections in one software suit.
Pros
Powerful SQL editor for designing and writing queries
Data management and and database browser
Automation of repetitive tasks
Data export to Excel, CSV and HTML
Cons
Better management of saved queries. Instead of using the operating system's folders, built-in list of saved queries with the option to select each would be helpful.
Likelihood to Recommend
If access to multiple database engines is required, DbVisualizer is the clear winner. Also, cross-platform compatibility is a big plus. DbVisualizer runs natively on Windows, MAC and Linux. Excellent tool for Database Administration, data visualization and analysis. Creating workflows for repetitive tasks and data manipulation. All of this makes DbVisualizer ideal choice of tool.
We use it for all manual database interaction. Be it data investigations, initial data profiling, testing methodologies for data manipulation, etc.
Pros
visually organizes connections/queries/data well
handles quick data exports and imports well
handles explain plans well
Cons
does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)
Likelihood to Recommend
It is a very well organized tool, with support for every common db. It imports/exports and allows easy editing of data, on top of the typical querying and scripting.
VU
Verified User
Vice-President in Information Technology (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 (1-10 employees)
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!
