DbVisualizer
DbVisualizer
10.0.22

4.7

DbVisualizer free download for Mac

DbVisualizer

10.0.22
19 August 2019

Cross-platform database visualization and management tool.

Overview

DbVisualizer is a feature-rich, intuitive, cross-platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections; it lets you explore and manage database objects, execute SQL queries, visualize information, and a lot more. Free of charge for commercial and non-commercial use. This edition provides basic level features useful for most users.

DbVisualizer comes in Free and Pro editions. You can find the differences here . The price quoted in the listing is the starting price for the Pro edition.

What's new in DbVisualizer

Version 10.0.22:
Improvements:
  • DB Support: DB2 LUW / DB Support: Oracle / SQL Commander: Add control to automatically clear the DBMS Output buffer between executions
  • DB Support: Informix: Add "Grants" viewer for Views, System Tables and Procedures
  • DB Support: PostgreSQL: Import Add support in Import Table Data for types such as JSON, MACADDR, MONEY, and others
  • DB Support: Redshift: Upgrade the Redshift JDBC Driver to 1.2.32.1056
  • DB Support: Redshift / Procedure Editor: Add support for Stored Procedures in Redshift
  • DB Support: SQL Server / SQL Commander: Support Error Line Numbers for Official MSSQL JDBC Driver
  • Grid Component: Need setting to disable wildcard detection in the grid quick search popup
  • Grid Component / SQL Editor: Show an error if system clipboard is not available during copy
  • SQL Commander: Support "GO " which runs the previous statement times
Export / Import:
  • Add "Detect Data Types in Quoted Values" setting in table data import
  • CSV Column Delimiter settings should accept non-printable characters and Unicode identifier (ex: u2656)
  • Add "Quote All Values" when export table data
Bugs Fixed:
  • Compare: Occasional error when comparing two editor buffers
  • Connection Setup: The "HIT" JDBC driver may fail at connect with a NullPointerException
  • DB Support: Hive: The "Create Index" action for Hive generates wrong SQL
  • DB Support: Oracle / SQL Commander: Output generated by DBMS_OUTPUT may not include leading/trailing whitespaces that are part of the output
  • DB Support: SQL Server: Running an empty argument list function returning TABLE results in an exception
  • DB Support: SQL Server / Database Profile: Actions The SQL when creating an "Inline Table Function" in SQL Server is incorrect
  • DB Support: SQLite: DDL Generator DDL extracting doesn't work properly if original DDL contains comments
  • Export: Any custom set Column or Row Delimiter in Export Schema/Table is reset to first value in the pre-defined delimiters list
  • Import: Occasional error during import. File Data Type is reset when going forth and back in the Import Table Data wizard
  • Query Builder: NullPointerException when Query Builder draws arcs between table nodes
  • SQL Commander: Error when using @run preceded with a @cd to a location specified by user variable
  • Tool Properties: ClassCastException when getting JDBC default fetch size

5 DbVisualizer Reviews

Rate this app:

barefeettom
12 March 2008

Most helpful

DB Visualizer seems to be the most full featured SQL GUI tool out there. It has some data entry aids that really make it viable, such as automatic form view (on record per screen), adjustable grid views and filters for everything from table listing to rows of data. Some of the tools and options aren't immediately obvious but very impressive once you find them. It's a Java app which limits a lot of Mac OS X integration (eg all the windows move in Spaces together) and some controls (such as tabbed panes) don't work in the standard Mac way. It's "Mac Look and Feel" setting makes DbVisualizer more palatable than most Java apps, but it's still a bit ugly and non-intuitive for Mac users. DbVisualizer, uses JBDC drivers to connect to the database. That takes a bit of fiddling which would scare off most users. I've tried two available JDBC drivers with SQLite (the most prolific database on the Mac) and only get limited functionality. For instance, I can't get DbVisualizer to show me the source of a selected table or view, I can't see triggers in the list. Every time I make changes to data, DbVisualizer complains that "no rows were affected by this edit", but the changes were actually made. Overall it's a great program that I can't yet use until SQLite access is fixed.
Like (1)
Version 6.0.8
jmrx
10 September 2013
I've been using DbVisualizer since 2006 and have been a happy customer ever since. Updates appear on a regular basis and customer support is quick and helpful. Yes, the program is written in Java and it does not look 100% native. But still it looks and feels great. I have seen native Cocoa Apps which feel sluggish and unpolished in comparison. The SQL editor is fast and comes with syntax highlighting, auto-completion and all sorts of (configurable!) keyboard shortcuts. It is lacking a vi-mode though. What makes DbVisualizer really shine is its graphing feature. Similar products can create visualizations of a database schema as well, but only DbVisualizer produces a layout that does not look like a knot of spaghetti. DbVisualizer is an excellent product for a very reasonable price.
Like
Version 9.1
Bobthevisitor
05 March 2013
This is a really professional tool to query every possible database accessible by JDBC. I use it daily and professionally and albeit the UI is not Mac-like (Java) it's power features are hard to find anywhere else. Import and Export is highy configurable, syntax highlighting and completion as you would expect. I use it mainly for Informix, Oracle and MySQL Databases without any problems so far (started with version 7 and currently 8) - I highly recommend taking a look at it. Well worth the money if you are a pro.
Like
Version 9.0.5
Mutant
15 February 2010
Draconian install, very un-userfriendly. First thing that pops up is a "buy me" dialog. It's listed as free, so I assume it's for support only. SQLite access didn't work. mysql over ssh worked fine, would be nice to have a httptunnel, but I won't complain. postgresql worked, MSSql seemed to work fine. In all however, I didn't see the use in this over a dedicated tool like phpMyAdmin, Mysql studio, or MSSQL Studio. This brought nothing more to the table than an interface to type in sql commands and view data. No typeahead hints, no autotable completion, nothing special in any way. I suppose it's a decent way to keep all your databases in one spot, but without even an SSH tunnel manager, it's more work to create the connections than to manage the tool.
Like (1)
Version 7.0.2
3 answer(s)
Rogerbj
Rogerbj
29 May 2012
Can you please tell where this "buy me" dialog pops up? SSH is built-in and no external tunneling is needed. Auto completion has been supported since version 4. DbVisualizer is available in two editions the "Free" and the commercial "Personal" edition. Some of the features you mention are available only in the commercial edition which is a quite common setup.
Like
Mutant
Mutant
29 May 2012
Wow.. I wrote that 2 years ago. I'm sorry I can't recall the specifics.
Like
Rogerbj
Rogerbj
29 May 2012
No problem :-) Just browsed the comments and thought it would be a good idea replying.
Like
barefeettom
19 April 2008
Here's a detailed comparison of DbVisualizer with alternative SQLite GUI programs: http://www.tandb.com.au/sqlite/compare/
Like
Version 6.0.10
barefeettom
12 March 2008
DB Visualizer seems to be the most full featured SQL GUI tool out there. It has some data entry aids that really make it viable, such as automatic form view (on record per screen), adjustable grid views and filters for everything from table listing to rows of data. Some of the tools and options aren't immediately obvious but very impressive once you find them. It's a Java app which limits a lot of Mac OS X integration (eg all the windows move in Spaces together) and some controls (such as tabbed panes) don't work in the standard Mac way. It's "Mac Look and Feel" setting makes DbVisualizer more palatable than most Java apps, but it's still a bit ugly and non-intuitive for Mac users. DbVisualizer, uses JBDC drivers to connect to the database. That takes a bit of fiddling which would scare off most users. I've tried two available JDBC drivers with SQLite (the most prolific database on the Mac) and only get limited functionality. For instance, I can't get DbVisualizer to show me the source of a selected table or view, I can't see triggers in the list. Every time I make changes to data, DbVisualizer complains that "no rows were affected by this edit", but the changes were actually made. Overall it's a great program that I can't yet use until SQLite access is fixed.
Like (1)
Version 6.0.8
$197.00

4.7

App requirements: 
  • Intel 64
  • Mac OS X 10.7.3 or later
Category: 
Developer Website: 
Download(100.5 MB)MacUpdateInstall with MacUpdate

Downloaded & Installed 26,483 times