Released: Mar 22, 2026

17.0.0 での更新項目

機能

• Support for Oracle 23ai SQL Domains
  • KeepTool now fully supports SQL domains introduced in Oracle Database 23ai:
    • A new Domains page displays single- and multi-column domains, as well as flexible and enumeration.
    • Detail pages show domain columns, constraints, and usage in table definitions.
    • Context menu options are available to manage SQL domains.
    • The Tables - Columns grid now includes information about SQL domains used in column definitions.
    • Reverse DB now generates DML statements for domains.
• New Oracle 23ai Data Mining Models Page
  • A new Oracle 23ai Data Mining Models page has been added. This page provides a foundation for visualizing and managing Oracle 23ai model metadata.
• Schema Annotations for Oracle 23ai
  • KeepTool has introduced basic support for Oracle 23ai schema annotations:
    • The Tables - Overview context menu includes a new Schema Annotations option.
    • Maintain annotations for tables, views, and columns directly from this interface.
    • The Overview and Columns grids now display annotations alongside traditional comments.
• SQL Rewrite Enhancements
  • Added a new Rewrite SQL submenu which consolidates and extends SQL conversion tools:
    • The former item "Rewrite Oracle proprietary joins to ANSI SQL compliant joins..." has been moved into this submenu.
    • Two new rewrite tools have been added:
      • Rewrite SQL for PostgreSQL.
      • Rewrite SQL for MS SQL Server.
    • Both perform ANSI SQL conversions and apply syntax adjustments for their respective targets.
  • A new "Replace Identifiers using Dictionary" tool automates global word replacement based on a user-defined CSV file—ideal for translating table or column names for internationalization.
• AI Assistant
  • KeepTool now supports AI integration with the following engines: OpenAI, Claude, Gemini, and Llama. The Assistant helps you to create or change SQL or PL/SQL with the help of Artificial Intelligence (AI).
  • KeepTool follows a Bring Your Own API Key approach: next to the API key field you'll find a link that takes you directly to the relevant provider page.
  • Each editor window includes a new context-menu entry, AI Assistant. It opens the AI Assistant dialog and automatically inserts a copy of the currently selected text from the editor.
  • The dialog also provides a template selector for AI command templates stored in a repository. KeepTool ships with several preconfigured templates. Each template includes a name and a set of commands. After selecting a template, its command is copied into the command box. In most cases, no changes are required, but you have the option to modify the command.
  • Click Send to submit the command to the selected AI engine. The response is displayed in two areas:
    • The updated SQL appears in the lower editor pane.
    • Explanations and notes appear in the memo pane on the right.
  • You can use Diff to visually compare the updated SQL with the original.
• Data Grid Improvements
  • The Insert Copy feature now excludes primary key values when duplicating rows, preventing accidental key conflicts.
  • The Search database for string option has been renamed to Search database for value and now also supports numeric searches (for example, primary key lookups).
  • The Insert Copy menu items in both the Data Content grid and the SQL Query Resultset grid have been renamed to Duplicate Row to follow common naming conventions.
  • The Data Content grid now displays the content of Nested Table columns based on an Oracle PL/SQL type definition.
  • You can use the small arrow button on the left side of the data grid to expand the nested table detail grid.
• PostgreSQL DDL Conversion
  • KeepTool-16 added a new context menu item "DDL for PostgreSQL DB" to the tables page. It creates DDL for tables, constraints, comments and triggers using the correct syntax for PostgreSQL database.
  • KeepTool-17 adds similar menu items for the following database objects:
    • Views.
    • PL/SQL procedures, functions and package bodies.
    • Sequences.
    • Schema - Policies.
    • Privileges.
  • This tool converts Oracle package bodies, procedures, functions, sequences and policies into PostgreSQL syntax.
  • While most transformations are automated, minor manual adjustments may still be required.
  • When generating DDL for table migrations, Hora automatically creates comments for each constraint.
  • These comments can be leveraged to implement generic, constraint-based error messaging in applications.
  • You can refine them into more natural, user-friendly messages, e.g., by replacing database table names with business-friendly entity names.
• User and Privilege Management
  • The Users - Proxies page now includes two new actions:
    • Grant connect through / Add proxy.
    • Revoke connect through / Remove proxy.
  • Show DDL now includes proxy user grant information.
  • The Schema - Object Privileges grid has introduced a new Flags column for color-tagging database objects.
• ORDS | Handlers Page
  • A new Show Origins button has been added to the ORDS | Handlers page. This feature works similarly to the Copy Base Table Column Comments to View Columns action available in the Tables/View | Columns data grid.
  • When triggered, it analyzes the SQL query of the selected ORDS handler and displays how the exposed REST properties map to the underlying table columns. The SQL analysis does not stop at view columns; it continues tracing through views down to the original base table columns, allowing you to easily identify the true data sources behind the REST properties.
• Additional Enhancements
  • The Show DDL menu item now supports multi-selection on both the Database Links and Schema - Policies
    • Added support for the BOOLEAN data type in Direct TCP/IP connection mode for Oracle 23 and later.
    • Added support for passwords longer than 30 characters in Direct TCP/IP connection mode for Oracle 23 and later.
• CodeMeter Note
  • CodeMeter Runtime Version 8.20 or later is now required on the network license server.