Using SQLcl MCP server to check schema grants provided when creating new APEX workspace.
My Likely Obvious Oracle Tip #7
wsowa.hashnode.dev/the-likely-o...
#SQL #oracleace #orclapex #OracleDatabase #sqlcl
And if you've taken this LiveLab, how did you like the prompts? How did they work out for you? Were the results what you were expecting? And how are you using prompts in your daily database admin/developer workflows today?
#ai #agents #sqlcl #cline #agentic #llms #mcp #mcpserver #sqldeveloper
10 Seconds to get the #Oracle #SQLcl prompt in OL9 running in @microsoft.com WSL2? Oracle SQLcl on WSL2: Fixing the 10-Second Startup Delay - www.martinberger.com/2026/01/orac...
Best Christmas 2025 present ever! 🙌
The new #SQLcl release brings a tiny but mighty new feature! Goodbye pesky little line numbers! 🧹
A shoutout to the SQLcl Dev team to get this in! 👍
Creating AI Agents with LangChain4j, Model Context Protocol, Oracle SQLcl MCP Server, and the Oracle AI Database 26ai rb.gy/w4g6zl #Java #GenAI #LangChain4J #JavaOracleDB #SQLcl #VSCode #OracleDatabase #Oracle
I keep reviewing this SQLcl MCP Server LiveLab as new Tools are added and as LLM models mature. Today, the prompts in the LL are (see GIF). Review the lab and test the prompts with your favorite LLM API provider before I change them up again! livelabs.oracle.com/ords/r/dbpm/...
#LLMs #AI #MCP #SQLcl
SQLcl meets Claude Desktop! 💡 See the powerful, step-by-step guide to setting up the MCP server to unlock AI analysis for your #Oracle Database schema, metrics, and best practices. Start playing now: bijoos.com/oraclenotes/... #SQLcl #GenAI #OracleDB
Was kann eigentlich #SQLcl?
@martindba.bsky.social hat im letzten #DevTalk erklärt, wie sich das Tool zu einem echten Kommandozeilen-Powerhouse entwickelt hat, inkl. Schnittstelle zur Kommunikation zw. Sprachmodellen & Datenbanken. 🤖💬
📅 Nächster DevTalk: 13.11. #DOAGDevs #Oracle #AI #DOAG
My #SQLcl stopped working:
/opt/homebrew/Caskroom/sqlcl/25.3.0.274.1210/sqlcl/bin/sql: line 853: /usr/libexec/java_home -v 17/bin/java: No such file or directory
Upgraded from Java 17 to 21 now it works again 👍. Weird error don't know if just my Java installation broke.
Today I revisited a 4yo post on one of SQLcl’s underrated features: autotrace — shows full session stats for a SQL statement (way beyond SQL*Plus). Still works in latest release. Updated prereqs too. More details here
🔗 martincarstenbach.com/2021/06/10/s...
#Oracle #SQLcl #performance #IKYK
Please read my latest post, where I explore how the Oracle SQLcl MCP Server can help you build higher-quality APEX Apps more quickly. #orclAPEX #mcp #sqlcl
blog.cloudnueva.com/oracle-sqlcl...
🚀 New Blog
🔄 Transfer SQLcl connections from one PC to another with ease! 🔗 Or want to share a SQLcl connection? 🤝
#orclapex #sqlcl
mattmulvaney.hashnode.dev/transfer-sqlcl-connections-from-one-pc-to-another
The #SQLcl #GitHub action just received an update.
There's no longer a need for the versions.txt file and you can pick up versions as long as they are live on oracle.com.
However, the recommendation remains to just use "latest".
github.com/marketplace/...
Our July issue of #oracledatabase Monthly News is now online! As always, the 7-person team, including myself, has put together interesting news from the last four weeks and compiled it for you.
#oraclecloud #ai #updates #sqlcl #exadata #multicloud #certification
blogs.oracle.com/coretec/post...
Short video demonstrating the use of natural language to interact with an Oracle 23ai Database using the new Oracle #SQLcl Model Context Protocol #MCP and #Claude youtu.be/jnRG7q9kiUg?si… @oracleace.bsky.social #ACED
Just published a new Medium post on SQLcl MCP Server!
Learn how to monitor its activity, apply essential security guidelines, and explore the Auto-Correction capability.
#SQLcl #MCP #AI #OracleDB
medium.com/@hamzaeraoui...
Just talked to my #Oracle database in plain English and it actually understood me. The secret? Oracle #SQLcl 25.2's new #MCP server + #Cline AI assistant in #VS Code.
medium.com/@DatabaseDou...
New blog post:
✅ What is the #SQLcl #MCP server
✅ How does it work under the hood
✅ Security concerns
✅ Tools vs. MCP
hartenfeller.dev/blog/demysti...
#oracle #orclAPEX
On a downside what hasn't changed is #SQLcl still defaults to thick connection on Windows, even with no client present in path/env, while on Linux it's opposite. Why? 🤷♂️
Reported it also in the same SR to no effect...
For reference this thread describes my initial findings: bsky.app/profile/pewu...
Another thing worth to mention is #SQLcl now seems to be not so much dependant on JDBC driver version when using thick connection and works with any 23 client (tested IC 23.5-23.8) as long as it's in the path. I don't find the selected excerpt from release notes to be true, it doesn't work that way.
Finally, after 8 months of waiting the #SQLcl 25.2 release fixes this issue.
It took me great effort to fill the SR, deal with the clueless person handling it for several months, escalate, etc. to reach this goal. To just get back to where it was working in 24.1.
Should be happy but I'm more tired.
Is it possible to deploy an Oracle Autonomous Database on your laptop with a management interface like OCI?
Yes. Here it is.
dincosman.com/2025/06/18/d...
#Oracle #AutonomousDatabase #OracleATP #Docker #OracleDeveloper #DevOps #OracleCloud #DatabaseActions #ORDS #SQLcl #DB
🚀 SQLcl is now an MCP Server 🚀
Stay tuned — the official release (25.2) is coming soon! 👀
#SQLcl #MCPServer #OracleDev #NaturalLanguageQuery #DevTools #SQL #LLM
Relying on Liquibase rollback? That might be your riskiest move. 💥
Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR.
👉 danmcghan.hashnode.dev/the-problems... #orclAPEX #OracleDB #sqlcl #DevOps
Autonomous Database Learning Lounge series presents: Build CI/CD pipelines with Autonomous Database and Oracle SQLcl Project
Attention #Developers! Did you know you can create #CI/#CD #pipelines on #AutonomousDatabase? Join us next week: apexadb.oracle.com/ords/r/tech/...
Easily build and manage CI/CD pipelines using #SQLcl with #ADB.
#adblearninglounge @thatjeffsmith.com @autonomousdb.bsky.social
What's wrong with my #Oracle SQLplus? #SQLcl works just fine. And why does the "to_char" return an error? I'm confused. /cc @oracleace.bsky.social
SQLcl v25.1.1 is now available on www.oracle.com/database/sql... which resolves (at least) one very important bug when you’re working with “project” and APEX.
#orclapex #sqlcl #project
Best fix/feature in #Oracle SQLcl 25.1.0 : When you change the contents of a file (e.g. a package body), "project stage" will automatically reformat the code and update the hash. No need to export it from the database again!
#sqlcl #cicd #orclapex
While the download page of SQLcl still mentions 24.4.4 ... when you click the "latest version link" you'll get version 25.1.0!
And this version has some important improvements for the "project" feature ;-)
#sqlcl #orclapex
Excellent Idea! Need to explore this ASAP.
Did anyone ask for this in SQL*Plus as well ?
And Statspack ?
(I'm using scripts evolved over many years and many versions back: snap, list, spool)
#SQLPlus
#SQLcl
#statspack
/cc @connormcd.bsky.social