Features

DBeaver offers the following major features.

Connections manager

  • Choice of database driver from the variety of supported types.
  • 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
  • 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


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, 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


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


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