DBeaver

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

• 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