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.
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.
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.
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.
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.
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 |
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 |
-
Views
-
Search
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation