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.
@ 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
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.
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)
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)
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)
I use DbVisualizer every day for my job as database admin and DevOps expert. No other tool gives me the efficiency I need. I have like 10 years of history in the tool that I can pull out frequently. Also, it works like a charm to create and test new databases, script table to easily generate INSERT or UPDATE scripts, I don't want to miss the tool ever again.
Pros
Performance
Script Table
Reference Analysis
Cons
Connectivity to Hyperscaler Databases, e.g. OIDC login
Likelihood to Recommend
Analyzing existing table layouts and the references works particularly well.
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.
I utilize DbVisualizer to quickly access our vast amounts of tables in order to quality check work that I perform in other applications. Having a tool which allows access to the raw data is valuable in these quality checks.
Pros
table export
management of multiple accounts
Cons
There isn't a BI dashboarding capability
Nor notification of table changes
Likelihood to Recommend
DbVisualizer is good when you need a tool that allows for quick access of frequent DBs and Tables.
