I use DbVisualizer as my primary SQL client for working with multiple
database systems. As a GIS Solutions Architect, I regularly
connect to PostgreSQL/PostGIS, Oracle, SQL Server, and SQLite databases from a single unified interface. Before using DbVisualizer, I needed to switch between different
database-specific tools. DbVisualizer solves this by
providing a single tool for multiple databases,
eliminating the overhead of managing several applications and learning
different interfaces. This streamlines my workflow when working with
diverse database systems.
Pros
Multi-database support in one interface.
Context-aware SQL autocomplete.
Visual data exploration.
Inline data editing and export.
Cons
SSH certificate support.
Performance with large result sets.
Limited script debugging features.
Likelihood to Recommend
Seamlessly querying PostgreSQL/PostGIS, Oracle, SQL Server, and SQLite from one interface without switching tools. The intelligent autocomplete and schema browsing make it ideal for writing queries and understanding unfamiliar databases. Complex performance tuning, deep monitoring, and automated backup/recovery require specialized DBA tools. Performance degrades with tens or hundreds of thousands of rows; command-line tools or ETL solutions are better suited to bulk data processing.
VU
Verified User
Professional in Information Technology (Computer Software company, 11-50 employees)
We use dbvis to test database connections during the installation of our product on customers' servers. This lets us verify that a connection is not 'lost' on the way to the database. As we use JDBC as our primary connection method, DBIS provides an easy, additional, and independent way to test the connection. We use dbvis to check stored data, review table structures and metadata (e.g., when selects or inserts fail), and verify table permissions for the user who is having connection issues. We love the in-cell data editing feature, which is much easier than building SQL queries for every entry. This also allows a quick manual review of the stored data, even with large tables, and fixes the most obvious errors instantly. We test, build, and also 'deconstruct' SQL queries when there is a need to check on long-running queries. This helps us identify, for example, misused indices and other issues. We use it to easily export complete tables and data for a wide variety of DBMS for our customers and ourselves. It helps us visualize relationships and identify faults that are often not obvious within our codebase.
Pros
Easy visualize Db-data.
Connect to a wide range of Dbms.
Ease of data manipulation.
Managing a great number of different Db-connections.
Work with big queries.
Cons
Support for troubleshooting on a Dbms level.
Automatically suggest syntax differences with different Dbms.
Sharing of Db connections.
Startup time.
Likelihood to Recommend
DbVis is our tool of choice when we need to work with a wide variety of Db vendors and versions. It allows us to replace several proprietary tools for accessing and, in part, managing database systems. It gives our customers and us a single base to work on databases. No need for us or them to install, learn, and pay for multiple solutions. If one would, for example, use ONLY one dbms, e.g., PostgreSQL, then DBVis could be a bit of an overkill.
VU
Verified User
Employee in Information Technology (Computer Software company, 1-10 employees)
As a software developer I build and support products with many different types of database connections. DbVisualizer gives me one coherent workspace to work with a wide variety of data sources that support SQL. And it runs in exactly the same way across different operating systems.
Pros
SQL intellisense
Exports to spreadsheets
Data editing in tables
Graphical table altering
Remote connections via SSH
Cons
Nothing
Likelihood to Recommend
If the colleague works with SQL I will recommend DbVisualizer anytime. For colleagues who are not comfortable working with SQL I am not so sure.
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.
