DBeaver is a

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

client software application and a

database administration Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use D ...

tool. For

relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...

s it uses the

JDBC Java Database Connectivity (JDBC) is an application programming interface (API) for the Java (programming language), Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java ...

application programming interface An application programming interface (API) is a connection between computers or between computer programs. It is a type of software Interface (computing), interface, offering a service to other pieces of software. A document or standard that des ...

(API) to interact with databases via a JDBC driver. For other databases (

NoSQL NoSQL (originally meaning "Not only SQL" or "non-relational") refers to a type of database design that stores and retrieves data differently from the traditional table-based structure of relational databases. Unlike relational databases, which ...

) it uses proprietary database drivers. It provides an editor that supports

code completion Code completion is an autocompletion feature in many integrated development environments (IDEs) that speeds up the process of coding applications by fixing common mistakes and suggesting lines of code. This usually happens through popups while typ ...

and

syntax highlighting Syntax highlighting is a feature of text editors that is used for programming language, programming, scripting language, scripting, or markup language, markup languages, such as HTML. The feature displays text, especially source code, in differe ...

. It provides a plug-in architecture (based on the

Eclipse An eclipse is an astronomical event which occurs when an astronomical object or spacecraft is temporarily obscured, by passing into the shadow of another body or by having another body pass between it and the viewer. This alignment of three ...

plugins architecture) that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. It is written in

Java Java is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea (a part of Pacific Ocean) to the north. With a population of 156.9 million people (including Madura) in mid 2024, proje ...

and based on the Eclipse platform. The community edition (CE) of DBeaver is a

free and open source software Free and open-source software (FOSS) is software available under a Software license, license that grants users the right to use, modify, and distribute the software modified or not to everyone free of charge. FOSS is an inclusive umbrella term ...

that is distributed under the

Apache License The Apache License is a permissive free software license written by the Apache Software Foundation (ASF). It allows users to use the software for any purpose, to distribute it, to modify it, and to distribute modified versions of the software ...

. A closed-source enterprise edition of DBeaver is distributed under a commercial license.

History

DBeaver was started in 2010 as a hobby project. It was supposed to be free and open-source with a good-looking and convenient UI and to include frequently used features for database developers. The first official release was in 2011 on Freecode. It quickly became a popular tool in the open-source community. In the same year, the official web site was founded and the community support forum (now moved to GitHub) was created. In 2012 an Eclipse plugin version was released - since then DBeaver has become one of the most popular database extensions for Eclipse (top 50-60 among all Eclipse extensions). Shortly after, various software vendors started to integrate with DBeaver (mostly as an extensions to their proprietary Eclipse RCP products: Zend Studio, NXTware, DeltaDNA, etc.). In 2014 the Enterprise Edition (EE) version was released. The EE version is based on CE but also provides support of NoSQL/ BigData databases (Cassandra,

MongoDB MongoDB is a source-available, cross-platform, document-oriented database program. Classified as a NoSQL database product, MongoDB uses JSON-like documents with optional database schema, schemas. Released in February 2009 by 10gen (now MongoDB ...

and

Redis Redis (; Remote Dictionary Server) is an in-memory key–value database, used as a distributed cache and message broker, with optional durability. Because it holds all data in memory and because of its design, Redis offers low- latency reads ...

) and includes a few additional Eclipse plugins. In 2015 the DBeaver source code/community moved to GitHub. In 2017 DBeaver CE was relicensed under

(starting from version 4.x). In July 2017 DBeaver EE version became commercial in order to support CE version.

Supported platforms and languages

DBeaver is a cross-platform tool and works on platforms which are supported by Eclipse (

Windows Windows is a Product lining, product line of Proprietary software, proprietary graphical user interface, graphical operating systems developed and marketed by Microsoft. It is grouped into families and subfamilies that cater to particular sec ...

Linux Linux ( ) is a family of open source Unix-like operating systems based on the Linux kernel, an kernel (operating system), operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically package manager, pac ...

macOS macOS, previously OS X and originally Mac OS X, is a Unix, Unix-based operating system developed and marketed by Apple Inc., Apple since 2001. It is the current operating system for Apple's Mac (computer), Mac computers. With ...

, Solaris), it is available in English, Chinese, Russian, Italian, and German.

Versions

Full list of all released versions

Community Edition

Community Edition (CE) is the initial version of DBeaver. It was released in 2010 and became open-source (GPL) in 2011. CE version includes extended support of the following databases: * TiDB *

MySQL MySQL () is an Open-source software, open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A rel ...

and

MariaDB MariaDB is a community-developed, commercially supported Fork (software development), fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Developm ...

PostgreSQL PostgreSQL ( ) also known as Postgres, is a free and open-source software, free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transaction processing, transactions ...

* Greenplum *

Oracle An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination. Descript ...

* IBM Db2 * Exasol * SQL Server * Mimer SQL *

Sybase Sybase, Inc. was an enterprise software and services company. The company produced software relating to relational databases, with facilities located in California and Massachusetts. Sybase was acquired by SAP in 2010; SAP ceased using the Syba ...

* Firebird *

Teradata Teradata Corporation is an American software company that provides cloud database and Analytics, analytics-related software, products, and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers a ...

* Vertica * SAP HANA * Apache Phoenix * Netezza *

Informix Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) and multi-model database offerings. The Informix products were originally developed by Inform ...

Apache Derby Apache Derby (previously distributed as IBM Cloudscape) is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 ...

* H2 * Salesforce Data Cloud * SQLite * SnappyData * Snowflake * Any other database which has

ODBC In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An ...

driver. Besides relational databases, CE version supports WMI driver (Windows Management Instrumentation – works only in Windows version).

Eclipse Plugin Edition

After a year, and in response to multiple user requests an

plugin version was released on Eclipse Marketplace. This version is used by programmers who use the Eclipse IDE for software development and need a

database management In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and ana ...

tool right in their IDE. The Eclipse plugin includes most features of Community Edition and is also released under

GPL license The GNU General Public Licenses (GNU GPL or simply GPL) are a series of widely used free software licenses, or ''copyleft'' licenses, that guarantee end users the freedom to run, study, share, or modify the software. The GPL was the first ...

Enterprise Edition

DBeaver 3.x announced support of NoSQL databases (Cassandra and MongoDB in the initial version). Since then DBeaver was divided on Community and Enterprise editions. Enterprise Edition has support of NoSQL databases, persistent query manager and a few other enterprise-level features. The EE version is not open-source and requires the purchase of a license (a trial license can be generated free of charge). List of additional features: *

Cassandra Cassandra or Kassandra (; , , sometimes referred to as Alexandra; ) in Greek mythology was a Trojan priestess dedicated to the god Apollo and fated by him to utter true prophecy, prophecies but never to be believed. In modern usage her name is e ...

* Persistent QM *

JSON JSON (JavaScript Object Notation, pronounced or ) is an open standard file format and electronic data interchange, data interchange format that uses Human-readable medium and data, human-readable text to store and transmit data objects consi ...

documents editor (mostly for MongoDB) * Eclipse EE features (resources management, Marketplace UI)

Features

DBeaver features include: *

queries execution * Data browser/editor with a huge number of features * Syntax highlighting and SQL auto-completion * Database structure (

metadata Metadata (or metainformation) is "data that provides information about other data", but not the content of the data itself, such as the text of a message or the image itself. There are many distinct types of metadata, including: * Descriptive ...

) browse and edit * SQL scripts management * DDL generation * ERD (Entity Relationship Diagrams) rendering * SSH tunnelling * SSL support (MySQL and PostgreSQL) * Data export/migration * Import, export and backup of data (MySQL and PostgreSQL) * Mock data generation for database testing There are differences in the features available across different databases.

References

External links

* {{MySQL Data modeling tools Database administration tools Eclipse (software) Java platform software IBM DB2 Microsoft database software MySQL MariaDB Oracle database tools PostgreSQL Software using the Apache license