DBeaver 23.0 Ultimate Edition Multilingual (macOS/Linux)

DBeaver is a comprehensive and effective software solution geared towards developers and database administrators who need to manage and organize tables, triggers, views and stored procedures from multiple databases. Irrespective of the database you choose to work with, here referring to MySQL, SQLite, PostgreSQL, Oracle, Microsoft SQL Server, IBM DB2 and Firebird, the application comes in handy for users who need to handle multiple connections, thus organizing and editing various database objects including indexes, user accounts and scripts.
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 ManagerConfiguration of standard (host, port, user credentials) as well as advanced connection properties:
SSH tunnelSOCKS proxyShell commands to be executed before/after actual database connectionBootstrap SQL queries executing in the database session immediately after connecting
NoSQL / BigData databases
DBeaver Enterprise has special extensions for:
MongoDBCouchbaseAmazon DynamoDBGoogle BigtableInfluxDBApache CassandraRedisApache 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.
All-in-one
DBeaver EE comes with all existing extensions, you don't need to install anything else. This includes:
Office formats supportVector graphics supportSQL debugging frameworkAdvanced SSH algorithmsMost of popular database drivers are included in distributionA number of Eclipse extensions are included for advanced security and easy installation of 3rd party extension using Eclipse Marketplace
Advanced Security
Use Kerberos or Active Directory authentication to integrate with corporate user management system.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.
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 imagesEditing of data inline and in a dedicated spaceConvenient navigation among dataCustom filters for table contents or query results, including filters based on cell valuesResults ordering by columnData export with all applied filters and orderingsGeneration of SQL statements based on selected rowsBasic 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:
NumbersRandom stringsNamesAddressesCredit cardsDomains and IP addressesCustom regular expressionsFlexible numeric generatorsAnd many more
SQL editor
Organization of scripts into folders and reassignment of database connections for particular scriptsSQL syntax highlighting determined by the database associated with a scriptSupport for different sets of reserved keywords and system functions for different databasesImport and export of scripts
Visual Query Builder
You may construct complex SQL queries without actual knowledge of SQLMake table joins/filtering/ordering visuallyOpen you existing SQL queries in visual mode, edit and save them - that's easyExecute your visually constructed query at any moment and get results on the screenAnalyze 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 capabilitiesDisplay of database objects` DDL and generation of standard SQL92 DDL according to object structure for some databasesAbility to edit/rename/delete connections and most database objectsGlobal 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 existSupported file formats: CSV, HTML, XML, JSON, XLS, XLSXImport data directly from CSV file into database table. Setup columns mapping and data types in convenient wizardsSave your data transfer configurations as tasks and run them in one clickSchedule 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 visibilityExport 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/viewsMetadata search among rows in database system tablesAbility 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 reportsDDL alter scriptsDiff diagramLiquibase chagesetsDatabase structure synchronization can be performed