Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl project: Support for schema name as a variable?

M. Tr.Oct 9 2025

Hi everyone,

Currently, schema names are hardcoded in my SQLcl project. I'm wondering if there's any plan to support variable replacement similar to how Liquibase handles it—particularly for schema names.

In my Liquibase setup, I can specify the schema name using an environment variable at runtime (e.g., when running the liquibase update command). I was thinking of using a workaround in SQLcl by replacing the schema name with a placeholder like ${SCHEMA_NAME} and then setting the value using set property.

Is there a better or more recommended approach for this in SQLcl?

Thanks in advance!
Best regards,
Markus

Comments
Post Details
Added on Oct 9 2025
1 comment
64 views