Skip to content

Team Edition overview

DBeaver Team Edition has two client applications that work with a required central Team Edition server deployment:

  • Web client: Runs in a browser and supports database work, initial setup, and centralized administration.
  • Desktop client: Is installed locally for advanced database work. An administrator must enable desktop connections on the server before users can use it.

You can use Team Edition in a web-only configuration, or use both the web and desktop clients when desktop connections are enabled. In both configurations, the central server manages shared resources and access.

Info

For information on the server, clients, and database connection paths, see Team Edition architecture.

Team Edition includes:

  • 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.

Info

For deployment details, see Team Edition deployment.

Team Edition features

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. Learn more

  • Cloud management:

    • Cloud Explorer: Manages and connects to cloud-hosted databases. Available in both web and desktop clients.
    • Cloud Storage: Manages files within cloud environments, supported across web and desktop clients.

Web and desktop client 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 Connections. 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:

    • Visual Query Builder (VQB): Provides a graphical interface to construct SQL queries without writing code. 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

Tip

Administrators can allow or restrict desktop client connections in Settings -> Administration -> Server configuration -> Enable desktop application. When disabled, users can work only in the web client.

Subscription model

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

Supported databases

For information on databases supported by the web and desktop clients, see Supported databases.