Awesome connectivity, configurability, organization
DBeaver is used to connect, query, update and manage a variety of databases through many configurations. I personally use it because it …
Starting at $11 per month per user
View PricingOverview
What is DBeaver?
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
Recent Reviews
Popular Features
- Database change management (5)9.191%
- Schema maintenance (9)9.090%
- Database status reporting (6)8.383%
- User management (5)7.979%
Reviewer Pros & Cons
Pricing
Lite Edition Subscription
$11
On Premise
per month per user
Enterprise Edition Subscription
$25
On Premise
per month per user
Lite Edition License
$110
On Premise
per year per user
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://dbeaver.com/buy
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Starting price (does not include set up fee)
- $11 per month per user
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is DBeaver?
DBeaver is a universal database management tool, able to support SQL (MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle, and IBM DB2, Sybase, etc.) and NoSQL databases (MongoDB, Couchbase, Redis, Cassandra, etc.), as well as cloud databases (AWS Redshift, Google BigQuery, Snowflake, etc.).
Connection to various data sources
- 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
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
- 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
The user 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 (but not limited to):
- Numbers
- Random strings
- Names
- Addresses
- Credit cards
- Domains and IP addresses
- Custom regular expressions
- Flexible numeric generators
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
- Construct complex SQL queries without actual knowledge of SQL
- Make table joins/filtering/ordering visually
- Open existing SQL queries in visual mode, edit and save them
- Execute a 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
- Import data directly from CSV file into database table. Setup columns mapping and data types in convenient wizards
- Save data transfer configurations as tasks and run them in one click
- Schedule data transfer tasks for later/recurrent execution
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 compare
- Ability to compare several database objects of any type: tables, schemas, entire databases, etc.
- Comparison results can be presented as: HTML, DDL alter scripts, Diff diagram, Liquibase changesets
- Database structure synchronization can be performed
While DBeaver offers a community edition at no cost, users of the 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. The vendor states it usually takes no more than one working day to answer questions, and just a few days to fix bugs reported by the users.
DBeaver Features
Database Development Features
- Supported: Version control tools
- Supported: Test data generation
- Supported: Database change management
Database Administration Features
- Supported: User management
- Supported: Database security
- Supported: Database status reporting
- Supported: Change management
DBeaver Video
This demo video describes the main features of DBeaver
--
0:05 Connections
01:07 Cloud Explorer
02:08 Data Editor
04:04 Grid Colorization
05:36 Data Highlighting
07:04 Data Visualization
08:09 Spatial data
09:05 Value Panel
11:53 Calc & Group Panels
13:06 SQL Editor
16:4...
 Show More DBeaver Competitors
DBeaver Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows, Linux, Mac |
| Mobile Application | No |
Frequently Asked Questions
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
DBeaver starts at $11.
Reviewers rate Database change management highest, with a score of 9.1.
The most common users of DBeaver are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(51)Attribute Ratings
Reviews
(1-9 of 9)Companies can't remove reviews or game the system. Here's why
February 09, 2023
Awesome connectivity, configurability, organization
DBeaver is used to connect, query, update and manage a variety of databases through many configurations. I personally use it because it can store many queries and associate them with a particular database or on a particular sheet with related queries. It can make diagnosing problems much more quickly than without organizational features.
- Complex connection configurations
- Managing and organizing queries for a large number of different databases
- Ability to make proposed updates and then write those once we are ready
- Better navigation especially on the main query screen
- Make icons fewer, simpler and more intuitive
- vim integration
Score 10 out of 10
Vetted Review
Verified User
DBeaver is used by me to work with SQL Server databases.
- Identify types of DB connections by color code: development, testing and production.
- Predictive typing, it is incredibly accurate and saves me a lot of time.
- Jump between different simultaneous DB connections.
- Navigate through the schema object tree.
- Provide all the tools I need in one window.
- Some icons are kinda small and difficult to understand what they do
- The spanish translation could be better
- I think there are many functions that could be useful for me but I don't know what they do
October 04, 2021
DBeaver - A Great Open Source Tool
We use DBeaver to connect to our Snowflake instance, as well as our on-premises Microsoft SQL servers. It is very nice because we can query both without having to have an application for each. I find that DBeaver is able to generate the DDL behind Snowflake views much easier than in the Snowflake IDE.
- Querying against Snowflake
- Personalizing formatting of T-SQL
- Easily connect to Snowflake and other servers
- Engaged and caring community
- I would like an option to configure key shortcuts further.
- I would like an option to automatically invalidate /refresh connections after a period.
- It would be helpful if there was a more intuitive way to "code together".
August 31, 2021
DBeaver Offers a Great Feature Set for Free
I use DBeaver as a graphical interface for accessing databases locally and remotely for testing and data analysis. It allows easy access to viewing data and running SQL Queries against the data as well as updating test data locally.
- Running SQL Queries
- Displaying data
- Sorting data
- Viewing multiple tables
- UI can be cumbersome and confusing
- Constant updates creates multiple reminders
August 18, 2021
A single database tool for all users and needs!
DBeaver is used by our company as a go-to application to access data and manage relational databases. It is used across multiple departments and addresses the need to conveniently and easily access, read and manipulate the data. Due to its simplicity and at the same time broad functionality, it is successfully used by both technical and non-technical categories of users.
- All-in-one solution that allows connecting to most types of relational and non-relational databases, which eliminates the need to use separate applications for similar tasks.
- Allows to auto-generate different types of queries, which saves a lot of time that otherwise would be spent on typing.
- Great syntax highlighting, autocompletion and error handling, which allows to swiftly type complex queries.
- It would be great if DBeaver highlighted possible errors in queries in real time manner as the user types.
DBeaver is used by both software developers and people who are responsible of support services for a web application with large user base. It allows developers to quickly view and modify database as they are developing the application and testing features. For support people it helps to solve customer queries which need to get information from the database. They also use it to modify database when configuration options for the application needs to be changed.
- Easy to make and restore backups.
- Good UI for viewing table data & schema. No more command line ever again!
- Overall has a large feature set for all database related tasks (users, events etc...)
- The UI is not very modern and looks dated.
- A barely noticeable delay when changing views.
November 26, 2019
Great open-source SQL client
A lot of developers use DBeaver for its ease of use. It lets me as a developer do a lot more than a typical SQL client. I especially like the visualization that this tool offers to me. I can easily see how all the tables are connected in an ER diagram and I can make changes and modify it.
- Visuals.
- Autocomplete your SQL.
- Sometimes it's clunky and slow.
- One time it made changes to prod without me asking it to do anything.
March 21, 2019
DBeaver is very comfortable to use for your everyday database management and monitoring task
Its really great to view and manage data in development, staging, and even production databases. DBeaver supports any SQL database nicely, we are using three different kinds of SQL databases (MySQL, PostgreSQL, and SQL server) and I don't need multiple database client tools since all of them could be handled with DBeaver. By doing that, I save a lot of time and PC resources viewing all of the databases we have, which is really great.
- Support a lot of popular database types.
- Support SSH tunneling so you could connect to the production database quite easily.
- Supports inline editing which is very convenient. Also, you need to click "save" for inline editing to avoid miss clicks or miss typing on the production database.
- No support for NoSQL databases.
- The interface could be confusing for first-time users.
- No support for multiple queries in one editor.
January 23, 2019
Great DB development tool!
Our development staff uses DBeaver for editing database/table schema (when needed) and for creating production deployment scripts. We are using the free community edition and it is extremely stable and works very well. Since it supports multiple databases, we can also use it for Microsoft's SQL Server, but we currently only use it for PostgreSQL. Compared to other products on the market, it did what we needed to do, even though sometimes the UI can be a little unintuitive compared to what we are used to with SQL Management Studio.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
- Data import/export and SQL Script generation are quick and simple to do.
- Fairly intuitive when viewing/editing table data.
- Ability to save SQL scripts per server and recall them easily.
- Handy intelligence when writing queries, functions, and stored procs.
- Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
- Sorting and filtering in data is nice, but buried in long right-click menus.
- Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.