Previously on @thatjeffsmith... How to compare two Oracle Database schemas with SQLcl
How to compare two Oracle Database schemas with SQLcl
Previously on @thatjeffsmith... How to compare two Oracle Database schemas with SQLcl
www.thatjeffsmith.com
September 25, 2026 at 12:38 PM
Previously on @thatjeffsmith... How to compare two Oracle Database schemas with SQLcl
Talk to your Oracle Databases via LLMs with the SQLcl MCP server
But how do you do this securely?
Rafal Grzegorczyk shows you how to
Create a user with the DB_DEVELOPER_ROLE
Grant SELECT privileges on the target schema
Configure SQLcl access level
buff.ly/1rGG8gK
But how do you do this securely?
Rafal Grzegorczyk shows you how to
Create a user with the DB_DEVELOPER_ROLE
Grant SELECT privileges on the target schema
Configure SQLcl access level
buff.ly/1rGG8gK
How 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
buff.ly
September 24, 2026 at 11:02 AM
Talk to your Oracle Databases via LLMs with the SQLcl MCP server
But how do you do this securely?
Rafal Grzegorczyk shows you how to
Create a user with the DB_DEVELOPER_ROLE
Grant SELECT privileges on the target schema
Configure SQLcl access level
buff.ly/1rGG8gK
But how do you do this securely?
Rafal Grzegorczyk shows you how to
Create a user with the DB_DEVELOPER_ROLE
Grant SELECT privileges on the target schema
Configure SQLcl access level
buff.ly/1rGG8gK
Burning tokens for useful toys continues.
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
September 23, 2026 at 2:27 PM
Burning tokens for useful toys continues.
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
I started using Make in my APEX projects to keep the SQLcl, etc. commands in 1 place.
There's also a sync script that exports the app before importing and merges the changes with Git →imports don't overwrite what others did in App Builder.
#orclAPEX
hartenfeller.dev/blog/makefil...
There's also a sync script that exports the app before importing and merges the changes with Git →imports don't overwrite what others did in App Builder.
#orclAPEX
hartenfeller.dev/blog/makefil...
Make APEXlang Easy: Makefiles and Merge-Safe Imports
How a makefile turns the SQLcl, Git and dbLinter commands of an APEX project into short make commands, and how a Git-based sync script stops APEXlang imports from overwriting your colleagues' App Buil...
hartenfeller.dev
September 23, 2026 at 10:57 AM
I started using Make in my APEX projects to keep the SQLcl, etc. commands in 1 place.
There's also a sync script that exports the app before importing and merges the changes with Git →imports don't overwrite what others did in App Builder.
#orclAPEX
hartenfeller.dev/blog/makefil...
There's also a sync script that exports the app before importing and merges the changes with Git →imports don't overwrite what others did in App Builder.
#orclAPEX
hartenfeller.dev/blog/makefil...
Quick heads up to make sure your Oracle AI skill definitions are nice and fresh!
connor-mcdonald.com/2026/09/23/s...
connor-mcdonald.com/2026/09/23/s...
Syncing your Oracle AI skill definitions
One of the very cool facilities in more recent versions of SQLcl is the skills command. The reason I like the command is that most of us have tinkered with various different harnesses such as Claud…
connor-mcdonald.com
September 23, 2026 at 9:49 AM
Quick heads up to make sure your Oracle AI skill definitions are nice and fresh!
connor-mcdonald.com/2026/09/23/s...
connor-mcdonald.com/2026/09/23/s...
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
Example: Loading Chicago Crime Data (CSV) with SQLcl
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
www.thatjeffsmith.com
September 22, 2026 at 8:39 PM
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
New #orclapex skills released. Mostly small changes & enhancements to the recently added template components.
Release notes here: html-preview.github.io?url=https://...
Simply issue "skills sync" from sqlcl to refresh.
Release notes here: html-preview.github.io?url=https://...
Simply issue "skills sync" from sqlcl to refresh.
Git-Forge HTML Preview
html-preview.github.io
September 22, 2026 at 11:46 AM
New #orclapex skills released. Mostly small changes & enhancements to the recently added template components.
Release notes here: html-preview.github.io?url=https://...
Simply issue "skills sync" from sqlcl to refresh.
Release notes here: html-preview.github.io?url=https://...
Simply issue "skills sync" from sqlcl to refresh.
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
Getting started with Oracle Database CI/CD & SQLcl Projects
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
www.thatjeffsmith.com
September 21, 2026 at 12:37 PM
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
Struggling to streamline your Oracle Database & #orclAPEX changes and deployments?
Check out SQLcl Projects
This feature of Oracle SQLcl works with Git to capture changes and build releases
Get started with this cheat sheet by @bsky-matt.0code.io buff.ly/OJUUNp4
Check out SQLcl Projects
This feature of Oracle SQLcl works with Git to capture changes and build releases
Get started with this cheat sheet by @bsky-matt.0code.io buff.ly/OJUUNp4
SQLcl Projects Reference
This is a Quick Reference / Cheat Sheet take your pick. SQLcl Projects is a feature in Oracle's SQLcl tool that helps manage and automate database changes and deployments for Oracle Database and APEX…
buff.ly
September 17, 2026 at 11:02 AM
Struggling to streamline your Oracle Database & #orclAPEX changes and deployments?
Check out SQLcl Projects
This feature of Oracle SQLcl works with Git to capture changes and build releases
Get started with this cheat sheet by @bsky-matt.0code.io buff.ly/OJUUNp4
Check out SQLcl Projects
This feature of Oracle SQLcl works with Git to capture changes and build releases
Get started with this cheat sheet by @bsky-matt.0code.io buff.ly/OJUUNp4
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
September 16, 2026 at 4:40 AM
Previously on @thatjeffsmith... Using SQLcl in SQL Developer for VS Code for MCP with Cline
Previously on @thatjeffsmith... Config SQLcl MCP with Codex and FreeSQL
Config SQLcl MCP with Codex and FreeSQL
Previously on @thatjeffsmith... Config SQLcl MCP with Codex and FreeSQL
www.thatjeffsmith.com
September 15, 2026 at 8:00 PM
Previously on @thatjeffsmith... Config SQLcl MCP with Codex and FreeSQL
Previously on @thatjeffsmith... Oracle SQLcl 24.4.1 available with Excel & Access imports
Oracle SQLcl 24.4.1 available with Excel & Access imports
Previously on @thatjeffsmith... Oracle SQLcl 24.4.1 available with Excel & Access imports
www.thatjeffsmith.com
September 14, 2026 at 12:38 PM
Previously on @thatjeffsmith... Oracle SQLcl 24.4.1 available with Excel & Access imports
Previously on @thatjeffsmith... Dealing with TNS database connections with Oracle MCP (SQLcl)
Dealing with TNS database connections with Oracle MCP (SQLcl)
Previously on @thatjeffsmith... Dealing with TNS database connections with Oracle MCP (SQLcl)
www.thatjeffsmith.com
September 12, 2026 at 4:39 AM
Previously on @thatjeffsmith... Dealing with TNS database connections with Oracle MCP (SQLcl)
The #OracleACE community is heading to Stockholm! 🇸🇪
On 15 September, join the SWEOUG Oracle Meetup to explore MCP Servers, Oracle SQLcl MCP, and how these technologies can open new ways to work with your own data and Generative AI.
🔗 social.ora.cl/6011B1AaKD
On 15 September, join the SWEOUG Oracle Meetup to explore MCP Servers, Oracle SQLcl MCP, and how these technologies can open new ways to work with your own data and Generative AI.
🔗 social.ora.cl/6011B1AaKD
September 10, 2026 at 4:29 PM
The #OracleACE community is heading to Stockholm! 🇸🇪
On 15 September, join the SWEOUG Oracle Meetup to explore MCP Servers, Oracle SQLcl MCP, and how these technologies can open new ways to work with your own data and Generative AI.
🔗 social.ora.cl/6011B1AaKD
On 15 September, join the SWEOUG Oracle Meetup to explore MCP Servers, Oracle SQLcl MCP, and how these technologies can open new ways to work with your own data and Generative AI.
🔗 social.ora.cl/6011B1AaKD
Previously on @thatjeffsmith... Let’s build a mini-changeLog for Oracle using SQLcl.
Let’s build a mini-changeLog for Oracle using SQLcl.
Previously on @thatjeffsmith... Let’s build a mini-changeLog for Oracle using SQLcl.
www.thatjeffsmith.com
September 9, 2026 at 12:37 PM
Previously on @thatjeffsmith... Let’s build a mini-changeLog for Oracle using SQLcl.
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
September 6, 2026 at 12:39 PM
Previously on @thatjeffsmith... How to connect to your OCI Oracle Database via SQLcl
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
Example: Loading Chicago Crime Data (CSV) with SQLcl
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
www.thatjeffsmith.com
September 4, 2026 at 12:36 PM
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
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
September 2, 2026 at 12:40 PM
Previously on @thatjeffsmith... Using SQLcl in SQL Developer for VS Code for MCP with Cline
SQLcl 26.2.2 released
Issues Fixed
🔵 Overwrite flag for APEX Export: Default 'off' for SQL and 'on' for APEXLang
🔵 Project Export results in corrupted static files for APEXLang apps 🎉
www.oracle.com/database/sql...
Issues Fixed
🔵 Overwrite flag for APEX Export: Default 'off' for SQL and 'on' for APEXLang
🔵 Project Export results in corrupted static files for APEXLang apps 🎉
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
August 31, 2026 at 5:13 PM
SQLcl 26.2.2 released
Issues Fixed
🔵 Overwrite flag for APEX Export: Default 'off' for SQL and 'on' for APEXLang
🔵 Project Export results in corrupted static files for APEXLang apps 🎉
www.oracle.com/database/sql...
Issues Fixed
🔵 Overwrite flag for APEX Export: Default 'off' for SQL and 'on' for APEXLang
🔵 Project Export results in corrupted static files for APEXLang apps 🎉
www.oracle.com/database/sql...
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
Getting started with Oracle Database CI/CD & SQLcl Projects
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
www.thatjeffsmith.com
August 27, 2026 at 8:38 PM
Previously on @thatjeffsmith... Getting started with Oracle Database CI/CD & SQLcl Projects
7.1 preview 3 of Microsoft .Data.Sqlient - the .NET driver for all Microsoft SQL databases, is out - take the new high performance connection pool implementation for a spin
#dotnet #sqlserver
github.com/dotnet/SqlCl...
#dotnet #sqlserver
github.com/dotnet/SqlCl...
SqlClient/release-notes/7.1/7.1.0-preview3.md at main · dotnet/SqlClient
Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications. - dotnet/SqlClient
github.com
August 27, 2026 at 5:31 PM
7.1 preview 3 of Microsoft .Data.Sqlient - the .NET driver for all Microsoft SQL databases, is out - take the new high performance connection pool implementation for a spin
#dotnet #sqlserver
github.com/dotnet/SqlCl...
#dotnet #sqlserver
github.com/dotnet/SqlCl...
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
August 20, 2026 at 12:39 PM
Previously on @thatjeffsmith... SQLcl Projects: Automating Oracle Database app deployments
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
August 19, 2026 at 4:38 AM
Previously on @thatjeffsmith... Agents Skills: load CSV to new Oracle tables via SQLcl MCP
This article explains how to create an Oracle Wallet using SQLcl for secure SSL connections between AWS DMS and Amazon RDS for Oracle.
Create Oracle Wallet for AWS DMS SSL connections using SQLcl
This article explains how to create an Oracle Wallet using SQLcl for secure SSL connections between AWS DMS and Amazon RDS for Oracle.
aws-news.com
August 17, 2026 at 6:08 PM
This article explains how to create an Oracle Wallet using SQLcl for secure SSL connections between AWS DMS and Amazon RDS for Oracle.
📰 New article by Vamshi Krishna Panganam, RAJAT SAMANTA
Create Oracle Wallet for AWS DMS SSL connections using SQLcl
#AWS #Databases
Create Oracle Wallet for AWS DMS SSL connections using SQLcl
#AWS #Databases
Create Oracle Wallet for AWS DMS SSL connections using SQLcl
Learn how to use Oracle SQLcl, a lightweight alternative to the full Oracle Client, to create and manage an Oracle Wallet for SSL connections between AWS DMS and Amazon RDS for Oracle. This post walks through installing SQLcl, adding certificates, testing the SSL connection, and configuring the AWS DMS endpoint.
aws.amazon.com
August 17, 2026 at 6:11 PM
📰 New article by Vamshi Krishna Panganam, RAJAT SAMANTA
Create Oracle Wallet for AWS DMS SSL connections using SQLcl
#AWS #Databases
Create Oracle Wallet for AWS DMS SSL connections using SQLcl
#AWS #Databases