DBeaver

DBeaver stands as a versatile database management solution, supporting multiple versions and database types. This comprehensive tool facilitates connections to both traditional and cloud-based data sources, with its latest release offering enhanced CTE support and improved SSH connectivity. Whether through its desktop or web-based interface, DBeaver provides robust functionality while maintaining compatibility across modern operating systems.

Overview

DBeaver offers both desktop and web-based versions, with the latest release being version 25.0.4 as of May 4th, 2025. The desktop version includes enhancements such as improved Common Table Expression (CTE) support in the SQL Editor and automatic cell scrolling in the Data Editor. Connectivity improvements include updated drivers and fixed address replacement issues when connecting via SSH.

The web-based version, CloudBeaver, provides a browser-based alternative and can be accessed on any device with web browser capabilities. The system requirements specify support for modern versions of Windows (8/2012 and later), macOS (11 and later), and Linux distributions, while requiring Java 21 or higher for installation.

Database support spans over 40 types, including SQL, NoSQL, and cloud data sources. The Community edition supports popular databases like MySQL, MariaDB, PostgreSQL, and SQLite, while the PRO version extends this with features like advanced security, AI assistance, and enhanced cloud database support for AWS, Google Cloud, and Azure. Both versions offer essential tools such as data editors, ERD functionality, and comprehensive schema management capabilities.

Technical Specifications

DBeaver's technical requirements center around modern operating systems and the latest Java runtime. The desktop version specifically requires Java 21 or higher, utilizing OpenJDK which is included in all supported distributions. Users have flexibility in Java installation through local deployment options.

The tool offers multiple installation methods to accommodate various user environments. Windows users can choose between installers that automatically upgrade existing installations or manual installation through zip archives. Similarly, macOS users have both DMG and Brew Cask options for installation, while Linux systems support a variety of package managers including dpkg, rpm, and Snap.

Additional installation flexibility comes through different packaging formats. For Linux, users can choose between pre-java packages like .deb and .rpm, or install directly from source tar.gz archives. The platform design also allows for custom Java deployment, enabling users to run the tool alongside their own Java installations by removing the included jre folder.

System compatibility extends to multiple computing environments, including Windows 8/2012 and later, macOS 11 and later, and all major Linux distributions. The tool's cross-platform design supports both desktop and cloud usage, with Windows, Mac, and Linux versions offering identical core functionality while targeting different installation and deployment workflows.

Version Options

DBeaver PRO builds upon the foundation of the Community edition, offering expanded security features that include master password and strong credentials encryption for secure database connections. Enterprise-level authentication methods are available through options like SAML, Single Sign-On (SSO), OKTA integration, and Kerberos support.

The PRO edition demonstrates enhanced cloud database support by providing native access to major providers including Google Cloud Platform (GCP), Amazon Web Services (AWS), and Microsoft Azure. It extends this functionality to specific cloud services such as Redshift, Google BigQuery, and Oracle Cloud, allowing users to access files across multiple regions through the S3 browser for file upload, storage, sharing, and saving.

Additional features include AI integration that assists developers through advanced SQL capabilities, such as an AI-driven SQL editor and a Visual Query Builder for constructing complex scripts automatically. The tool's database development workflow has been enhanced with ERD (Entity Relationship Diagram) editing capabilities and sophisticated mock data generation capabilities that can create diverse entity types for testing scenarios.

The PRO version also includes comprehensive database management tools, such as advanced comparison functionality, extensive export/import capabilities, and robust data transfer utilities. These features support the development lifecycle from schema design to deployment, while maintaining compatibility with the full range of database types supported in the base Community edition.

Installation Methods

The desktop version of DBeaver offers flexible installation options across multiple platforms. Windows users have the choice between automatic upgrades through an installer or manual installation from a zip archive. Both methods lead to running the "dbeaver" executable after setup.

MacOS introduces two primary installation routes, with users able to either drag the application into their Applications folder using a DMG file or install via Brew Cask through the terminal command "brew install --cask dbeaver-community".

Linux users benefit from several installation paths, including traditional package managers for Debian-based systems (using dpkg for .deb files or rpm for .rpm files), Snap for snap packages, and the ability to install from source tar.gz files. For full compatibility, users can choose between versions with or without the included Java runtime, allowing for local Java installations by removing the "jre" folder in the installation directory.

Additionally, Linux users can take advantage of official repository support through commands like "sudo wget -O /usr/share/keyrings/dbeaver.gpg.key https://dbeaver.io/debs/dbeaver.gpg.key" for Debian-based systems or "sudo add-apt-repository ppa:serge-rider/dbeaver-ce" for Ubuntu PPA installations.

Installation flexibility extends to multiple deployment workflows, with options including Microsoft Store, Apple Silicon, and Intel-specific DMGs for MacOS, and various package manager support across all major Linux distributions. The cross-platform design ensures consistent core functionality while accommodating different installation and deployment workflows across Windows, Mac, and Linux environments.

Supported Databases

The supported database types span multiple categories including SQL, NoSQL, and cloud data sources, with both Community and PRO versions offering expanded functionality.

The tool officially supports over 40 database types across these categories. This includes a comprehensive list of SQL databases like MySQL, MariaDB, PostgreSQL, and SQLite, as well as popular NoSQL options such as MongoDB, Cassandra, Redis, and CouchDB. Additionally, it provides native support for major cloud databases including Redshift, Google BigQuery, and Oracle Cloud, while also featuring native cloud support for AWS, Google Cloud, and Azure.

The PRO version builds upon this foundation by extending support through ODBC drivers and adding advanced features for specific database types. For example, it includes enhanced capabilities for ClickHouse, CUBRID, GBase 8s, and Firebird, while also providing ongoing technical support and improved security features. These enhancements include master password and strong credentials encryption for secure database connections, as well as advanced authentication methods such as SAML, Single Sign-On (SSO), OKTA integration, and Kerberos support.