DbVisualizer is the universal database tool for administrators, developers, and analysts. It runs on all major OSes and connects to all commercially viable database engines.
DbVisualizer is a feature rich, intuitive multi-database tool for developers, analysts and database administrators, providing a single powerful interface across a wide variety of operating systems. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
This all in one tool is the universal database tool for developers, DBAs and analysts. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.
With DBVisualizer, you will have many features at your disposal, including:
- Comprehensive database & OS support
- Database object management
- Table data management
- Export database objects and table data
Productivity, fast learning, and cost effectiveness
DbVisualizer improves productivity and decreases learning time. With one single tool even for large, heterogeneous environments and its modest pricing, it is also a highly cost effective solution. DbVisualizer runs on all major operating systems where Java is supported.
Visually create and manage the database
One of DbVisualizer’s strengths is visualizing the structure in the database, its database objects and most importantly, table data. Database objects are simple to create using powerful actions in DbVisualizer requiring no manual SQL to be written. Table data is easily managed using a powerful spreadsheet like editing feature.
Design, run, and test database queries without writing code
On-screen manipulations generate SQL statements that can be saved as scripts or copy-and-pasted into applications. This helps developers inexperienced with SQL to get started, and speeds up the process and reduces bugs for experienced database developers. Consequently, development costs decrease significantly when using DbVisualizer.
DbVisualizer is increasingly used by advanced analysts who want to sift thru vast databases and use ad-hoc queries to extract information and follow shifts in real time. Analysts get full access to the power of the database and can do practically anything that the database engine supports, through user friendly operations in DbVisualizer. This is part of the Big Data trend, but with uniquely low license fees, and customers can afford to enable entire departments with personal DbVisualizer licenses.
The architecture is simple, yet extremely well adapted to the scope of the product and the needs of its users. The entire code base is written in Java, which means that there is only one version of DbVisualizer for all platforms at any given time, and all features are released simultaneously regardless of operating system. Platform dependencies are handled entirely in the Java VM and DbVisualizer has a consistent behavior across OSes. The integration with various databases is managed thru standardized interfaces, JDBC and XML. Database-specific features are described in XML files, separate from the application code
Multi-database and cross-platform Database Management Tool
- Work with multiple database brands and perform many development and administration tasks from a single tool
- Easily explore your databases
- Automatic graphs of primary/foreign-key constraints
Visually create and manage the database
- Construct and manage database objects with ease
- Multiple object action execution
- Create, Compile and Run functions and procedures
- Object scripting
- Graphical object editors (create, drop, modify)
- Powerful data editing
Write and execute SQL scripts
- SQL IDE with syntax highlighting
- Auto completion
- Parameterized SQL execution
- Chart any result set in nice diagrams
- Tune your queries with integrated explain
- Query builder using drag and drop
- Visually compare SQL scripts Data and database transfer
- Export table data in CSV, SQL, HTML, XML, XLS/XLSX, JSON, Text
- Export all objects in the database including table data or all objects for a specific type
- Import table data from CSV and XLS/XLSX files
- Tasks are executed in background allowing for parallel operations
- Auto save of the workspace
- Resume where you left off with editors preserved between sessions
- Flexible workspace based on a tabbed interface supporting customized layout that is saved between sessions
- Tag DB objects and SQL script files as favorites for instant loads
- Includes a dark them, Darcula Security
- Access databases through SSH
- Strong Master Password security