About DBeaver

DBeaver is a universal database management tool for anyone who needs to work with data professionally.

With DBeaver, you can manipulate your data as if working in a regular spreadsheet, create analytical reports from records across various data storages, and export information in the desired format. For advanced database users, DBeaver offers a powerful SQL editor, extensive administration features, tools for data and schema migration, database connection session monitoring, and much more. Focused on usability, DBeaver offers:

• Intuitive and modern user interface
• Enterprise-grade security features
• Support for a wide range of databases
• Seamless integration with cloud data sources
• Compatibility with extensions for Excel, Git, and more
• AI-powered assistance
• Rich set of tools for database management and analytics
• Multiplatform support for Windows, macOS, and Linux

Table of contents

• Getting started

  • First steps and basics
  • Installation guide
  • How to import license
  • Application window overview
  • Basic operations
  • FAQ

• 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

    • System operations and security

      • Shell commands
      • Changing current user password

  • Database 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 in DBeaver

      • Managing 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
    • Deprecated legacy ODBC driver
    • JDBC time zones
    • JDBC tracing

  • Security in DBeaver

    • Security in DBeaver PRO

    • Password secure storage

      • Password secure storage overview
      • Master password
      • Automation (console) security
      • Integrated security
    • Secret Providers

• 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
      • Oracle SQL Plus script execution
    • 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
      • Snowflake authentication

  • Embedded

    • SQLite

  • File drivers

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

• Database Navigator panel

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

• Projects workspace

  • Projects overview
  • Projects View
  • Project Explorer
  • Project security

• Editors in DBeaver

  • 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
      • Query execution plan
      • 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 Commands
      • Export Command

  • Entity Relation Diagrams

    • Diagrams overview
    • Database Structure Diagrams
    • Custom Diagrams
    • Edit mode for 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

  • GIT integration
  • Tableau integration
  • Database debugger (PostgreSQL)
  • Optional extensions
  • Eclipse extensions
  • Extension office for Data Transfer

• DBeaver configuration

  • User interface in DBeaver

    • Accessibility
    • User interface themes
    • UI language
    • Toolbar customization
    • Views

    • Workspace

      • Workspace location
      • Resetting your workspace
  • Keyboard shortcuts
  • Certificate management
  • Importing CA certificates from your local Java into DBeaver
  • Configuration files

• DBeaver editions

  • Enterprise edition
  • Lite edition
  • Ultimate edition

• Tutorials

  • New table creation
    • Incorporating triggers
    • Creating columns
    • Creating Indexes
    • Implementing constraints
    • Utilizing foreign keys
  • How to create a sample database
  • How to work with database Partitions
  • How to import connections from external tools

• Support and development

  • Admin preferences in DBeaver

    • Admin manage preferences
    • Admin manage connections
    • Admin manage drivers
    • Admin preference restrictions
    • Admin variables
    • Pre-configured variables

  • Command line

  • Session manager

  • Troubleshooting in DBeaver

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

    • License administration

      • License administration overview
      • How to import license
      • How to reassign license
      • Differences between license types
  • Windows Silent Install
  • Snap Installation
  • Statistics collection
  • Release cycles
  • Technical support information

Contacts

For technical support, feature suggestions, and any other questions, please use our GitHub Issue tracker