SQLcl: MCP Server & SQL Prompt

Hello,

• Java: 21.0.8
• sqlcl: 4.3

I am able to run this command successfully, and it generates files in xml as expected

SQL> liquibase generate-schema -split

However, this one, which is supposed to generate the same files in SQL format, fails:

SQL> liquibase generate-schema -split -sql

This is what I get:

--Starting Liquibase at 2025-10-20T16:24:59.484524100 using Java 21.0.8 (version 4.30.0 #0 built at 2025-04-01 10:24+0000)

Export Flags Used:

Export Grants           false
Export Synonyms         false

[Method loadCaptureTable]:

[Method loadCaptureTable]:                            4ms
        [Load Type SEQUENCE]:                    3s 572ms
        [Load Type TYPE_SPEC]:                   3s 572ms
        [Load Type DIRECTORY]:                       12ms
        [Load Type MATERIALIZED_VIEW]:               78ms
        [Load Type TYPE_BODY]:                       44ms
        [Load Type MATERIALIZED_VIEW_LOG]:           44ms
        [Load Type DIMENSION]:                      133ms
        [Load Type REF_CONSTRAINT]:                  21ms
        [Load Type PACKAGE_SPEC]:                    65ms
        [Load Type FUNCTION]:                        47ms
        [Load Type PROCEDURE]:                       40ms
        [Load Type DB_LINK]:                         27ms
        [Load Type SYNONYM]:                         66ms
        [Load Type TRIGGER]:                        623ms
        [Load Type CLUSTER]:                         43ms
        [Load Type PACKAGE_BODY]:                    67ms
        [Load Type JOB]:                             40ms
        [Load Type INDEX]:                          452ms
        [Load Type VIEW]:                        3s 307ms
        [Load Type TABLE]:                       4s 723ms
Exception in thread "writeService-Thread-01" java.util.concurrent.RejectedExecutionException: java.nio.file.InvalidPathException: Illegal char <:> at index 75: c:/Users/myuser12345645/MyFiles/D/learning/liquibase_tutorial/database/hr\c:\Users\myuser12345645\MyFiles\D\learning\liquibase_tutorial\database\hr\comment_1\countries_comment.sql
        at java.base/sun.nio.fs.WindowsPathParser.normalize(WindowsPathParser.java:204)
        at java.base/sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:175)
        at java.base/sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:77)
        at java.base/sun.nio.fs.WindowsPath.parse(WindowsPath.java:92)
        at java.base/sun.nio.fs.WindowsFileSystem.getPath(WindowsFileSystem.java:231)
        at java.base/java.nio.file.Path.of(Path.java:148)
        at java.base/java.nio.file.Paths.get(Paths.java:69)
        at oracle.dbtools.raptor.liquibase.util.LbFileUtils.getFile(LbFileUtils.java:226)
        at oracle.dbtools.raptor.liquibase.generator.changesets.data.ChangeData.setFileNames(ChangeData.java:119)
        at oracle.dbtools.raptor.liquibase.generator.changesets.data.ChangeData.setObject(ChangeData.java:91)
        at oracle.dbtools.raptor.liquibase.generator.SchemaGenerator.getWork(SchemaGenerator.java:415)
        at oracle.dbtools.raptor.liquibase.generator.SchemaGenerator$6.runJob(SchemaGenerator.java:481)
        at oracle.dbtools.raptor.liquibase.service.LbRunnable.run(LbRunnable.java:37)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
        at java.base/java.lang.Thread.run(Thread.java:1583)

Few observations

• The command above connects to ADB on OCI from my local machine

• I run the commands from the directory c:\Users\myuser12345645\MyFiles\D\learning\liquibase_tutorial\database\hr\

• I notice the illegal character is at the beginning of the path which uses backward slash (unlike the other path which uses forward slash). I am not sure whether these two paths should be used, or do they indicate some kind of erroneous config:

  Illegal char <:> at index 75: c:/Users/myuser12345645/MyFiles/D/learning/liquibase_tutorial/database/hr\c:\Users\myuser12345645\MyFiles\D\learning\liquibase_tutorial\database\hr\comment_1\countries_comment.sql
  

• I previously installed the standalone liquibase, and I can connect to DB using the standalone version. I couldn't find an equivalent command like generate-schema to try with the standalone version

• There is also an Oracle DB installation on my local machine

Any idea what could be wrong here? or where to start looking?