-
Notifications
You must be signed in to change notification settings - Fork 3.3k
Lite Edition
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.
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.
-
Office formats support (XLS): Enables users to import and export data in Office formats, specifically
Excel (
-
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.
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.
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.
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.
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 | - |
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 | - |
Data Virtuality | - |
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 |
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 | - |
Kognitio | - |
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 | ✓ |
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 | - |
Database name | Enhanced features* compared to the Community Edition |
---|---|
Apache Drill | ✓ |
Apache Hive | ✓ |
Apache Ignite | - |
Apache Kyuubi | - |
Apache Phoenix | - |
Apache Spark | - |
Athena | ✓ |
CSV | - |
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 |
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 | - |
Redis | Not available in Community Edition |
ScyllaDB | Not available in Community Edition |
SnappyData | - |
Solr | - |
TDengine | ✓ |
TDengine Cloud | ✓ |
TimescaleDB | - |
Timestream | Not available in Community Edition |
Yugabyte CQL | Not available in Community Edition |
-
Views
-
Search
-
Data management
-
Usability enhancements
-
Security
-
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