DBeaver TE Overview
DBeaver Team Edition is a feature-rich solution, combining the capabilities of CloudBeaver Enterprise and DBeaver Ultimate products. With both web and desktop clients, it’s built for medium-to-large teams needing collaborative database management with centralized control and advanced security.
Note: DBeaver Team Edition requires a server deployment.
Team Edition includes:
- Cross-platform accessibility: Team Edition includes both web and desktop clients.
- Collaboration: Multiple users can share database connections, queries, credentials, SQL scripts, and diagrams.
- Centralized management: A Team Edition server enables administrators to manage permissions, monitor activity, and audit interactions by controlling shared resources and user roles.
- User management: Integration with external user directories, such as Active Directory and Okta, allows seamless user provisioning and role-based access control.
- Flexible deployment: DBeaver Team Edition can be deployed on the client’s server within a private network for secure, on-premises use, or hosted in the cloud. For deployment details, see Team Edition deployment.
Many features in Team Edition are shared between the web and desktop clients, such as:
-
Data visualization:
- Data filtering and sorting: Provides tools to filter and sort data directly within the database interface.
- Functional panels: Enhances data manipulation by offering additional space in the Data Editor for managing complex data types, accessible via tabs in a dedicated panel.
-
Query development:
- SQL Editor: Provides code completion for easier writing, auto-formatting, spelling checks, and support for variables. Available for both web client and desktop client.
- AI assistant: Integrates an AI assistant to offer guidance and automation within the SQL Editor. Available for both web client and desktop client
-
Administrative tasks:
- Entity Relationship Diagrams: Supports reverse engineering of databases into entity-relationship diagrams. Offered in the web and desktop clients.
- Permission and user management: Manages database permissions and user accounts.
- Export and Import from files: Facilitates data export and import operations, supported in both the web (Data Export) and web (Data Import), as well as the desktop clients.
- Database authentication: Implements database authentication mechanisms to secure access.
- Git integration: Provides version control and change tracking, available across both the web and desktop clients.
-
Cloud management:
In addition to shared features, each web and desktop client offers its own unique capabilities:
The Team Edition web client includes specific capabilities:
-
Setup and configuration:
- Initial setup: Complete setup of Team Edition available exclusively in the web client. Learn more
- Server configuration: Includes identity provider settings for SSO and centralized access management
- Domain management: Allows setting up custom domains or using a provided default. Learn more
- Multiple projects: Supports viewing and organizing multiple projects within the Database Navigator. Learn more
-
User and role management:
- SSO setup: Enhances security with identity provider configuration for single sign-on. Learn more
- Role-based access: Controls user access with Editor and Viewer roles. Learn more
- User import: Supports importing users from third-party systems. Learn more
- Supervisor role: Enables elevated query privileges within the Query Manager. Learn more
- Session management: Allows logging users out from active sessions if login limits are exceeded
-
Database and query management:
- Direct server connections: Simplifies database access with direct server connections
- Query history: Stores a history of past SQL queries, with upcoming support for server-side deletion. Learn more
- Database search: Provides search functionality to locate databases by server address
-
Data and file handling:
- Collaborative dataset editing: Enables team-based data modifications directly within the web client. Learn more
- Cloud file editing: Allows users to edit files stored in Cloud Storage. Learn more
The Team Edition desktop client offers several unique capabilities:
-
Data visualization:
- Color coding and highlighting: Simplifies data analysis by color-coding and highlighting table rows and fields based on conditions. Learn more
- Tableau integration: Facilitates integration with Tableau for advanced data visualization and analysis. Learn more
-
Query development:
- Execution plan visualization: Provides detailed visualizations of SQL execution plans. Learn more
- Visual Query Builder (VQB): Provides a graphical interface to construct SQL queries without writing code. Learn more
- SQL debugger: Offers an SQL debugger specifically designed for PostgreSQL, aiding in query development and troubleshooting. Learn more
- AI Chat: Integrates an AI-driven chat assistant to provide real-time query support within the SQL editor. Learn more
-
Administrative tasks:
- Metadata editor: Enables the management and editing of database metadata
- Edit mode for ER-Diagrams: Offers functionalities for editing entity-relationship diagrams to aid in database design. Learn more
-
Administrative tools:
- Backup and Restore: Ensures data safety by offering functionalities for backing up and restoring databases. Learn more
- Analyze and vacuum: Optimizes database performance by analyzing and vacuuming database objects
- Permission and user management: Manages database permissions and user accounts
- Schema comparison: Provides tools for comparing database schemas within the same or across different databases. Learn more
- Data comparison: Offers tools for comparing data within or across different databases. Learn more
- Mock data generator: Provides tools for generating mock data, useful for testing and development. Learn more
-
Data migration:
- Direct transfer between databases: Allows efficient data migration between different databases or systems. Learn more
-
Automation:
- Task manager: A tool for managing and monitoring database tasks, enhancing productivity and organization. Learn more
- Task scheduler: Allows scheduling of database tasks, automating routine operations. Learn more
-
Kafka support: Provides integration with Apache Kafka
The Team Edition is offered as an annual subscription, which must be renewed to continue receiving updates and support.
Discover more about the DBeaver Team Edition and subscribe
The Team Edition web client supports a wide range of databases. For a full list, refer to Supported databases
The Team Edition desktop client 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.
| Database name | Available through Cloud Explorer |
|---|---|
| Altibase | - |
| Apache Arrow | - |
| Apache Calcite Avatica | - |
| Apache Kylin | - |
| Azure Databricks | - |
| Azure SQL Server | ✓ |
| Babelfish via TDS (beta) | - |
| CUBRID | - |
| Cache | - |
| ClickHouse | - |
| ClickHouse (Legacy) | - |
| CloudSQL - MySQL | ✓ |
| CloudSQL - PostgreSQL | ✓ |
| CloudSQL - SQL Server | ✓ |
| 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 | - |
| GaussDB | - |
| Google AlloyDB | ✓ |
| 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 | - |
| Netezza | - |
| NuoDB | - |
| ODBC | - |
| OceanBase | - |
| Ocient | - |
| OmniSci (formerly MapD) | - |
| OpenEdge | - |
| OpenSearch | - |
| Oracle | ✓ |
| Pervasive SQL | - |
| PostgreSQL | ✓ |
| PrestoDB | - |
| PrestoSQL | - |
| Raima | - |
| Redshift | ✓ |
| RisingWave | - |
| SAP ASE jConnect | - |
| SQL Server | ✓ |
| SQL Server (Old driver, jTDS) | - |
| SQLite | - |
| SQLite Crypt | - |
| SQream DB | - |
| Salesforce | - |
| Salesforce Data Cloud | - |
| SingleStore | - |
| Snowflake | - |
| StarRocks | - |
| Sybase jConnect | - |
| Sybase jTDS | - |
| Teradata | - |
| TiDB | - |
| Trino | - |
| Vertica | - |
| Virtuoso | - |
| Yellowbrick | - |
| YugabyteDB | - |
| Database name | Available through Cloud Explorer |
|---|---|
| Apache Drill | - |
| Apache Hive | - |
| Apache Ignite | - |
| Apache Kyuubi | - |
| Apache Phoenix | - |
| Apache Spark | - |
| Athena | ✓ |
| CSV | - |
| Cassandra | - |
| Cloudera Impala | - |
| CosmosDB (Cassandra) | ✓ |
| CosmosDB (MongoDB) | ✓ |
| CouchDB | - |
| Couchbase | - |
| Couchbase 5+ | - |
| DBF | - |
| DocumentDB | ✓ |
| DynamoDB | ✓ |
| Elasticsearch | - |
| Firestore | ✓ |
| Gemfire XD | - |
| Google BigQuery | ✓ |
| Google Cloud Bigtable | ✓ |
| InfluxDB | - |
| InfluxDB 2 | - |
| InfluxDB 3 | - |
| Kafka (ksqlDB) | - |
| Keyspaces | ✓ |
| Machbase | - |
| MongoDB | - |
| Neo4j | - |
| Neptune | ✓ |
| Open Distro Elasticsearch | - |
| OrientDB | - |
| Redis | - |
| ScyllaDB | - |
| SnappyData | - |
| Solr | - |
| TDengine | - |
| TDengine Cloud | - |
| TimescaleDB | - |
| Timestream | ✓ |
| Yugabyte CQL | - |
- Application overview
- Demo Server
- Administration
- Supported databases
- Accessibility
- Keyboard shortcuts
- Features
- Server configuration
- CloudBeaver and Nginx
-
Domain manager
- Configuring HTTPS for Jetty server
- Product configuration parameters
- Command line parameters
- Local Preferences
-
Team Edition Overview
-
Getting started with Team Edition
-
Team Edition Server Configuration
-
Projects in Team Edition
-
Teams in Team Edition
- Team Edition Deployment
-
Roles in Team Edition
-
Git integration in Team Edition
-
Datasets in Team Edition
-
CloudBeaver Community
-
CloudBeaver AWS
-
CloudBeaver Enterprise
-
Deployment options
-
Development