CloudBeaver AWS

Changes since 25.1: Security:

• Added the Force HTTPS mode setting in Server Configuration to enforce redirecting from HTTP to HTTPS. It helps avoid a potential man-in-the-middle attack. This setting is turned off by default. Please remember to configure the proxy before enabling.
• Added the Bind session to IP setting in the Server configuration to improve session security by linking user sessions to their IP address. It is disabled by default for all domains except *.databases.team domains. When enabled, this helps protect against certain types of session hijacking attacks, where an attacker could try to take over a user session. Note: Users will be logged out automatically on the IP address change (switching networks or using mobile data).
• Redesigned the brute force protection mechanism: repeated failed login attempts now temporarily block the connection. The policy remains configurable via the configuration file. Also, more database support was added for this feature: Oracle, SQL Server, MySQL, Db2, and others.
• Added support for securely retrieving database credentials from the CyberArk secrets provider using API key authentication.

Administration:

• Added support for multiple server URLs to accommodate different access policies for internal and external users, improving flexibility in network-restricted environments. To set it up, use the Allowed Server URLs field in the Server configuration within the Administration section.
• Introduced team-level permission management in the Users and Teams section. Administrators can now define granular permissions for editing, copying, importing/exporting data, and executing SQL scripts per team. Global defaults can be set on the Global Permissions tab in the same section.
• The built-in server CLI now supports executing GraphQL operations, facilitating automation in CI/CD and headless environments. This enhancement enables administrative operations - such as user import, server configuration or connections creation.
• Improved audit logging to capture key system events, including connection management, license changes, user interactions with cloud storage files, and SQL script operations. It can be enabled in the Administration settings > Logger. Logs are stored on the server. They are also available through API for integration with third-party log systems.
• Added the ability to configure log retention period (in days) in Administration Settings > Logger.
• Added the ability to import a license key in a headless mode through the configuration file.
• Additional validation of the administrator password was added during the initial server configuration.

AI Assistant

• AI Chat was added to help users generate and fix queries and explore data more easily. It is integrated with the SQL Editor to run generated queries instantly. Access it from the Tools menu in the top toolbar. All AI features can be turned off in the Server configuration.
• The Change scope option was added to the AI Chat to improve accuracy, especially in databases with large schemas. This feature allows users to limit the context to specific database objects.
• The new Fix with AI button appears for errors in the Result Set. Click it to ask AI for help fixing the SQL error.
• The Explain query in AI option is now available in the SQL Editor left toolbar. Use it to get AI insights and improve user queries.
• Users will see the Describe Object with AI command in the context menu for schemas, tables, views, and other database objects in the Navigator view. The AI-generated explanations help quickly understand any object structure, purpose, and usage.
• Copilot has been added to the list of supported AI engines.
• Administrators can now adjust prompt context using the new Context window size setting in the Administration panel for OpenAI and Azure OpenAI engines.

SQL Editor:

• Changed the default engine used for autocompletion in the SQL Editor. This Semantic engine offers improved suggestions for database objects, keywords, and functions. You can switch back to the Legacy engine in Preferences > SQL Editor.
• A Clear button was added to the output panel.

Data Editor:

• Column descriptions were added under column names in the Data Editor to provide more metadata context. You can disable this in Preferences > Data Viewer.
• Added an ability to review the script before execution when users edit tables without primary keys.
• Fixed an issue that prevented selecting all table data by clicking the top-left corner cell.

General:

• A new welcome screen was added when opening the application. It includes quick shortcuts to create a new connection, open SQL Editor, AI Chat, or documentation.
• Introduced a search and replace panel in the SQL Editor and Value panel. Press Ctrl/Cmd + F to search using keywords or regular expressions.
• Changed the data transfer mechanism to avoid intermediate file creation. The parameter dataExportFileSizeLimit was removed from the server configuration as deprecated.
• CloudBeaver now defaults to the system theme (light or dark). Users can change it in Preferences > Theme.
• Added the option to display tabs across multiple rows, allowing you to see all tabs without scrolling. You can enable this in Preferences > Interface.
• Improved dark theme accessibility by enhancing color contrast across the app for better readability and compliance with accessibility standards.
• The database navigator now automatically hides empty folders in shared projects, reducing clutter and making it easier to find active connections.

Databases and drivers:

• AWS RDS for MySQL and PostgreSQL: added the ability to connect via local host and port forwarding.
• Azure Cosmos DB for NoSQL database support was added.
• BigQuery: Added ML models presentation to Navigator and Metadata Editor.
• Clickhouse: fixed the presentation of tuples and map data types in the Data Editor.
• Clickhouse: driver has been updated to version 0.8.5.
• CUBRID: added support for sharded database connections.
• Databend database support has been added.
• Db2: added support for authentication with Kerberos.
• DuckDB: driver has been updated to version 1.3.
• File drivers: administrators can now add additional Parquet libraries (like Snappy or Zstandard) to the Files Multi Source or Parquet drivers.
• LibSQL: connection configuration issue was fixed.
• MongoDB: restricted connections with enabled authentication when the auth mechanism is set to NONE.
• MySQL: improved performance when retrieving foreign keys metadata.
• PostgreSQL: fixed misplaced comment for table DDL generation.
• TimechoDB/IoTDB database support was added.