Sunday, July 13, 2025

Oracle DB MCP server - OracleCL, few links

 Last week Oracle has announced the availability of Oracle DB MCP server, joining the general hype of MCP servers rather fast. Most of the materials were published by https://x.com/thatjeffsmith and https://x.com/krisrice. All I do here is gather few links from the webcasts and X for future use.

The MCP server is part of Oracle SQLcl. It should work with all supported Oracle DB versions (On-Prem. & Cloud), meaning 19c and up.

If you want a general MCP intro: https://modelcontextprotocol.io/introduction 


There were 2 webcasts. The first (and longer) one covers everything that was covered in the introduction one, so I advise watching it only. 

Introducing SQL Developer Copilot Integration in Microsoft VSCode & MCP Support for Oracle Database: https://youtu.be/hj6WoZVGUBg?si=9C58_wcDBE9wkruT (1 hour).

The shorter - Oracle Developer Coaching: July News Edition https://youtu.be/Xnmty5_-v-M (33 min)

Screenshots from the webcasts:









Links and Resources:

Latest version of Oracle SQLcl download link:  

https://www.oracle.com/uk/database/sqldeveloper/technologies/sqlcl/download/

or direct link to the 25.2 version https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-25.2.0.184.2054.zip 


Documentation: https://docs.oracle.com/en/database/oracle/sql-developer-command-line/25.2/sqcug/using-oracle-sqlcl-mcp-server.html


Example MCP Clients: https://github.com/punkpeye/awesome-mcp-clients

Example MCP Servers: https://github.com/punkpeye/awesome-mcp-servers

AI for code tooling: https://github.com/oracle-samples/ml4code/tree/main/08_tooling


A blog on the subject by Hamza Eraoui: SQLcl MCP Server: Tips, Tricks, and Use Cases | by Hamza Eraoui | Jul, 2025 | Medium

And an intro by Paulo Portugal: Oracle SQLcl MCP: Bringing AI to SQL with Model Context Protocol




and what looks like oracle internal ref. https://ml4code.oraclecorp.com/libs/#mcp










No comments:

Post a Comment