Awesome Universal Database Tool for multiple tables, scripts, triggers...

DBeaver

DBeaver

  -  122 MB  -  Open Source
  • Latest Version

    DBeaver 25.1.1 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows 10 / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    DBeaver Corp / External Link

  • Filename

    dbeaver-ce-25.1.1-x86_64-setup.exe

DBeaver is a powerful, open-source database management tool for Windows designed for developers, database administrators, and analysts.

It supports various databases, including MySQL, PostgreSQL, SQLite, Oracle, SQL Server, and many more.

With an intuitive interface and robust features, it provides an efficient way to manage and interact with databases, whether locally or in the cloud.

DBeaver is available in both Community Edition (free) and Enterprise Edition (paid).

The free version offers essential database management features, while the Enterprise Edition includes additional capabilities such as NoSQL database support, cloud integration, and enhanced security options.

Key Features

Multi-Database Support: Connect to over 80 database types, including relational, NoSQL, and cloud-based solutions.

SQL Editor: Advanced SQL editor with syntax highlighting, auto-completion, and error handling.

ER Diagram View: Visual representation of database structures for easier data analysis.

Data Export and Import: Supports various formats such as CSV, JSON, XML, and SQL scripts.

Database Comparison: Compare schemas and data between different databases.

SSH and SSL Support: Secure connection to remote databases.

Cloud Integration: Connect with AWS, Google Cloud, and Azure.

Customizable UI: Dark mode, themes, and layout customization options.

Plugins and Extensions: Extend functionality with additional plugins.

User Interface
  • Navigator Panel: Displays connected databases and their objects.
  • SQL Editor: A powerful code editor with intelligent auto-suggestions.
  • Results Grid: Displays query output with sorting and filtering options.
  • Metadata View: Provides detailed information about tables, columns, and relationships.
  • The UI is user-friendly, making it accessible for both beginners and experienced developers.
Installation and Setup
  • Download DBeaver from the official website or FileHorse.
  • Run the installer and follow the on-screen instructions.
  • Select additional components such as Java (if not installed).
  • Complete the installation and launch the application.
  • Add a new database connection and configure credentials.
How to Use

Create a New Connection:
  • Click on “New Database Connection.”
  • Select your database type.
  • Enter connection details like hostname, port, username, and password.
  • Test the connection and save.
Execute SQL Queries:
  • Open the SQL Editor.
  • Write your SQL queries and run them.
  • View results in the output grid.
Manage Database Objects:
  • Browse tables, views, and stored procedures.
  • Modify structures or create new objects.
Export and Import Data:
  • Use the export wizard to save query results.
  • Import data from external sources like CSV or Excel.
Use ER Diagram:
  • View relational structures.
  • Edit and analyze database schema visually.
FAQ

Is DBeaver free to use?
Yes, the Community Edition is free and open-source. However, the Enterprise Edition requires a paid subscription.

Does DBeaver support NoSQL databases?
Yes, but only in the Enterprise Edition. Supported NoSQL databases include MongoDB, DynamoDB, and Couchbase.

Can I use DBeaver with cloud databases?
Yes, it supports AWS, Google Cloud, and Azure databases.

Does DBeaver require Java to run?
Yes, DBeaver is a Java-based application, and Java Runtime Environment (JRE) is required.

Can I use DBeaver to migrate databases?
Yes, it offers data migration tools to copy data between different databases.

Alternatives

MySQL Workbench - Best for MySQL database management.

pgAdmin - Ideal for PostgreSQL database users.

HeidiSQL - Lightweight and user-friendly.

Navicat - Premium alternative with a polished UI.

Pricing

DBeaver Community Edition: Free (Open-source)

DBeaver Enterprise Edition (PRO version): Starts at $10 per month (billed annually) with additional features like NoSQL support, cloud database integration, and enhanced security.

DBeaver Community Featues:
  • MySQL, SQL Server, PostgreSQL and others
  • Data Editor
  • SQL Editor
  • Database schema editor
  • DDL
  • Basic ER Diagrams
  • Basic charts
  • Data export/import
  • Task management
  • Database maintenance tools
DBeaver PRO Features:
  • Advanced Security: Master password and strong encryption for safe database connections.
  • Enterprise Authentication: Supports SAML, SSO, OKTA, Kerberos, and cloud SSO (GCP, AWS, Azure).
  • Broad SQL Support: Compatible with MySQL, PostgreSQL, SQL Server, Oracle, and more.
  • NoSQL Compatibility: Works with MongoDB, Cassandra, Redis, CouchDB, and others.
  • Cloud Database Integration: Connects to Redshift, BigQuery, Oracle Cloud, and more.
  • Native Cloud Support: Seamless integration with AWS, Google Cloud, and Azure.
  • S3 Browser: Access, upload, and manage files across all regions like a regular file system.
  • AI SQL Assistant: Automates complex SQL scripts and enhances query building.
  • Schema Development: ERD Edit Mode for efficient database modeling.
  • Mock Data Generator: Creates diverse test data for database validation.
  • Data & Schema Comparison: Highlights differences between sources.
  • Query Execution Analysis: Visualize execution plans to optimize performance.
  • Task Automation: Supports multi-component workflows for daily operations.
  • Task Scheduler: Automate tasks and send scheduled reports via email.
  • Comprehensive Support: Assistance from setup to deployment in enterprise environments.
System Requirements
  • OS: Windows 10, Windows 11 / Windows Server 2012 or later versions
  • Processor: Intel/AMD 64-bit processor
  • RAM: 2GB (4GB recommended)
  • Storage: At least 200MB free disk space
  • Java Version: Java 11 or later
PROS
  • Supports a wide range of databases.
  • Powerful SQL editor with syntax highlighting.
  • Free and open-source (Community Edition).
  • Secure connections with SSH and SSL.
  • Cloud and NoSQL support in Enterprise Edition.
CONS
  • Requires Java, which can be a hassle for some users.
  • Enterprise Edition is costly compared to some alternatives.
  • Advanced features can have a learning curve.
Conclusion

DBeaver is one of the best database management tools available for Windows users, offering extensive support for various databases, a user-friendly interface, and advanced features. Whether you're a developer, data analyst, or database administrator, it provides everything you need for efficient database management.

For those looking for a free and open-source solution, the Community Edition is an excellent choice. However, if you need NoSQL database support, cloud integration, and additional enterprise-level features, the Enterprise Edition is worth considering.

Note: Requires Java Runtime Environment.

Also Available: Download DBeaver for Mac

Why is this app published on FileHorse? (More info)
  • DBeaver 25.1.1 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    DBeaver 25.1.1 Screenshot 1
  • DBeaver 25.1.1 Screenshot 2
  • DBeaver 25.1.1 Screenshot 3
  • DBeaver 25.1.1 Screenshot 4
  • DBeaver 25.1.1 Screenshot 5

What's new in this version:

SQL Editor:
- Added support for column expansion for CTEs
- Added support for TSQL "TOP" expression
- Added support for CTE names in sub-queries
- Disabled SQL autocomplete inside DBeaver SQL commands
- Fixed an issue where code completion failed in long queries when using column aliases
- Fixed an issue where most of the output was lost after performing a search
- AI assistant: GitHub Copilot authorization dialog was improved

Metadata Editor:
- Added progress visualization for loading items and a message indicating when the list is empty
- Fixed sorting of objects such as indexes
- Fixed layout issues when resizing stacked multi-line fields
- Data Editor: fixed cursor positioning after filter auto-completion

Navigator:
- Fixed the "Hide" and "Show Only" filter options, added support for filtering by name with arguments
- Fixed an exception that occurred when deleting an open project

Connectivity:
- Fixed an issue where SSL settings were removed after adding an SSH profile
- Redesigned the DBeaver connection profiles for improved structure and usability
- After changing an expired database password, you can now immediately test the connection with the new password

General:
- Transaction commit/rollback buttons now have drop-down menu which can show queries within this transaction
- Fixed compact DDL generation for tables
- Set English as the default language in the Microsoft Store distribution
- Improved the appearance of several database logos in dark theme
- Fixed an exception in the Output viewer

Databases:
CUBRID:
- Added the ability to delete comments on Serial and Views
- Fixed an error that occurred when deleting properties and comments on the server
- Fixed an error when editing null values in the metadata editor
- Fixed an issue where view DDL was truncating UNION ALL statements

Clickhouse:
- Fixed the display of nested arrays in the data grid and SQL generation
- Fixed an issue with folder display in the Navigator when using driver version 8.0.x or higher
- Fixed data type loading and array editing issues
- Removed Foreign Keys and References tabs from the Metadata Editor

- DuckDB: Improved display of structured data type keys in the Data Editor
- Exasol driver was updated to version to 25.2.3
- Firebird: Removed "AS" before table alias for legacy Firebird
- Neo4j was deleted from Community version
- Oracle: Added column-level privileges to the Privileges view

PostgreSQL:
- Fixed syntax highlighting for the INTERVAL keyword
- Fixed an issue where database names containing slashes caused a connection error when accessing schemas
- Salesforce Data Cloud: Now uses the shaded driver version by default