#SQLcl
LightNews LightNews
richardsenko.bsky.social
Can Codex modify an existing Oracle APEX app?

I tried it with SQLcl MCP + APEXlang: schema inspection, page edits, validation, and import. Also sharing a real-world MCP autocommit pitfall.

#OracleACE #OracleAPEX #SQLcl

richardsenko.com/getting-star...
Getting Started with Codex, SQLcl MCP and APEXlang for Oracle APEX Development
Using Codex, SQLcl MCP and APEXlang to update an existing Oracle APEX application, validate the changes and import them with SQLcl.
richardsenko.com
November 6, 2026 at 4:10 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Dealing with TNS database connections with Oracle MCP (SQLcl)
Dealing with TNS database connections with Oracle MCP (SQLcl)
www.thatjeffsmith.com
November 8, 2026 at 5:40 AM
connormcd.bsky.social
Previously on the blog. First dabblings with SQLcl MCP server. https://connor-mcdonald.com/2025/07/14/first-dabblings-with-sqlcl-mcp-server/
November 8, 2026 at 6:08 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Configure SQLcl MCP for Codex: Connecting to Oracle FreeSQL.com
Configure SQLcl MCP for Codex: Connecting to Oracle FreeSQL.com
www.thatjeffsmith.com
November 7, 2026 at 5:36 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
Example: Loading Chicago Crime Data (CSV) with SQLcl
www.thatjeffsmith.com
November 5, 2026 at 9:41 PM
pdevisser.bsky.social
Today, I had to ping this webpage to a cstmr, again...

Them: "We cant install SQL-Developer and SQLcl at customer - because oracle may want to charge for a license..."

me: Please Read This Page:
www.oracle.com/database/tec...

Idem: VSCode, SQLcl...

cc
@thatjeffsmith.com
@oracleace.bsky.social
www.oracle.com
November 4, 2026 at 4:27 PM
thatjeffsmith.com
Previously on @thatjeffsmith... RAG for your agents: use existing Oracle vectors via SQLcl MCP
RAG for your agents: use existing Oracle vectors via SQLcl MCP
www.thatjeffsmith.com
November 3, 2026 at 9:37 PM
bsky-matt.0code.io
Oracle SQLcl 26.3.1 is now released 🎉

12x Fixes: APEX/APEXlang exports & CodeScan, Recovery Service JSON output & jobs, Kerberos prompts, OCI/JDK 17 wallets, Liquibase paths, redo transport & SYSOPER setup, trigger WHEN formatting, Windows LOAD paths+more

#orclapex

www.oracle.com/database/sql...
Oracle SQLcl Download
Explore the comprehensive resources related to SQLcl, a command-line tool for Oracle Database. Access downloads, documentation, release notes, and related products to enhance your database management…
www.oracle.com
November 4, 2026 at 9:34 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Using SQLcl MCP to generate and consume annotations for better NL2SQL
Using SQLcl MCP to generate and consume annotations for better NL2SQL
www.thatjeffsmith.com
October 31, 2026 at 12:38 PM
jon.cloudnueva.com
Testing. Probably something I should have mentioned in the post. AI helped with creating the test cases also but you again need to know what good looks like there. Because Codex had access to the DB also via SQLcl MCP it could run and check tests.
October 30, 2026 at 12:26 PM
thatjeffsmith.com
Previously on @thatjeffsmith... How to compare two Oracle Database schemas with SQLcl
How to compare two Oracle Database schemas with SQLcl
www.thatjeffsmith.com
October 27, 2026 at 8:41 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Ingest, chunk, vectorize, and load VecDB Tables with SQLcl Model command
Ingest, chunk, vectorize, and load VecDB Tables with SQLcl Model command
www.thatjeffsmith.com
October 26, 2026 at 8:39 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
Getting started with Oracle Database CI/CD & SQLcl Projects
www.thatjeffsmith.com
October 24, 2026 at 8:38 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle SQLcl 24.4.1 available with Excel & Access imports
Oracle SQLcl 24.4.1 available with Excel & Access imports
www.thatjeffsmith.com
October 24, 2026 at 4:40 AM
thatjeffsmith.com
"Quick" video demo of how quickly you can setup RAG using your @OracleDatabase and SQLcl

Vectors, MCP, AI ... oh my

youtube.com/watch?v=Ooaw3upFiCo
From Files to AI Answers: Oracle SQLcl Vector Search + MCP
YouTube video by THAT Jeff Smith
youtube.com
October 21, 2026 at 7:17 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Using SQLcl in SQL Developer for VS Code for MCP with Cline
Using SQLcl in SQL Developer for VS Code for MCP with Cline
Previously on @thatjeffsmith... Using SQLcl in SQL Developer for VS Code for MCP with Cline
www.thatjeffsmith.com
October 18, 2026 at 4:38 AM
thatjeffsmith.com
Previously on @thatjeffsmith... SQLcl Projects: Automating Oracle Database app deployments
SQLcl Projects: Automating Oracle Database app deployments
Previously on @thatjeffsmith... SQLcl Projects: Automating Oracle Database app deployments
www.thatjeffsmith.com
October 14, 2026 at 12:39 PM
doagdevcommunity.bsky.social
APEX 26.1: Bereit für die Migration?
Morgen, 15.10. um 17 Uhr, sprechen @ronnyweiss.bsky.social & @oliverlemm.bsky.social im DOAG #DevTalk über ORDS, SQLcl, APEXlang, Übersetzungen & mögliche Stolperfallen beim Umstieg.

Seid dabei, bringt eure Fragen mit! 😊
➡️ lnkd.in/dak45Nm7

#orclapex #DOAGDevs
October 14, 2026 at 8:04 AM
thatjeffsmith.com
Previously on @thatjeffsmith... How to connect to your OCI Oracle Database via SQLcl
How to connect to your OCI Oracle Database via SQLcl
Previously on @thatjeffsmith... How to connect to your OCI Oracle Database via SQLcl
www.thatjeffsmith.com
October 10, 2026 at 8:40 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Agents Skills: load CSV to new Oracle tables via SQLcl MCP
Agents Skills: load CSV to new Oracle tables via SQLcl MCP
Previously on @thatjeffsmith... Agents Skills: load CSV to new Oracle tables via SQLcl MCP
www.thatjeffsmith.com
October 10, 2026 at 4:41 AM
oracletechtalan.bsky.social
APEXlang vs. SQL: Which is faster for APEX deployment?

Alexander Kluev joins Marwa on today’s AIT to discuss why network conditions matter.

Read the research: alexonapex.com/blog/2026/09...

Join us at 12:05 PM: www.youtube.com/watch?v=VD1R...

#orclapex #SQLcl #APEXInstantTips
October 9, 2026 at 2:35 PM
sqldaily.bsky.social
Want a #SQL script with all the differences between two Oracle Database schemas?

Use the Oracle SQLcl command:

diff -source -target

This creates a ZIP file with all the changes to make them match

@thatjeffsmith.com demos buff.ly/eFL8vwH
How to compare two Oracle Database schemas with SQLcl
How to easily & programmatically compare 2 oracle database schemas with Oracle SQLcl and the DIFF command. Get back a list of changes, expressed as SQL upgrade scripts.
buff.ly
October 8, 2026 at 11:01 AM
oracleace.bsky.social
🎉 A warm welcome to Alexander Kluev, our new #OracleACE Associate from Canada! 🇨🇦

With 30 years of experience in Oracle technologies and a passion for sharing knowledge on APEX, PL/SQL, and SQLcl, Alexander brings a wealth of expertise to our community.

👏 Congrats!
🔗 ace.oracle.com/ords/ace/pro...
October 8, 2026 at 1:26 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Ingest, vectorize, chunk, and load VecDB Tables with SQLcl Model command
Ingest, vectorize, chunk, and load VecDB Tables with SQLcl Model command
Previously on @thatjeffsmith... Ingest, vectorize, chunk, and load VecDB Tables with SQLcl Model command
www.thatjeffsmith.com
October 7, 2026 at 6:33 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Configure SQLcl MCP for Codex: Connecting to Oracle FreeSQL.com
Configure SQLcl MCP for Codex: Connecting to Oracle FreeSQL.com
Previously on @thatjeffsmith... Configure SQLcl MCP for Codex: Connecting to Oracle FreeSQL.com
www.thatjeffsmith.com
October 5, 2026 at 4:38 AM