Oracle SQLcl 26.1.0 Release Notes

Oracle SQLcl 26.1.0 Release Notes

April 2026

 

New Features

    SQLcl MCP

    • Schema-information tool now supports filtering and ability to retrieve details for other schemas
    • New prompts
      • connection helper
      • develop ORDS REST API

     

    CI/CD Projects

    • Now supports schema substitution, allowing you to export objects with a schema prefix and deploy them into a different schema
    • Project stage now handles dependent objects more reliably during drop‑and‑recreate flows (for example, preserving related indexes and grants when a base object such as a materialized view is recreated)
    • Now includes scheduler job arguments and program arguments in export and stage operations, expanding support for Oracle Database Scheduler objects
    • Cleaner hotfix releases with new selective controls (-include/-exclude), enabling you to choose exactly which changes ship and automatically generate a focused changelogncludes scheduler job arguments and program arguments in export and stage operations, expanding support for Oracle Database Scheduler objects

     

    General

    • New DIFF command compares a source and target database connection, detects schema drift, and generates the DDL changes needed to synchronize the target
    • Enhanced LOAD XLS adds support for quoted identifiers and column reordering; the SQL Developer Extension for VS Code now also shows richer worksheet preview details
    • New connection export/import supports SQLcl connection definitions
    • OBJECTSTORAGE now supports listing and deleting objects in OCI Object Storage buckets, expanding SQLcl’s built‑in access to bucket contents
    • ORAPKI now supports certificate download, simplifying Oracle PKI wallet setup

 

Bugs Fixed

  • Project export omitted identity‑column attributes, role grants, system grants, and other required metadata
  • Project stage could generate incorrect diffs, duplicate changelog entries, or invalid output for specific object types
  • Fixed terminal input handling, including backspace behavior and line‑number display
  • Fixed tab completions in connection handling and connection‑parameter processing

 

Supported Java Versions

Supported Java Versions

  • Oracle Java 17
  • Oracle Java 21
  • Oracle GraalVM Enterprise Edition for Java 17
  • Oracle GraalVM Enterprise Edition for Java 21
Note: JavaScript support requires GraalVM for Java 17 with the JavaScript Runtime plugin