About Team Edition

Team Edition is a comprehensive solution for team collaboration and efficient data management. It combines the full functionality of DBeaver Ultimate and CloudBeaver Enterprise, offering both desktop and web access for a seamless experience. Built for teamwork, it simplifies workflows and centralizes resource management, making collaboration easy in multi-user environments.

Out-of-the-box Team Edition offers:

• All-in-one data management for teams
• Secure server installation for private data management
• Multiple deployment options
• Web and desktop accessibility
• Support for a wide range of databases
• Flexible user access control with third-party integration
• Multi-user collaboration with synchronized workflows

• Rich set of tools for database management and analytics

Table of contents

• Getting started

  • Introduction to Team Edition

  • Web client

    • First steps and basics
    • How to import license
    • Application window overview

  • Desktop client

    • First steps
    • Installation guide
    • Basic operations
    • Application window overview
  • Architecture
  • Security in Team Edition

• Deployment

  • Deployment options

    • Docker Compose
    • Kubernetes
    • AWS AMI
    • AWS ECS
    • GCP Image
    • Azure image
  • Managing DBeaver Team Edition server

• Server configuration

  • Server configuration
  • Initial server configuration
  • How to migrate to Team edition
  • Domain manager
  • Server administration
  • Server management
  • Pre configured permissions for connections
  • Query manager database configuration

  • Product configuration parameters

    • Authentication
    • Database Navigator
    • Data Editor
    • Data Export
    • ERD
    • Connections

• Administration

  • Access Management

    • User creation
    • Users Provisioning
    • Password policy
    • Teams
    • Projects
    • Roles
      • Role management
    • User credentials storage

  • Authentication methods

    • Local Access Authentication
    • Reverse proxy header authentication
    • LDAP
    • Single Sign On
    • SAML
    • OpenID
    • AWS OpenID
    • AWS SAML
    • AWS IAM
    • AWS OpenId via Okta
    • Snowflake SSO
    • Okta OpenId
    • Cognito OpenId
    • JWT authentication
    • Kerberos-Authentication
    • NTLM
    • Microsoft Entra ID authentication
    • Google authentication

  • API

    • Server API explorer
    • API token generation

  • Admin preferences and tools

    • For Desktop

      • Admin manage preferences
      • Admin manage drivers
      • Admin preference restrictions
      • Admin variables
      • Command line
      • Session manager

      • Troubleshooting

        • Error Log
        • Background Tasks
        • Making a thread dump
        • Posting issues
        • How to set a variable if dbeaver.ini is read only
        • Log Viewer

      • License administration

        • How to reassign license
        • Differences between license types
      • Windows Silent Install
      • Statistics collection
      • Release cycles
      • Technical support information

    • For Web

      • Query Manager
      • Query History
      • Session Manager

• Web user guide

  • Supported databases

  • Configure connections

    • Create Connection

    • Network configuration settings

      • SSH configuration
      • SSL configuration
    • Connection Templates Management
    • Drivers Management

    • Cloud databases configuration

      • Cloud Explorer
      • Cloud storage
      • AWS Settings
      • Azure Permissions

  • Database navigator

    • Toolbar
    • Settings menu
    • Folders
    • Simple and Advanced View

  • Editors

    • Data editor

      • Data Filters
      • Data Ordering
      • Value Panel
      • Grouping Panel
      • Managing Charts
      • Result details panel

      • Advanced data types

        • JSON and Document View
        • Working with Spatial Geographic Information System (GIS) data

    • SQL Editor

      • SQL Formatting
      • Query Execution Plan
      • Visual Query Builder

      • AI Assistance

        • AI Smart Assistance
        • AI Smart-completion
        • AI Commands
        • AI Assistance settings
      • Auto and Manual commit modes
      • Client Side Commands

    • Data import and export

      • Data export
      • Data import
    • Datasets
    • Resource Manager
    • Entity Diagrams

  • User interface

    • Accessibility
    • Local Preferences
    • Keyboard shortcuts

  • Integrated tools

    • Git integration

• Desktop user guide

  • Configure connection

    • Guide to creating database connections
    • Disconnecting from database
    • Editing database connection
    • Invalidating and reconnecting to database
    • Local client configuration
    • Connection types
    • Multiple datasource connections
    • Configure connection initialization settings

    • Network configuration settings

      • SSH configuration
      • SSL configuration
      • Proxy configuration
      • Kubernetes configuration
      • AWS SSM configuration
      • DBeaver Database Tunnel

    • System operations and security

      • Shell commands
      • Changing current user password

    • Databases authentication models

      • Authentication models overview
      • Database native
      • DBeaver profile
      • Kerberos authentication
      • Microsoft Entra ID
      • Authentication MongoDB
      • PostgreSQL Pgpass
      • PostgreSQL SSPI (Windows SSO)
      • Oracle authentication models
      • Authentication Salesforce
      • Mysql two-factor authentication

    • Cloud databases configuration

      • Cloud Explorer tools

        • Cloud Explorer overview
        • AWS Cloud Explorer
        • Azure Cloud Explorer
        • Google Cloud Explorer
      • Cloud Storage

      • Cloud settings

        • AWS Permissions
        • Azure Permissions
        • Working with AWS SSO
        • Working with Google Cloud Explorer SSO
        • AWS credentials
        • Google Cloud Explorer credentials

    • Driver settings

      • Database drivers
      • File based driver properties
      • How to add additional artifacts to the driver
      • ODBC JDBC driver
      • JDBC time zones
      • JDBC tracing

  • Databases support

    • Classic

      • Apache Hive
      • Cassandra
      • ClickHouse
      • Couchbase
      • Database driver IBM Db2
      • Greenplum
      • InfluxDB
      • Microsoft SQL Server
      • MongoDB
        • MongoDB authentication
      • MySQL
        • Mysql two-factor authentication
      • Netezza
      • Oracle
        • Oracle authentication models
      • PostgreSQL
        • Arrays
        • Extensions
        • Pgpass authentication
        • SSPI authentication (Windows SSO)
      • Redis
      • Salesforce
        • Salesforce authentication
      • Teradata

    • Cloud

      • AWS
        • Athena
        • DocumentDB
        • DynamoDB
        • Keyspaces
        • Neptune
        • Redshift
        • Timestream
      • Azure
        • CosmosDB
        • Databricks
      • Google
        • AlloyDB for PostgreSQL
        • BigQuery
        • Bigtable
        • Cloud SQL for MySQL
        • Cloud SQL for PostgreSQL
        • Cloud SQL for SQL Server
        • Firestore
        • Spanner
      • Snowflake

    • Embedded

      • SQLite

    • File drivers

      • CSV
      • JSON
      • Multi Source
      • Parquet
      • XLSX
      • XML

  • Database Navigator panel

    • Database Navigator overview
    • Simple and advanced View
    • Configuring Filters
    • Filter Database objects
    • Bookmarks

  • Projects workspace

    • Projects View
    • Project Explorer

  • Editors

    • Editors overview

    • Data Editor tools

      • Data Editor overview

      • Viewing and editing data

        • Data View and Format
        • Data Filters
        • Data viewing and editing
        • Data refresh
        • Navigation

      • Data operations

        • Managing Panels
        • Managing Data formats
        • Managing Charts

      • Advanced data types

        • Working with Spatial Geographic Information System (GIS) data
          • GIS examples
        • Working with XML and JSON
        • Virtual column expressions
        • Virtual keys
      • Mock Data generation

    • SQL Editor tools

      • SQL Editor overview

      • Query execution and management tools

        • SQL Execution
        • Script management

      • Query development and assistance tools

        • SQL Assist and Auto Complete
        • SQL templates
        • Visual Query builder
        • SQL Formatting
        • Variables panel
        • Spelling
      • SQL Terminal

      • AI Assistance

        • AI Smart Assistance
        • AI Smart-completion
        • AI Chat
        • AI Commands
        • AI Assistance settings
        • Disable AI assistance
      • Client side scripting
        • Export Command

    • Entity Relation Diagrams

      • ER Diagrams overview
      • Database Structure ER Diagrams
      • Custom ER diagrams
      • Edit mode for ER Diagrams
    • Properties Editor
    • SQL Code Editor
    • Dashboards

    • Work with transactions in DBeaver

      • Transaction log
      • Pending Transactions
      • Auto and manual commit modes
    • Query Manager

  • Data import/export and operations

    • Data transfer
      • Data import
        • Data import and replace
      • Data export
        • Data transfer external storage
      • Data migration
    • Data transfer via email
    • Data compare
    • Backup and restore

  • Schema compare

    • Schema compare overview
    • Using Liquibase in DBeaver

  • Search

    • Search overview
    • Data Search
    • Database full text Search
    • Database metadata Search
    • File Search

  • Tasks

    • Task management
    • Task Scheduler
    • Composite Tasks

  • Integrated tools

    • Tableau integration

    • User interface

      • Accessibility
      • User interface themes
      • UI language
      • Toolbar customization
      • Views
      • Workspace location
    • Keyboard shortcuts
    • Certificate management
    • Configuration files

  • Tutorials

    • New table creation
      • Incorporating triggers
      • Creating columns
      • Creating Indexes
      • Implementing constraints
      • Utilizing foreign keys
    • How to work with database Partitions