Multi-Purpose
With DBeaver you do not need multiple tools to manage various aspects of database management – DBeaver consolidates all of them:
Database Analysis
Convenient tools for the development of visual diagrams of individual database objects and whole schemas, their customization and export as well as metadata management
Data Editing
Simple and intuitive viewing and editing of data, augmented with sorting and filtering functions
SQL Development
A full-featured and fast-working SQL editor for developing, executing, storing, exporting and re-using scripts with data profiling and formatting functions. SQL Editor could become a product of its own intended for use by professional SQL developers but it is a part of DBeaver, and this is great!
Database Administration
A wide range of features for database support and analysis, data export and import, user sessions and locks management, and a lot more
With a beaver`s persistence, we are developing new features and enhancing existing ones to expand and strengthen DBeaver`s capabilities.
To learn about these and other DBeaver`s features and their technical details, please visit Features.
Works on All Major Platforms
You can launch DBeaver on all major platforms: Windows, MacOS and most popular versions of Linux – CentOS, Ubuntu, etc. Our installers have all necessary certificates and satisfy security requirements. 支持 Windows、Mac OS X 和 Linux
Supports Nearly All Databases
Out of the box, DBeaver supports any database that has a JDBC or ODBC driver – that is almost all relational databases and most NoSQL databases: MySQL, PostgreSQL, DB2, Oracle and many others.
Besides JDBC and ODBC, DBeaver supports databases that do not have any standard xDBC driver, for instance Mongo DB, Redis or WMI.
To find your database, see the full list of supported databases
We are constantly working to train DBeaver to work with more databases. The major trend is data science and work with big data, search databases (Solr) and databases in cloud.
Friendly to All User Categories
DBeaver is equally good for professional and amateur database managers because it makes the work on databases and data intuitive, simple, and convenient. With DBeaver, the complex tasks of database analysis and administration turn out to be easier than they might seem at the first glance. DBeaver does not require any special technical knowledge to support your database in up-to-date state and provides help where needed.
Connection to various datasources
- Choice of database driver from the variety of supported types. The list of drivers includes drivers for relational, document oriented, key value, time-series and other databases.
- Support of user-defined connection types and creation of custom drivers an the Driver Manager
- Configuration of standard (host, port, user credentials) as well as advanced connection properties:
- SSH tunnel
- SOCKS proxy
- Shell commands to be executed before/after actual database connection
- Bootstrap SQL queries executing in the database session immediately after connecting
NoSQL / BigData databases
DBeaver Enterprise has special extensions for:
- MongoDB
- Amazon DynamoDB
- Google Bigtable
- InfluxDB
- Apache Cassandra
- Redis
- Apache Hive
All these databases have SQL interface and you can work with them as with good old relational databases.
And this is not some kind of JDBC driver abstraction – DBeaver EE supports all native data types and databases structure explorer for these databases.
Advanced Security
- Keep your databases passwords in secured storage protected by master password or use native OS password encrypted storage
- Use BouncyCastle advanced security algorithms to connect over SSH or SSL
All-in-one
- DBeaver EE comes with all existing extensions, you don’t need to install anything else. This includes:
- Office formats support
- Vector graphics support
- SQL debugging framework
- Advanced SSH algorithms
- Most of popular database drivers are included in distribution
- A number of Eclipse extensions are included for advanced security and easy installation of 3rd party extension using Eclipse Marketplace
Data viewer and editor
- Multiple data views to fit the variety of users’ needs, for example display of image contents (gif, png, jpeg, bmp) as an images
- Editing of data inline and in a dedicated space
- Convenient navigation among data
- Custom filters for table contents or query results, including filters based on cell values
- Results ordering by column
- Data export with all applied filters and orderings
- Generation of SQL statements based on selected rows
- Basic statistics for selected columns
Mock-Data Generator
You can generate random data (or “mock" data) for tables. And this data should look like the real data.
Enterprise edition includes basic and advanced data generators. Including:
- Numbers
- Random strings
- Names
- Addresses
- Credit cards
- Domains and IP addresses
- Custom regular expressions
- Flexible numeric generators
- And many more
SQL editor
- Organization of scripts into folders and reassignment of database connections for particular scripts
- SQL syntax highlighting determined by the database associated with a script
- Support for different sets of reserved keywords and system functions for different databases
- Import and export of scripts
Visual Query Builder
- You may construct complex SQL queries without actual knowledge of SQL
- Make table joins/filtering/ordering visually
- Open you existing SQL queries in visual mode, edit and save them – that’s easy
- Execute your visually constructed query at any moment and get results on the screen
- Analyze complex SQL queries visually
Metadata browser
- A tree of database connections with their metadata structures down to the lowest level: tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions), and security entities (users, roles)
- Ability to modify most metadata entities, depending on the database driver capabilities
- Display of database objects` DDL and generation of standard SQL92 DDL according to object structure for some databases
- Ability to edit/rename/delete connections and most database objects
- Global and local filters, ability to filter database objects by name
Data transfer
- Export of data to a file or to another database table with the option to create the destination table if it does not exist
- Supported file formats: CSV, HTML, XML, JSON, XLS, XLSX
ER diagrams
- Automatically generated ER diagrams for a database/schema (with all tables) or for a single table (with all referenced/referencing tables)
- Customization of columns visibility
- Export of diagrams to the formats: GIF, PNG, BMP, GraphML
Data and metadata search
- Full-text data search against all chosen tables/views with search results shown as filtered tables/views
- Metadata search among rows in database system tables
- Ability to set an exact object name or a search mask
Database structure comparing
- Ability to compare several database objects of any type: tables, schemas, entire databases, etc
- Comparison results presented in HTML reports
Customer Support
Users of Enterprise Edition have an access to the special online support system. They can write a ticket with question, bug or improvement and track it from the profile.
It usually takes us no more than one working days to answer questions, and just a few days to fix bugs reported by the users.
支援的資料庫
DBeaver經官方測試,其支持:MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、Teradata 和一些符合 JDBC連接的資料庫。
Out of the box DBeaver supports any database that has a JDBC or ODBC driver.
However, for some databases DBeaver provides advanced support: it supports database-specific metadata, data types, SQL dialect, etc.
新版4版開始搭配擴件使用支持 Cassandra, MongoDB, Redis 和 WMI (without JDBC drivers).
Relational | Analytics | Document-Oriented | Cloud | Hadoop | Key/Value | Time Series | Graph | Search engines | Embedded
MySQL MariaDB PostgreSQL Microsoft SQL Server Oracle DB2 SAP® MaxDB® Informix Sybase®/SAP® ASE Mimer SQL InterSystems Caché Ingres Yellowbrick Babelfish YugabyteDB Virtuoso |
CUBRID DuckDB Apache Calcite Avatica Apache Kylin Data Virtuality Denodo 8 Dremio EDB Google Cloud Spanner H2GIS HSQLDB InterSystems IRIS Trino CrateDB Monetdb HeavyDB (OmniSciDB) |
Openedge Salesforce Data Cloud SQream DB Fujitsu Enterprise Postgres Materialize TiDB Salesforce Kafka (ksqlDB) Dameng (DM8) Altibase RisingWave |
||
Greenplum Exasol Vertica Teradata SAP® HANA® |
Netezza Azure Databricks Ocient Kognitio |
PrestoDB ClickHouse StarRocks |
||
MongoDB Free and open-source cross-platform document-oriented database Azure Cosmos DB |
Couchbase Couchbase is an open-source, distributed multi-model NoSQL document-oriented database software that is optimized for interactive applications. |
CouchDB The open-source document-oriented NoSQL database. |
||
AWS Athena AWS Redshift AWS DynamoDB AWS Aurora AWS DocumentDB AWS Keyspaces AWS Timestream Google Bigtable |
Google BigQuery Amazon Neptune SQL Azure Snowflake SingleStore NuoDB Oracle NetSuite Oracle Autonomous Data Warehouse |
Oracle Autonomous Transaction Processing Oracle Autonomous JSON Database Cloud SQL AlloyDB Firestore |
||
Apache Hive Spark Hive Apache Drill Apache Phoenix Apache Impala |
Gemfire XD Apache Ignite Apache Kyuubi Cloudera |
CockroachDB SnappyData ScyllaDB |
||
Apache Cassandra |
Redis |
|||
Timescale InfluxDB |
Machbase TDengine |
|||
Neo4j Graph database management system |
OrientDB Distributed Multi-Model and Graph Database |
|||
Elasticsearch Distributed, free and open search and analytics engine for all types of data, including textual, numerical, geospatial, structured, and unstructured. Solr Popular, blazing-fast, open-source enterprise search platform built on Apache Lucene™. |
OpenSearch Open Distro ElasticSearch |
|||
SQLite HSQLDB H2 |
Apache Derby / Java DB Microsoft Access CSV |
Windows Management Instrumentation DBF Raima |
Connection | Lite | Enterprise | Ultimate | CloudBeaver | Team |
SQL database Support (view all) | V | V | V | V | V |
NoSQL/BigData database support (view all) | V | V | V | V | V |
3rd party drivers included | V | V | V | V | V |
AWS native support | V | V | V | ||
GCP native support | V | V | V | ||
Azure native support | V | V | V | ||
Cloud explorer | V | V | V | ||
Cloud storage | V | V | V | ||
Administration & Security | Lite | Enterprise | Ultimate | CloudBeaver | Team |
Enterprise authentication mechanisms | V | V | V | V | V |
Advanced security | V | V | V | V | V |
Task scheduler | V | V | V | ||
Multicomponent Task manager | V | V | V | ||
Support for database backup tools | V | V | V | ||
Data migration | V | V | V | ||
Database maintenance tools | V | V | V | ||
Server health dashboards | V | V | V | ||
Development | Lite | Enterprise | Ultimate | CloudBeaver | Team |
SQL execution plan diagram | V | V | V | V | V |
Entity Relationship diagrams | V | V | V | V | V |
Database schema development (ERD Edit mode) | V | V | V | ||
Mock data generation | V | V | V | ||
SQL Debugger (PostgreSQL) | V | V | V | ||
Schema compare/migration | V | V | V | ||
Table data comparison | V | V | V | ||
Sync projects to the Git repository | V | V | V | ||
Data & SQL Management | Lite | Enterprise | Ultimate | CloudBeaver | Team |
SQL editor | V | V | V | V | V |
Visual Query Builder | V | V | V | V | V |
Data editor | V | V | V | V | V |
Query history | V | V | V | V | V |
GIS data viewer | V | V | V | V | V |
Data export/import | V | V | V | V | V |
Analytical charts | V | V | V | V | V |
AI Assistant in SQL editor (ChatGPT) | V | V | V | V | V |
Tableau integration | V | V | V | ||
Collaboration | Lite | Enterprise | Ultimate | CloudBeaver | Team |
All users query history | V | V | |||
Data collaboration in real time | V | V | |||
Shared scripts and database connections | V | V | |||
Unified user access to the workspace via SAML, Azure AD, or SSO | V | V | |||
Unlimited shared projects and datasets | V | ||||
Advanced Role Management | V | ||||
Load Scalability | V |
System Requirements:
DBeaver is tested and verified for Windows, Linux and Mac OS X.
Supported versions:
» Microsoft Windows 10 or later versions
» Windows Server 2016 or later versions
» macOS 11 or later versions