Skip to content
DBeaver site logo DBeaver site logo
  • Products

    Desktop

    DBeaver Enterprise

    Data management and SQL development

    DBeaver Ultimate

    Work with data and SQL on-premise and in the cloud

    DBeaver Lite

    Data tables and SQL queries with a lightweight interface

    Web & hybrid

    CloudBeaver Enterprise

    Secure browser-based data management

    DBeaver Team Edition

    Advanced data collaboration with access control

    Choose your product

    Learn about DBeaver PRO options

    Compare products
  • Pricing

    Licenses

    Buy

    Purchase a license

    License types

    See all available licenses

    Academic licenses

    Free for students

    See DBeaver in action

    Connect with an expert

    Book a demo
  • Resources

    Learning & training

    • Blog
    • Supported databases
    • Integrations
    • Use cases

    For partners

    • Become a partner
    • Resellers
    • Technology partners
    • Universities

    About us

    • Careers
    • Company
    • Customers
    • Events

    Oracle AI World

    Come to our booth #5020

    Register now
  • Documentation

    Documentation

    DBeaver Desktop Products

    View documentation for DBeaver desktop products, on-premises database management tools with enterprise features and advanced automation.

    CloudBeaver Enterprise

    View documentation for CloudBeaver, a web-server application for distributed teams needing secure, browser-based access.

    DBeaver Team Edition

    View documentation for DBeaver Team Edition, a server-based database management platform for teams, deployable on-premises or in the cloud for collaboration.

  • Support
  • Get a trial
Your cart is empty.
Sign in Sign up
Sign in Sign up
  • DBeaver
  • CloudBeaver
  • Team Edition
DOWNLOAD PDF
Initializing search
    • Getting started
      • First steps
      • License management
      • Application overview
      • Architecture
      • Application window overview
      • Basic operations
        • Supported databases
          • Multi Source
          • CSV
          • JSON
          • Parquet
          • XLSX
          • XML
          • File-based driver properties
        • Create connection
        • Drivers management
          • Database native authentication
          • MongoDB authentication
          • Microsoft Entra ID authentication
          • Oracle wallet authentication
          • PostgreSQL pgpass authentication
          • Salesforce authentication
          • Kerberos authentication
          • SSH configuration
          • SSL configuration
        • Database navigator
        • Toolbar
        • Settings menu
        • Folders
        • Simple and advanced view
      • Properties editor
        • Data Editor
        • Data filters
        • Data ordering
        • Value panel
        • Grouping panel
        • Result details panel
        • Managing charts
        • JSON and document view
        • Spatial GIS data
        • Server output
        • Datasets
        • SQL Editor
        • SQL formatting
        • SQL assist and auto complete
        • Query execution plan
        • Visual query builder
        • Client-side commands
        • Auto/manual commit modes
        • Resource manager
      • Entity relation diagrams
        • Cloud Explorer
        • Cloud Storage
        • AWS settings
        • Azure permissions
        • AI smart assistance
        • AI Chat
        • AI commands
        • Explain query with AI
        • Describe object with AI
        • Explain SQL errors
        • AI assistance settings
      • DBeaver Database Tunnel
        • Data export
        • Data import
      • Database object editor
      • Accessibility guide
      • Keyboard shortcuts
      • Search
        • Version control
        • Lock manager
      • Installation
      • Application window overview
      • Basic operations
        • User Interface
        • Languages
        • Accessibility
        • Toolbar customization
        • Database Object Editor
        • Reset UI settings
        • Shortcuts
        • Configuration files
        • Pre configured variables
          • Create connection
          • Edit connection
          • Invalidate and reconnect
          • Disconnect from database
          • Change current user password
          • Shell commands
          • Initialization settings
          • Security restrictions for database connection
          • Connection types
          • Local client configuration
          • Multiple datasource connections
          • Network configuration
            • SSH configuration
              • SSL configuration
                • Manage certificates
                • Import custom certificates
              • Oracle SSL configuration
              • Proxy configuration
              • Proxy configuration with system files
            • Kubernetes configuration
            • AWS SSM configuration
          • Network profiles
          • Transaction log
          • Pending transactions
          • Auto and manual commit modes
          • Database native authentication
          • DBeaver profile authentication
          • Kerberos authentication
          • LDAP authentication in Teradata
          • Microsoft Entra ID authentication
          • MongoDB authentication
          • PostgreSQL pgpass authentication
          • PostgreSQL SSPI (Windows SSO) authentication
          • Oracle authentication
          • Salesforce authentication
          • MySQL two-factor authentication
          • Snowflake authentication
          • Driver manager
          • ODBC JDBC driver
          • File-based driver properties
          • How to add additional artifacts to the driver
          • JDBC time zones
          • JDBC tracing
        • Secret Management
          • Apache Hive
          • Cassandra
          • ClickHouse
          • Couchbase
          • IBM Db2
          • Greenplum
          • InfluxDB
          • Microsoft SQL Server
          • MariaDB
          • MongoDB
          • MySQL
          • Netezza
          • Oracle
          • PostgreSQL
          • Redis
          • Salesforce
          • Teradata
          • Trino
          • Yellowbrick
            • Athena
            • DocumentDB
            • DynamoDB
            • Keyspaces
            • Neptune
            • Redshift
            • Timestream
            • CosmosDB
            • Databricks
            • AlloyDB for PostgreSQL
            • BigQuery
            • Bigtable
            • Cloud SQL for MySQL
            • Cloud SQL for PostgreSQL
            • Cloud SQL for SQL Server
            • Firestore
            • Spanner
          • Snowflake
          • SQLite
          • Multi source
          • CSV
          • JSON
          • Parquet
          • XLSX
          • XML
          • Neo4j
          • Database navigator
          • Simple and advanced view
          • Configuring filters
          • Filter database objects
          • Bookmarks
          • Projects view
          • Project explorer
          • Search
          • Data search
          • Database full text search
          • Database metadata search
          • File search
          • Cloud explorer
          • AWS cloud explorer
          • Azure cloud explorer
          • Google cloud explorer
        • Cloud storage
            • AWS permissions
            • AWS SSO
            • AWS credentials
            • Azure permissions
            • Google Cloud SSO
            • Google Cloud credentials
      • Properties Editor
        • Data Editor
          • Data view and format
          • Data filters
          • Data viewing and editing
          • Data refresh
          • Result set navigation
          • Panels
          • Managing charts
          • Mock data
          • Dashboards
        • Working with XML and JSON
        • Spatial geographic information system (GIS) data
          • Virtual columns
          • Virtual keys
          • Data Editor preferences
          • Data format preferences
        • SQL Editor
        • Visual query builder
          • SQL execution
          • Script management
          • SQL assist and auto complete
          • SQL templates
          • SQL formatting
          • Variables panel
          • Spelling
        • SQL generation
        • SQL terminal
          • Client side scripting
          • Export command
        • Query manager
        • SQL code Editor
        • SQL Plus script execution
        • PostgreSQL Arrays
        • PostgreSQL Extensions
        • AI assistance
        • AI chat
        • AI speech recognition
        • AI command
        • Query suggestion
        • Explain query using AI
        • Smart metadata description
        • Explain SQL errors
        • AI assistance settings
        • Disable AI assistance
        • ER Diagrams
        • Database structure diagrams
        • Custom diagrams
        • Edit mode for diagrams
          • 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
          • Using Liquibase in DBeaver
        • Task management
        • Task scheduler
        • Composite tasks
        • Version control
        • Tableau integration
        • Session Manager
        • Lock manager
          • New table creation
          • Incorporating triggers
          • Creating columns
          • Creating indexes
          • Implementing constraints
          • Utilizing foreign keys
        • Database partitions
        • Server configuration
        • Web server configuration
        • First launch guide
        • Domain manager
        • Managing Team Edition server
          • Product configuration parameters
          • Authentication settings
          • Navigation tree
          • Data spreadsheet
          • Data export
          • Entity Relationship Diagrams (ERD)
          • Connections settings
          • Query manager DB config
        • Server security and access configuration
          • Authentication methods
          • Local access authentication
          • Reverse proxy header authentication
          • LDAP authentication
          • Single sign-on (SSO)
          • SAML authentication
          • OpenID authentication
          • AWS OpenID authentication
          • AWS SAML database access via Okta
          • AWS IAM authentication
          • AWS OpenID database access via Okta
          • Snowflake OpenID database access via Okta
          • Okta OpenID authentication
          • Cognito OpenID authentication
          • JWT authentication
          • NTLM user authentication
          • Microsoft Entra ID authentication
          • Google authentication
          • Users
          • Provisioning users
          • Password policy
          • Teams
          • Projects
          • Roles
          • Role management
          • User credentials storage
          • Admin password recovery
        • Proxy configuration
        • Multiple Server URLs
        • Secret Management
        • Pre-configured permissions for connections
      • Migration from DBeaver Desktop
      • Local preferences
        • Manage preferences
        • Manage drivers
        • Preference restrictions
        • Variables
        • Command line
        • Session Manager
          • Background tasks
          • How to make a thread dump
          • How to post issues
          • How to set a variable if dbeaver.ini is read-only
          • Troubleshooting task scheduler issues
            • Log viewer
            • Log files
            • Log customization
          • How to reassign a license
          • Differences between license types
        • How to change Java security properties
        • Windows silent install
        • Statistics collection
        • Release cycles
        • Customer support info
        • Import CA certificates into DBeaver
          • Query manager
          • Query history
          • Query manager database
        • Session manager
          • Web client workspace location
          • Desktop client workspace location
      • Team Edition deployment overview
        • Deploy with Docker Compose
        • Deploy with AWS AMI
        • Deploy with GCP image
        • Deploy with Azure image
      • Managing Team Edition server
      • Managing cloud-deployed services
      • Overview
        • Overview
        • GraphQL API documentation
        • Generate API token
        • GraphQL console
        • Run GraphQL requests from CLI
        • GraphQL examples
        • Overview
        • Connect Tableau to a database using DBeaver Proxy Driver
      • Web Client
      • Desktop Client
    1. Team Edition
    2. Administration
    3. Server configuration
    4. Product configuration parameters
    Web client

    Entity Relationship Diagrams (ERD)

    Product configuration parameters

    This parameters only available in Enterprise and AWS products

    Variable ~~Deprecated~~ Value Description
    plugin.erd-viewer.maxColumnsToDisplay plugin_erd_viewer.maxColumnsToDisplay 15000 Sets the maximum displayed objects count
    DBeaver site footer logo
    • Facebook
    • LinkedIn
    • Telegram
    • Reddit
    • Twitter
    • YouTube
    • Products
      • DBeaver Lite
      • DBeaver Enterprise
      • DBeaver Ultimate
      • CloudBeaver Enterprise
      • Team Edition
      • Compare products
    • Download
      • DBeaver Lite
      • DBeaver Enterprise
      • DBeaver Ultimate
      • CloudBeaver Enterprise
      • Team Edition
    • Buy
      • Buy a license
      • License types
      • Try for free
      • Academic license
    • Resources
      • Supported databases
      • DBeaver integrations
      • Use cases
      • DBeaver blog
      • Video
      • Events
      • Contact support
    • Documentation
      • DBeaver
      • CloudBeaver
      • Team Edition
    • Partners
      • Become a sales partner
      • Resellers
      • Technology partners
      • Universities
    • Company
      • About us
      • Our customers
      • Contacts
      • Join our team
    • Legal
      • Privacy
      • Service Level Agreement
      • Enterprise Software Agreement
      • EULA