Download DBeaverUltimate 25.0.0

- File drivers:
- Added new drivers for working with files as databases:
- XML driver
- JSON driver
- Multi-source driver – allows you to combine files of different formats into a single database and join data from multiple files using a single SQL query
- Added the ability to open Parquet files from the cloud storage
- Added support for geospatial data types
- File opening dialog was completely redesigned
- SQL Editor:
- New autocomplete engine was significantly improved and enabled and enabled by default
- The new engine was renamed "Semantic", while the previous engine is now called "Legacy"
- Added the ability to use multi-line variables in SQL scripts.
- Changed default shortcuts for the Result set zoom to Alt+0 and Alt+9 to avoid conflicts with European keyboard layouts
- AI assistant in SQL editor was improved:
- Write "@ai" in the SQL Editor, and describe what you need in natural language — AI will instantly generate a ready-to-use query
- Query manager: Added the ability to filter queries by data sources and date range
- Data Editor:
- Hints were completely redesigned:
- Depending on the data type, cell hints display information about foreign and primary keys, array elements, binary data size, geometries, and timezones
- Using hints, you can also navigate to related tables
- Column hints continue to display information about keys and column status, but they have been redesigned for better readability
- All hints can be configured on the Context menu
- Added backslash escaping when generating scripts
- Added an option in the Value Panel to save XML and JSON files in compressed format
- Added support for the composite types for the Grouping panel
- Data transfer:
- Added the ability to use default spreadsheet names (e.g. Sheet0, Sheet1) for exporting to XLSX
- Export to CSV:
- Added an option to replace line break characters
- Added an option to choose {}, [], or () brackets for formatting array data in the exported file
- Connectivity:
- Added the ability to retrieve database credentials securely from the AWS secret manager and HashiCorp Vault secret provider
- The product now supports importing certificates from a predefined folder at startup
- Cloud Storage:
- Double-clicking on a file in Cloud Storage will open that file in DBeaver, allowing you to work with it as with a database
- Supported formats: .csv, .json, .xml, .xlsx, .xls, .parquet, .sql, .db, .sqlite, and .sqlite3
- Security: Master password configuration page was redesigned for a better user experience
- General:
- The bottom toolbar now features breadcrumbs, showing the hierarchical path to the open entity in the active connection (e.g., a specific table)
- Added the ability to associate different file types with DBeaver on Windows, and open them directly from OS file explorer or with Ctrl+O shortcut
- Databases:
- Added the ability to edit DDL for Oracle and MySQL jobs
- BigQuery: Added an option to enable session mode
- MySQL and MariaDB: Added the ability to change expired password in the user interface
- Oracle:
- Added support for the SQL Plus ACCEPT keyword
- Added the ability to change user passwords
- Users with sufficient permissions can create and clone other users
- Now, there are two Redshift drivers:
- the default Redshift, which is stable and offers better performance,
- and Redshift Serverless, which can be used to connect to the serverless database
- Microsoft Access and MySQL driver has been removed from the package
- Added many improvements for different databases
- New database drivers added:
- Cloudberry
- Databend
- Driver updates:
- Google BigQuery was updated to version 42_1.5.4.1008
- Jennifer to v5.5.3.2
- Machbase to 8.0.2
- MariaDB to 3.5.2
- SQLite to 3.48.0.0
- Snappy to 2.11-1.3.0
- Spanner to 2.15.5
- Teradata to 20.00.00.38
- For InterSystem IRIS, OrientDB, and Salesforce Data Cloud, the latest driver version is now downloaded by default