A robust and versatile database manager that comes in handy for DBAs who need to work with multiple tables, scripts, triggers and stored procedures.
- DBeaver
- Version :4.1.0 / 4.1.1 Early Access
- License :GPL
- OS :Windows All
- Publisher :Jkiss
DBeaver Description
DBeaver is a comprehensive and effective software solution geared towards developers and database administrators who need to manage and organize tables, triggers, views and stored procedures from multiple databases.
Irrespective of the database you choose to work with, here referring to MySQL, SQLite, PostgreSQL, Oracle, Microsoft SQL Server, IBM DB2 and Firebird, the application comes in handy for users who need to handle multiple connections, thus organizing and editing various database objects including indexes, user accounts and scripts.
An intuitive and user-friendly interface
Once you launch the application for the first time, it will automatically scan the entire computer and display the existing connections (if they are available).
In case you want to create a new connection, simply access the proper option, choose the database you are interested it, then set the login credentials (optionally, specify the ODBC drivers if they are required).
After that, DBeaver displays all of the identified databases and users for the current connection. A new tab, entitled Projects, will become available in the left panel of the program from where you can easily access the database object you want and view its data.
For instance, if you double click on a specific table, the right panel will display all the necessary information such as available columns, pre-defined constraints and foreign keys, references, triggers, indexes and the proper CREATE DDL statement (also known as Data definition language).
Practical SQL editor and query execution commands
Considering the main purpose for which it was designed for, DBeaver comes with a reliable SQL editor that allows you to quickly edit and execute queries and scripts. Additionally, you are able to load an existing SQL script, as well as validate or simply analyze the selected query.
As far as the query execution command is concerned, you can run the selected SQL query using the proper options available in the toolbar or pressing the ‘CTRL+Enter’ key combination.
A straightforward database solution
All in all, DBeaver comes packed with useful and easy to handle tools and editors that come in handy for users who need to manage multiple database connections, triggers, procedures and views, as well as execute SQL scripts, from simple to complex.