PPlamen MushkovOct 14 · 6 min readOracle 26ai AssertionsThe use case I recently had an interesting problem, that couldn't get resolved by a simple foreign key constraint. A key in one of our tables could have come from any of two other tables. And it shoul1Kblog.apexapplab.dev
RRafal GrzegorczykSep 30 · 11 min readGive Your Oracle APEX Apps a Quality Boost with SQLcl CodeScan 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 andrafal.hashnode.dev
TTimo HerwixSep 4 · 12 min readBuilding my Oracle APEX 26.1 AI Playground with Oracle AI Database 26ai, ORDS, SQLcl, Codex, MCP and APEXlangIntroduction Over the last few days I wanted to build a personal Oracle APEX playground for experimenting with modern AI-assisted development workflows. My goal was simple: Oracle AI Database 26ai Frtm-apex.hashnode.dev
RRafal GrzegorczykAug 27 · 3 min readSQLcl has built-in code snippets (ALIAS command). Because you can't remember everything, right?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 srafal.hashnode.dev
MMatt MulvaneyAug 24 · 2 min readAPEXLang + Windows? Add this one Git settingExcited to play around with APEXLang or SQLcl Project? What are you going to do? Vibe Code some APEXLang Export / Import APEX apps Project Export your schema Sounds fun right? By the experiences mattmulvaney.hashnode.dev
MMatt MulvaneyJul 17 · 8 min readEnhancing SQLcl Terminal in VSCodeIf you use the SQL Developer for VS Code extension, it will install the latest version of SQLcl in VS Code. Sounds great... right!? Actually, no, not great. Why? For three reasons SQLcl starts inmattmulvaney.hashnode.dev
AAdrian KurJul 13 · 6 min readOne Repo, Many Schemas: Making SQLcl Aware of Where You AreA single repository can easily contain several independently deployed Oracle schemas. That structure works well for version control and CI/CD, but it introduces a small, persistent developer-experiencmilesofcode.hashnode.dev
RRafal GrzegorczykJun 24 · 4 min readHow to securely connect MCP to the database (using Oracle DB 26AI and SQLcl) ?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 rafal.hashnode.dev
RRafal GrzegorczykJun 24 · 4 min readCustomise SQLcl using an auto-run script on each connection. Set it and forget it! 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 srafal.hashnode.dev
RRafal GrzegorczykJun 23 · 2 min readHow to quickly add SQLcl MCP Server to Visual Studio Code?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 frameworkrafal.hashnode.dev
