DbVisualizer is the ultimate solution since the same tool can be used on all major operating systems accessing a wide range of databases. Enjoy!
Amazon Redshift, DB2 LUW, Derby, Exasol, H2, Informix, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, NuoDB, Oracle, PostgreSQL, SQLite, Sybase ASE, and Vertica.
Db Visualizer 64 bit runs on all the major platforms, Windows, macOS, and Linux.
SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, and, a command-line based interface.
Tree based navigation through database objects. Multiple objects can be displayed side-by-side.
Visual tools to manage database objects. Edit, compile and, run procedures, functions, triggers, and, a lot more.
Table Data Management
Spreadsheet-like table data editor including binary/BLOB and CLOB data types, import from CSV and Excel files.
Export database objects and table data as CREATE/INSERT statements, CSV, XML and more. Support for exporting very large result
DbVisualizer is tested with the major databases and JDBC drivers. For databases more commonly used in the industry It has added support for database specific features. Key bindings are configurable and the appearance of the application is highly customizable. Some of these features are:
- Management of database specific objects
- Visual actions for CREATE, ALTER, DROP, RENAME and so on
- Create, Edit and Compile procedures, functions and triggers
- Explain plan support
- Schema Export
- Compare of editors and result sets
- …and much more
Note: 21 days trial version.
Also Available: Download DbVisualizer for Mac