Welcome to my blog post series on Oracle's SQLcl, your go-to resource for this free command-line tool. 💡 This article will serve as the hub for all things SQLcl, guiding you from the basics to advan
Have you ever changed a database object in a shared Oracle development database, only to discover the next day that somebody had overwritten your work? Yeah, we’ve all been there. Git is great. CI/CD
If you’re building APEX apps, SQLcl 26.3 just gave you a powerful, built-in security and code quality checker. I’ve already written about using SQLcl CodeScan to analyze PL/SQL code for violations and
How many times a day do you re-type the exact same SQL queries? Whether it is checking system time, finding out which employees earn way too much, or running a complex query to check active database s
Recently, we migrated ten APEX apps from APEX 22.1 (on-premise) straight to APEX 26.1 (Oracle OCI), but we lost all public and private reports saved by users in the production versions of the apps. Oo
The SKILLS command in SQLcl installs or updates the latest skills for your AI agents (since SQLcl 26.1). Check existing AI skills Log in to SQLcl ( you don't need to be connected to any database)
In one of my latest blog posts about customising SQLcl, I promised to show how to set it up once and forever. What can we do instead of typing those commands each time? SQLcl allows you to set a s
What should we do to be sure of what AI can do using the SQLcl MCP server and what data is accessible to it? Are there any extra security precautions we could take in case AI go crazy? That's exactly
In this short guide, I’ll show you how to quickly add an SQLcl-based MCP server in Visual Studio Code so you can start “talking” with your Oracle Database using AI. No complex setup, no huge framework
