Below is a brief list of features offered by DBeaver.
- In the connection wizard, user may choose appropriate database driver (or you can create a new one in driver manager).
- Besides standard connection properties (like host, port, user credentials) user can configure:
- SSH tunnel.
- SOCKS proxy.
- Shell commands which will be executed before/after actual database connection.
- Bootstrap SQL queries which will be executed in the database session immediately after connecting. DBeaver supports different connection types including user-defined types.
Data viewer and editor
- In results viewer you can view and edit data.
- There are multiple data views allowing the user to choose the view best for their needs. For instance, DBeaver can recognize columns that store images (gif, png, jpeg, bmp) and show contents as an image.
- User can apply custom filters to any table contents or query results. Also, the user can apply a filter based on cell value(s).
- User can order results by some column(s)
- Data export works with all applied filters and orderings.
- User can generate SQL statements based on selected rows.
- Database Explorer View shows connections and their contents. Connection content represents database metadata structure. You can view existing tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions, etc), and security entities (users, roles, etc).
- Many metadata entities are editable provided the database driver provides support for editing these entities (see database-specific features below). Generally, you can create/drop/modify most metadata objects.
- You can see objects’ DDL on a special object editor tab. Some drivers provide native DDL (generated by database engine) but for other drivers DBeaver generates standard SQL92 DDL according to object structure.
- User can rename connections and database objects (if these objects can be renamed).
- User can filter database objects by name. There are global filters (can be set in connection editor dialog) and local filters.
- User can export data to file(s) or to another database table(s), with the option to create the destination table if it does not exist.
- Supported file formats: CSV, HTML, XML, XLS, XLSX.
- User can view automatically generated ER diagrams for a database/schema (diagram will contain all schema tables) or for a single table.
- Single table diagrams include all referenced/referencing tables.
- It is possible to configure columns’ visibility.
- Diagram can be exported (saved) in one of the following formats: GIF, PNG, BMP, GraphML.
- You can see and organize all of your scripts in folders and can reassign database connections for particular scripts.
- DBeaver uses SQL syntax highlighting determined by the database associated with a script. Different databases have different sets of reserved keywords and system functions.
- Import and export scripts
Data and metadata search
- Full-text data search uses against all chosen tables/views to find data. Search results will be shown as filtered tables/views.
- Metadata search tries to found rows in database system tables.
- User can set an exact object name or a search mask.
Database structure comparing
- After selecting multiple objects in Database Navigator user can perform objects structure compare
- User can compare any objects: tables, schemas, entire databases, etc.
- Compare results is a report in HTML format.