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

DBeaver

DBeaver

  -  122 MB  -  Open Source
  • Latest Version

    DBeaver 25.1.2 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.2-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.2 Screenshots

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

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

What's new in this version:

SQL Editor:
- Added variables for virtual column manipulation: row (a map of column names to their values) and table (with name, schema, and container fields)
- Aliases can now be used in a case-insensitive manner
- Fixed issue where the selected schema wasn’t recognized after reconnecting

AI Assistant:
- Improved GitHub Copilot authorization: the auth token is now displayed during the authorization process and can be copied.
- GitHub Copilot now displays the up-to-date list of available models
- Fixed the AI button not working when the AI extension is installed
- Hide script ruler when executing queries from AI chat

Data Editor:
- Fixed incorrect code generation and saving for Virtual key updates
- Added an option to show column ordinal position next to the column name in the data grid
- Data Transfer: Improved NVARCHAR mapping accuracy during data import
- Security: Fixed CVE-2023-48795

Connectivity:
- Improved UI controls on the connection settings
- Fixed "--newInstance" option when starting the application via CLI
- "Change Connection(s) Driver" option is now working again
- Fixed an issue where newly created connection types couldn't be deleted

General:
- English is now the default language. If a user has never selected a language manually, the UI will switch to English
- Fixed an issue where UI elements disappeared when using a display scale other than 100%
- Most icons in the application have been updated to SVG format
- Based on Eclipse 2025-06. Earlier versions are no longer supported

Development:
- JSQL Parser library was updated to version 5.3
- Fixed the ability to install CE bundles in Eclipse

Databases:
BigQuery:
- Added BigQuery to the SQL category in the connection dialog
- Fix column aliases visibility validation - column aliases are not available in WHERE but are visible in other SELECT query parts

Clickhouse:
- Fixed identifiers quotation
- Added support for complex types nested in arrays
- CUBRID: Fixed VARCHAR length not displaying in Navigator
- DB2 LUW: Added support for changing expired passwords (not available for databases running in Docker)

MySQL:
- Fixed the ability to create a dump
- Fixed an exception when opening the partition Virtual tab
- Oracle: Fixed CREATE PROCEDURE statement boundaries detection

PostgreSQL:
- Fixed misplaced comment in DDL generation
- Fixed the ability to connect when the port is specified in the URL for PgPass authentication
- Fixed display issue with time zones when date formatting is enabled
- Added support for MAINTAIN privilege