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

    CLI

    dbvr

    Running database operations in headless and terminal-first environments

    See DBeaver in action

    Connect with an expert

    Book a demo
  • Pricing

    Licenses

    Buy

    Purchase a license

    License types

    See all available licenses

    Academic licenses

    Free for students

    Choose your product

    Learn about DBeaver PRO options

    Compare products
  • Resources

    Learning & training

    • Blog
    • Supported databases
    • Integrations
    • Use cases

    For partners

    • Become a partner
    • Resellers
    • Technology partners
    • Universities

    About us

    • Careers
    • Company
    • Customers
    • Events
  • 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.

    dbvr

    View documentation for dbvr, a lightweight CLI to run database operations without a GUI.

  • Support
  • Get a trial
Sign in Sign up
Sign in Sign up
  • DBeaver
  • CloudBeaver
  • Team Edition
  • dbvr
    DOWNLOAD PDF
    Initializing search
      • Getting started
        • First steps
        • Application overview
        • Architecture
        • Application window overview
        • Basic operations
          • Create connection
            • SSH configuration
            • SSL configuration
            • Database username/password
            • MongoDB authentication
            • Microsoft Entra ID authentication
            • Oracle wallet authentication
            • Salesforce authentication
            • Kerberos authentication
            • Supported databases
              • PostgreSQL
              • PgPass authentication
              • Snowflake
              • Snowflake OAuth authentication
              • Multi Source
              • CSV
              • JSON
              • Parquet
              • XLSX
              • XML
              • File-based driver properties
            • Drivers management
          • Database Navigator
          • Database Navigator tToolbar
          • Database Navigator settings menu
          • Database Navigator 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
          • Transaction mode
          • Resource Manager
        • Entity relation diagrams
          • Cloud Explorer
          • Cloud Storage
          • AWS settings
          • Azure permissions
          • AI Assistant
          • Data privacy
            • AI chat
              • AI tools & MCP
              • Data read actions
              • View and editor actions
              • Explain query
              • Fix SQL errors
              • AI command
              • Describe object with AI
            • Quick start with AI
            • AI Assistant settings
              • OpenAI
              • GitHub Copilot
              • Azure OpenAI
              • Google Gemini
              • Ollama
              • Anthropic Claude
              • Amazon Bedrock
        • DBeaver Database Tunnel
          • Data export
          • Data import
        • Database Object Editor
          • Managing preferences
          • Preferences
          • Settings
        • Accessibility guide
        • Keyboard shortcuts
        • Search
        • Application window overview
          • Standalone installation
          • Windows silent install
        • 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 mode
            • Pending transactions
            • Transaction log
            • Database username/password
            • DBeaver profile
            • Microsoft Entra ID
            • Kerberos
            • Driver manager
            • ODBC driver
            • File-based driver properties
            • How to add additional artifacts to the driver
            • JDBC time zones
            • JDBC tracing
          • Database drivers
            • Apache Hive
            • Cassandra
            • ClickHouse
            • Couchbase
            • IBM Db2
            • Greenplum
            • InfluxDB
            • Microsoft SQL Server
            • MariaDB
              • MongoDB
              • MongoDB authentication
              • MySQL
              • Two-factor authentication
            • Netezza
              • Oracle
              • Oracle authentication
              • PostgreSQL
              • Pgpass authentication
              • SSPI (Windows SSO)
            • Redis
              • Salesforce
              • Salesforce authentication
              • Teradata
              • LDAP authentication in Teradata
            • Trino
            • Yellowbrick
              • Athena
              • Aurora DSQL
              • DocumentDB
              • DynamoDB
              • Keyspaces
              • Neptune
              • Redshift
              • Timestream
              • Cosmos DB
              • Cosmos DB for NoSQL
              • AlloyDB for PostgreSQL
              • BigQuery
              • Bigtable
              • Cloud SQL for MySQL
              • Cloud SQL for PostgreSQL
              • Cloud SQL for SQL Server
              • Firestore
              • Spanner
              • Databricks
              • Databricks authentication
              • Snowflake
              • Snowflake native authentication
            • 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 credentials
              • AWS SSO
              • AWS permissions
              • 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
              • Value Panel
              • References Panel
              • Metadata Panel
              • Grouping Panel
              • Calc Panel
              • Result details Panel
              • Query trace Panel
            • Managing charts
            • Mock data generation
            • Dashboards
          • XML and JSON data
          • Dictionary data
          • Spatial GIS data
            • Virtual columns
            • Virtual keys
            • Data Editor preferences
            • Data format preferences
          • SQL Editor
          • Visual query builder
            • SQL execution
            • Query Execution Plan
            • 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 Assistant
          • Data privacy
            • AI chat
              • AI tools & MCP
              • Data transfer actions
              • Data read actions
              • View and editor actions
              • Script actions
              • Query suggestion
              • Explain query
              • Fix SQL errors
              • AI command
              • Describe object with AI
            • Quick start with AI
            • AI Assistant settings
              • OpenAI
              • GitHub Copilot
              • Azure OpenAI
              • Google Gemini
              • Ollama
              • Anthropic Claude
              • Amazon Bedrock
            • Disable AI Assistant
          • Diagrams
          • How to use diagrams
          • Custom diagrams
          • Edit mode
          • Data transfer
          • Data import
          • Data import and replace
          • Data export
          • Data transfer external storage
          • Data migration
          • Data transfer via email
          • Structure and data compare
          • Data compare
          • Schema compare
          • Liquibase changelog
          • Liquibase PRO
          • Simple structure compare
          • Task management
          • Task scheduler
          • Composite tasks
          • SQL Script tasks
            • New table creation
            • Incorporating triggers
            • Creating columns
            • Creating indexes
            • Implementing constraints
            • Utilizing foreign keys
          • Database partitions
        • Backup and restore
        • GIT integration
        • Tableau integration
          • Session manager (Web)
          • Session Manager (Desktop)
        • Lock Manager
          • Server configuration
          • Web server configuration
          • First launch guide
          • Server database
          • 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 database configuration
          • 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
          • Pass-through authentication
              • Users
              • Provisioning users
              • Password policy
              • User credentials storage
              • Teams
              • Projects
              • Roles
              • Role management
            • Settings
            • Admin password recovery
            • Global Permissions
            • Initial data configuration
          • Proxy configuration
          • WebSockets
          • Multiple Server URLs
            • Secret Providers
            • Secret requirements
            • Configure secret providers in web client
            • Configure secret providers in desktop client
            • Secret provider setup example
            • Pre-configured database connections
            • Pre-configured permissions for connections
          • Supported browsers
        • Migration from DBeaver Desktop
          • Manage preferences
          • Preference restrictions
          • Variables
          • Command line
            • 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
            • Troubleshooting Windows Defender issues
            • Troubleshooting missing WebView2
              • Log viewer
              • Log files
              • Audit logging
              • Log customization
          • How to change Java security properties
          • Import CA certificates into DBeaver
            • Query manager
            • Query history
            • Workspace location (Web)
            • Workspace location (Desktop)
            • AWS and S3-compatible workspace configuration
        • Team Edition deployment overview
          • Deploy with Docker Compose
          • Deploy with AWS AMI
          • Deploy with GCP image
          • Deploy with Azure image
        • Managing cloud-deployed services
        • API and Integration overview
          • GraphQL API overview
          • GraphQL API documentation
          • Generate API token
          • GraphQL console
          • Run GraphQL requests from CLI
          • GraphQL examples
        • REST API documentation
        • Model Context Protocol Server (MCP)
          • Proxy driver overview
          • Connect Tableau to a database using DBeaver Proxy Driver
        • Import license
        • Update license
        • License management in the user portal
          • License types
          • Muli server license
          • Team Edition AWS marketplace license
        • Release cycles
        • Statistics collection
        • Customer technical support
        • FAQ (Web)
        • FAQ (Desktop)
      Did this page help you?
      What did you like?
      Accurate
      Easy to understand
      Solved my problem
      Helped me decide to use the product
      Other
      0 / 1000
      What went wrong?
      Hard to understand
      Incorrect information
      Missing the information
      Other
      0 / 1000
      Thank you for your feedback!
      Something went wrong. Please try again later.
      Open in ChatGPT Ask ChatGPT about this page Open in Claude Ask Claude about this page
      Web client

      AI smart completion

      The AI smart completion feature was removed in version 25.2. Use AI Chat instead. If you're using an older version, switch to a previous documentation version.

      DBeaver site footer logo
      • Facebook
      • LinkedIn
      • Telegram
      • Reddit
      • Twitter
      • YouTube
      • Products
        • DBeaver Enterprise
        • DBeaver Ultimate
        • DBeaver Lite
        • CloudBeaver Enterprise
        • DBeaver Team Edition
        • dbvr
        • Compare products
      • Download
        • DBeaver Enterprise
        • DBeaver Ultimate
        • DBeaver Lite
        • CloudBeaver Enterprise
        • DBeaver Team Edition
        • dbvr
      • Pricing
        • Buy a license
        • License types
        • Try for free
        • Academic licenses
      • Resources
        • Supported databases
        • DBeaver integrations
        • Use cases
        • Blog
        • Video
        • Events
        • Contact support
      • Documentation
        • DBeaver desktop products
        • CloudBeaver Enterprise
        • DBeaver Team Edition
        • dbvr
      • For partners
        • Become a partner
        • Resellers
        • Technology partners
        • Universities
      • About us
        • Company
        • Customers
        • Contacts
        • Careers
      • Legal
        • Privacy
        • Service Level Agreement
        • Enterprise Software Agreement
        • EULA