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!

Cookbook for SQLcl MCP with Copilot or Any Other LLM

astergerOct 28 2025 — edited Oct 28 2025

19.28 database and SQLcl 25.3 installed on OEL 9. I want to use SQLcl in MCP mode to query a read-only standby database.

Of the two MCP modes listed in SQLcl 25.3 documentation, I tried the Claude-desktop approach however could not get Claude.ai to install via email method with two different Windows 11 installs. The other MCP mode using VS Code won't work for me as I am a DBA not a developer so have no reason to purchase Visual Studio.

I do have a networked Windows 11 machine with a new MS Office subscription that includes Copilot. Thus, my reason to use Copilot versus Claude.

Anyone have the implementation details?


Comments
Post Details
Added on Oct 28 2025
3 comments
95 views