File Size: 65.6 MB
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.
Features:
Connection manager
Metadata browser
SQL Editor
Scripts
Execute queries
Working with SQL
Miscellaneous
Data viewer/editor
Data/metadata search
Database structure compare
Data transfer (export/import)
ER Diagrams
Query Manager
Projects
Extra views
Driver manager
Whats New:
Mock data generator extension release. UI changes, lots of bugfixes.
PostgreSQL debugger (beta version)
PostgreSQL: constraints DDL was fixed
PostgreSQL: PostGIS support was fixed (array of geometry type)
Vertica: UDF support (read-only)
Vertica: flex tables support (read-only)
Oracle: include comments in view DDL
Auto-reconnect after connection failure feature was added (configurable)
Auto-refresh for sessions and transaction lock views was added
SQL editor: auto-complete for JOIN was fixed/improved
Metadata search was fixed (NPE)
Results viewer: grid background colour shows cells state
Results viewer: column header render was fixed
Excel export: support of column descriptions in header
Settings for the page switch saving on the connection page were fixed
Keyboard shortcuts for the SQL editor opening were fixed
Entity editor save/revert changes actions were fixed (refresh contents)
Decimal part rendering is now configurable for the numeric data type
Command line handling (-con) was fixed (drivers search)
Fixes for the driver editor dialog were implemented: NPE fixes, show driver ID
Edit connection dialog was fixed (dialog layout glitch)
Dialog for errors was fixed - now default button is Stop
Numerous localization fixes
Many minor UI fixes
Homepage
https://dbeaver.jkiss.org/
