DBeaver Documentation


Lite Edition


DBeaver Lite Edition offers a simplified version of DBeaver, tailored for users who need essential database management features. It includes key functionalities that are straightforward and easy to use, concentrating on the core aspects of database management.

The Lite Edition does not include certain advanced features such as Task Scheduler, Data Migration, Backup Tools, and Mock Data Generation. This makes the Lite Edition an ideal choice for users seeking a streamlined tool that covers the fundamental requirements of database management. By selecting the Lite Edition, users can utilize a lighter version of DBeaver that is still effective for efficient database management.

Integrated database drivers

Lite Edition includes a comprehensive set of JDBC drivers and support for a versatile ODBC driver, offering seamless connectivity to a wide range of databases without the need for separate downloads and configurations. For additional details on utilizing the ODBC driver, please consult the ODBC-JDBC Driver article.

Extended Lite Edition features

The Lite Edition enhances the functionalities of the Community edition by introducing a unique set of more advanced features:

  • Data import/export

    • Office formats support (XLS): Enables users to import and export data in Office formats, specifically Excel ( XLS). Learn more.
  • Data visualization

    • Entity relationship diagrams: Visualize database schemas through entity-relationship diagrams. Learn more.
    • Analytical charts: Offers tool for creating analytical charts to represent data visually. Learn more.
    • Visual query builder: Provides a graphical interface to construct SQL queries without writing code. Learn more.
    • SQL execution plan diagram: Helps understand and optimize SQL queries with execution plan diagrams. Learn more.
  • Query development

    • AI assistant in SQL Editor: Integrates an AI assistant and AI Chat to offer guidance and automation within the SQL Editor. Learn more.
    • Search in query history: Enables searching through previous queries for easier management and reuse.
    • Spelling: Provides spelling verification to improve the quality and accuracy of SQL scripts. Learn more.
  • Secure connection configurations

    • Kerberos: Offers a user interface for configuring Kerberos-based authentication for secure connections. Learn more.
    • Automatic Proxy configuration (PAC): Supports automatic configuration of proxy settings using PAC files for secure and efficient network connections. Learn more.

Subscription model

DBeaver Lite Edition is offered as an annual subscription, which can be renewed to continue receiving updates and support.

By opting for Lite Edition, users not only get access to advanced features but also contribute to the ongoing development and improvement of the DBeaver Community Edition.

Discover more about DBeaver Lite Edition and subscribe.

Supported databases

The Lite Edition provides support for a wide range of databases. The table below details these databases, indicating whether the driver is pre-downloaded and if enhanced features are supported in this edition compared to the Community Edition.

SQL Databases
Database name Pre-downloaded driver Enhanced features compared to the Community Edition
Altibase No No
Apache Arrow Yes No
Apache Calcite Avatica Yes Yes
Apache Kylin No No
Azure Databricks No Yes
Azure SQL Server Yes Yes
Babelfish via TDS (beta) Yes Yes
Cache Yes No
ClickHouse Yes No
ClickHouse (Legacy) Yes Yes
CloudSQL - MySQL Yes No
CloudSQL - PostgreSQL Yes Yes
CloudSQL - SQL Server Yes Yes
CockroachDB Yes No
CrateDB Yes No
CrateDB (Legacy) No No
Dameng Yes No
Data Virtuality Yes No
Db2 for IBM i Yes Yes
Db2 for LUW Yes No
Db2 for z/OS Yes Yes
Denodo 8 Yes No
Derby Embedded Yes No
Derby Server Yes No
Dremio Yes No
DuckDB Yes No
EDB Yes Yes
Exasol Yes Yes
Firebird Yes Yes
Fujitsu Enterprise Postgres Yes Yes
Google AlloyDB Yes No
Google Cloud Spanner Yes Yes
Greenplum Yes Yes
H2 Embedded Yes Yes
H2 Embedded V.2 Yes No
H2 Server Yes Yes
H2GIS Embedded Yes No
H2GIS Server Yes No
HANA Yes Yes
HSQL Embedded Yes No
HSQL Server Yes No
Informix Yes Yes
Ingres Yes No
InterSystems IRIS Yes No
Jennifer Yes No
Kognitio Yes No
MS Access (UCanAccess) Yes No
MariaDB Yes Yes
Materialize Yes No
MaxDB Yes No
Mimer SQL Yes No
MonetDB No No
MySQL Yes Yes
MySQL 5 (Legacy) Yes Yes
NDB Cluster Yes No
NetSuite No Yes
Netezza Yes Yes
NuoDB Yes No
OceanBase Yes No
Ocient Yes No
OmniSci (formerly MapD) No No
OpenEdge No No
OpenSearch Yes Yes
Oracle Yes Yes
Pervasive SQL No No
PostgreSQL Yes Yes
PrestoDB Yes No
PrestoSQL No No
Raima Yes No
Redshift Yes Yes
RisingWave Yes No
SAP ASE jConnect Yes No
SQL Server Yes Yes
SQL Server (Old driver, jTDS) Yes Yes
SQLite Yes Yes
SQLite Crypt Yes Yes
SQream DB No No
Salesforce No No
Salesforce CDP Yes No
SingleStore No Yes
Snowflake No Yes
StarRocks Yes No
Sybase jConnect Yes Yes
Sybase jTDS Yes Yes
Teradata Yes Yes
TiDB Yes No
Trino Yes No
Vertica Yes Yes
Virtuoso Yes No
Yellowbrick Yes No
YugabyteDB Yes No
Non-SQL databases
Database name Pre-downloaded driver Enhanced features compared to the Community Edition
Apache Drill Yes Yes
Apache Hive Yes Yes
Apache Ignite Yes No
Apache Kyuubi No No
Apache Phoenix Yes No
Apache Spark Yes No
Athena Yes Yes
CSV Yes No
Cassandra Yes Yes
Cloudera Impala No No
CosmosDB (Cassandra) No No
CosmosDB (MongoDB) Yes Yes
CouchDB Yes No
Couchbase Yes No
Couchbase 5+ Yes No
DBF Yes No
DocumentDB Yes No
Elasticsearch Yes Yes
Gemfire XD No No
Google BigQuery Yes No
InfluxDB Yes No
InfluxDB 2 Yes No
InfluxDB 3 Yes Yes
Keyspaces Yes No
Machbase Yes No
MongoDB Yes Yes
Neo4j Yes No
Neptune Yes No
Open Distro Elasticsearch No Yes
OrientDB Yes No
Redis Yes No
ScyllaDB No No
SnappyData No No
Solr No No
TDengine No Yes
TDengine Cloud No Yes
TimescaleDB Yes No
Timestream Yes No
Yugabyte CQL Yes No

Did we resolve your issue?