Lite Edition
Table of contents
Overview
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 |
CUBRID | No | 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 |
JDBCX | 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 |
ODBC | No | Yes |
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 |