DBeaver Database Tool is an easy to use and reliable piece of software geared towards users who need to manage multiple SQL databases, execute SQL scripts, migrate connections and view diagrams.
When you launch DBeaver for the first time, you can choose a new connection type, then specify the information that allows you to connect to the selected database. After that
It is a free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc. Download DBeaver Database Tool For Windows PC.
It is a free and open-source universal database tool for developers and database administrators.
Main Features of DBeaver Database
Connection to various data sources
Choice of database driver from the variety of supported types. The list of drivers includes drivers for relational, document-oriented, key-value, time-series and other databases.
Support of user-defined connection types and creation of custom drivers an the Driver Manager
Configuration of standard (host, port, user credentials) as well as advanced connection properties:
Shell commands to be executed before/after actual database connection
Bootstrap SQL queries executing in the database session immediately after connecting
NoSQL / BigData databases
DBeaver Enterprise has special extensions for:
All these databases have SQL interface and you can work with them as with good old relational databases.
And this is not some kind of JDBC driver abstraction – DBeaver database supports all native data types and databases structure explorer for these databases.
It comes with all existing extensions, you don’t need to install anything else. This includes:
Office formats support
Vector graphics support
SQL debugging framework
Advanced SSH algorithms
Most popular database drivers are included in the distribution
A number of Eclipse extensions are included for advanced security and easy installation of 3rd party extension using Eclipse Marketplace
Data viewer and editor
Multiple data views to fit the variety of users’ needs, for example, display of image contents (gif, png, jpeg, BMP) as images
Editing of data inline and in a dedicated space
Convenient navigation among data
Custom filters for table contents or query results, including filters based on cell values
Results ordering by column
Data export with all applied filters and orderings
Generation of SQL statements based on selected rows
Basic statistics for selected columns
You can generate random data (or “mock” data) for tables. And this data should look like the real data.
Enterprise edition includes basic and advanced data generators. Including:
Domains and IP addresses
Custom regular expressions
Flexible numeric generators
Organization of scripts into folders and reassignment of database connections for particular scripts
SQL syntax highlighting determined by the database associated with a script
Support for different sets of reserved keywords and system functions for different databases
Import and export of scripts
Visual Query Builder
You may construct complex SQL queries without actual knowledge of SQL
Make table joins/filtering/ordering visually
Open your existing SQL queries in visual mode, edit and save them – that’s easy
Execute your visually constructed query at any moment and get results on the screen
Analyze complex SQL queries visually
A tree of database connections with their metadata structures down to the lowest level: tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions), and security entities (users, roles)
Ability to modify most metadata entities, depending on the database driver capabilities
Display of database objects` DDL and generation of standard SQL92 DDL according to object structure for some databases
Ability to edit/rename/delete connections and most database objects
Global and local filters, ability to filter database objects by name
Export of data to a file or to another database table with the option to create the destination table if it does not exist
There is a set of plugins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis, InfluxDB in version 5.x) and different database management utilities (e.g. ERD, data transfer, compare, data export/import, mock data generation, etc).
Create an object menu was improved (no redundant sub-menu)
Connection folders creation was fixed
Elements coloring was improved (for different connection types)
Shortcuts processing was fixed (broken shortcuts after some actions)
Table editor tabs activation was fixed
Columns Editor: auto-completion was fixed in drop-downs.
Data transfer: export from multiple queries was fixed (target file names)
SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
Spatial data editor:
Geography/geometry value editor (plaintext, WKT)
Numerous fixes in different SRIDs support
Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
Multiple query result sets support was added
Table partitions information was extended
Native database backup was fixed
Database creation was fixed (special characters in db name)
Sequence rename was fixed
Full schema DDL generation was fixed
Greenplum, Redshift: execution plan explain now supports plaintext format
SQLite: sample database was updated
Sybase (12 and older): stored procedures source reading was fixed
Apache Ignite: identifiers quoting was fixed
DB2 iSeries: schema reading was fixed
Extra command line parameters (connection opening)
Connections import from SQL Developer was fixed
Windows installer: config files (dbeaver.ini) backup
Extensions (Office, SVG, etc) installer was fixed
Checking for multiple DBeaver instances was added
Windows XP, Windows Vista, Windows 7, Windows 8, Windows 10
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. Download DBeaver Software For Linux.