DBeaver Documentation

DOWNLOAD pdf

Lite Edition

Overview

DBeaver Lite Edition is tailored for users who need basic tools to work with databases. This version offers a streamlined interface that focuses on simple database tasks like viewing data and running queries. It is especially useful for business users who need an easy-to-use tool.

Note: The DBeaver Lite Edition is designed for individual use only.

Lite Edition features

Key features included in the Lite Edition are designed to support everyday database tasks with minimal hassle:

  • Data Visualization

    • Color coding and highlighting: Simplifies data analysis by color-coding and highlighting table rows and fields based on conditions. Learn more.
    • Data filtering and sorting: Provides tools to filter and sort data directly within the database interface. Learn more.
    • Analytical charts: Offers tool for creating analytical charts to represent data visually. Learn more.
    • Entity relationship diagrams: Visualize database schemas through entity-relationship diagrams. Learn more.
  • Data import/export

    • Office formats support (XLS): Enables users to import and export data in Office formats, specifically Excel (XLS). 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.
    • Visual query builder: Provides a graphical interface to construct SQL queries without writing code. Learn more.
  • Comprehensive security support: Ensures secure access to databases within your environment, even if they are protected by Single Sign-On (SSO), Kerberos, SSL, and other security measures.

Subscription model

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

Discover more about the DBeaver Lite Edition and subscribe.

Integrated database drivers

The Lite Edition has a comprehensive set of JDBC drivers, offering connectivity to various databases without needing separate downloads and configurations. Additionally, a versatile ODBC driver is supported for broader database compatibility.

For additional details on utilizing the ODBC driver, please consult the ODBC-JDBC driver article.

Supported databases

The Lite Edition provides support for a wide range of databases. Below are tables listing the databases available and specifying whether the Lite Edition offers enhanced features compared to the Community Edition.

* Enhanced features may include additional metadata capabilities, such as the ability to manage and interact with specific database objects unique to certain systems. For instance, managing Roles** in Redshift. These features also cover various advanced authentication methods, and numerous other functionalities designed to improve security and data management.

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