How good is ChatGPT 5 at generating an oracle data model using 23ai syntax, and can Windsurf successfully implement it with our Oracle Database MCP Server?

ThatJeffSmith

09.08.2025

Coding React Apps with Oracle Database MCP & Claude Sonnet 4

How I built a REACT web app for my Oracle Database with the assistance from my AI Agent and our MCP Server in only a few minutes.

ThatJeffSmith

01.08.2025

Using Claude to ‘fix’ my table comments via our MCP Server

Using our new Oracle Database MCP Server with Claude desktop to improve some TABLE comments in my schema. With and without good columns names!

ThatJeffSmith

29.07.2025

Getting Started with our MCP Server for Oracle Database

Gettings started and deep dive tour of our new MCP Server with Oracle Database! VS Code and Copilot, connect to our db, and run some queries...and more!

ThatJeffSmith

10.07.2025

SQL Notebooks in Oracle SQL Developer for VS Code

Introducing SQL Notebooks, a new way to work with Oracle Database SQL and PL/SQL scripts in the SQL Developer Extension for VS Code.

ThatJeffSmith

02.07.2025

More on PARs and a note re: APEX RESTful Data Services

ORDS version 25.2 is now available! Also a quick overview on the new PAR support in SQL Developer Web and a note regarding RESTful Services interface in APEX.

ThatJeffSmith

12.06.2025

Database News: June edition. 23ai and some LiveSQL

Summary from our Oracle Developer Coaching, June News Edition. Kris and I were back to talk more things Oracle Database and LiveSQL!

ThatJeffSmith

04.06.2025

Oracle Developer Coaching: Monthly News Edition

Fast-paced, 30-minute broadcasts, to stay in the know. Delivered newsroom-style, the monthly News Edition brings you rapid-fire updates, announcements, and insights from Oracle product teams.

ThatJeffSmith

14.05.2025

Build an MCP to connect AI to Oracle Database w/OpenAPI

See how to build your own local MCP to connect your AI assistant to an Oracle Database, by simply ingesting our REST API OpenAPI spec!

ThatJeffSmith

09.05.2025

Deploy updates to multiple Oracle Databases, concurrently

Using Oracle SQLcl to execute scripts on multiple databases, concurrently, using the background command. The jobs command makes monitoring those tasks easy.

ThatJeffSmith

06.05.2025

SQLcl Projects: Automating Oracle Database app deployments

An overview of our SQLcl project command, how it's evolved from our Liquibase commands, and some resources to help you get started with Oracle Database CI/CD.

ThatJeffSmith

06.05.2025

Getting started with Oracle Database CI/CD & SQLcl Projects

How to get started with SQLcl projects for implementing CI/CD practices for your Oracle Database by setting up your project and database for Git and Liquibase.

ThatJeffSmith

26.04.2025

Connecting to Oracle using VS Code & Kerberos Auth

How to setup Oracle SQL Developer Extension for VS Code or Oracle SQLcl to authenticate your database connections using Kerberos - without an Oracle Client!

ThatJeffSmith

18.04.2025

How to Export all of your Oracle Database REST APIs

How to export all of the REST APIs across all of the schemas in your Oracle Database using Oracle REST Data Services (ORDS) version 25.1.

ThatJeffSmith

16.04.2025

Organizing connections in Oracle SQLDev for VS Code

Here's a quick tutorial for getting started with organizing your Oracle Database connections into folders using SQL Developer's extension for VS Code.

ThatJeffSmith

15.04.2025

SQL Developer for VS Code 25.1: Connection Folders are here!

Oracle SQL Developer Extension for VS Code v25.1 is now available! This release includes the ability to organize your connections via folders (and subfolders!)

ThatJeffSmith

26.03.2025

Secure IOT device uploads to Oracle Database via REST API

Easily setup your Internet of things (IOT) devices to share their telemetry data with your Oracle Database, via a secured REST API and a bit of Python.

ThatJeffSmith

18.03.2025

Quick Tip: copying from SQLDev/VS Code to your spreadsheet

Quick tip! How to quickly copy and paste data from your Oracle SQL query results to Excel using SQL Developer's Extension for VS Code.

ThatJeffSmith

08.03.2025

Pre-Authenticated Requests (PARs) for your Oracle REST APIs

Did you know Oracle REST Data Services now supports generating Pre-Authenticated Requests (PARs) for any of your Oracle Database REST APIs? Examples and code!

ThatJeffSmith

01.03.2025

Example: Loading Chicago Crime Data (CSV) with SQLcl

Using SQLcl to load ~29,000 records from Chicago's open data portal to follow along with AI Vector Search PM Andy Rivenes's getting started tutorial.

ThatJeffSmith

25.02.2025

Oracle Database 23ai VirtualBox 23.7 & DBMS_DEVELOPER

Oracle Database 23ai FREE, version 23.7 is now available on our VirtualBox appliance. Let's also take a quick look at the new DBMS_DEVELOPER package.

ThatJeffSmith

21.02.2025

On Deleting resources via your Oracle Database REST APIs

Oracle Database REST API example, how to fail gracefully when resource DELETE request fails. TLDR - exception handling and proper status codes!

ThatJeffSmith

19.02.2025

Oracle Database blogs to add to your RSS feeds

Round-up from my 'daily share a Oracle Database blog post in January' project. All of the posts, links to the authors, and my personal takes.

ThatJeffSmith

19.02.2025

Sessionless Transactions in Database 23ai & your REST APIs

With the latest innovations in Oracle 23ai, you can now work with an Oracle session transaction over MULTIPLE HTTPS REST API calls! Here's a demo with ORDS.

ThatJeffSmith

19.02.2025

Oracle SQLcl 24.4.1 available with Excel & Access imports

Oracle SQLcl 24.4.1 is available, and supports loading Excel files to new or existing tables with the LOAD cmd. Plus a reminder about our Project feature.

ThatJeffSmith

24.01.2025

Loading JSON data into both 19c & 23ai tables via REST APIs

How to easily load a new record to your Oracle Database table via a REST API, when that table has 1 or more JSON columns in either 19c or 23ai via ORDS.

ThatJeffSmith

23.01.2025

Oracle SQL Developer Extension for VS Code: Reports!

A quick look at one of our new features in Oracle SQL Developer Extension for VS Code - reports! Quickly get information about your database.

ThatJeffSmith

15.01.2025

A quick note on Creating PDBs using REST APIs with ORDS

Creating or Cloning Pluggable Databases (PDBs) via ORDS Database REST APIs is now an asynch operation via DBMS_SCHEDULER jobs. Here's an example.

ThatJeffSmith

10.01.2025

Introducing SQL Developer Web to Oracle Cloud Infrastructure

Oracle Cloud Infrastructure (OCI) Console now supports Oracle SQL Developer Web! SQL worksheet, data modeler, sql monitoring, user management, and more!

ThatJeffSmith

03.01.2025

Execution plans in Oracle SQL Developer for VS Code

An overview for all the different ways to get and view the plans for your SQL statements in Oracle Database using the SQL Developer extension for VS Code.

ThatJeffSmith

20.12.2024

Definitive guide to moving from SQL Developer to VS Code

Here's a quick start guide of sorts if you're an old-time Oracle SQL Developer user and you want to get started using the SQL Developer Extension for VS Code.

ThatJeffSmith

19.12.2024

Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6

We've updated our Oracle VirtualBox Database 23ai appliance. The Oracle Database is now running version 23.6. Simply download, import, and run!

ThatJeffSmith

18.12.2024

Oracle SQL Developer 24.3.1 is now available

Oracle SQL Developer 24.3.1 is now available with bug fixes for Macs and working with Excel and BLOBs. For new features, see our VS Code Extension.

ThatJeffSmith

17.12.2024

Oracle SQL Developer Extension for VS Code 24.4 available

Oracle SQL Developer Extension for VS Code 24.4 is available! Our 11th release of '24 offers new features (REPORTS, SQLMONiTORING, EXEC PLANS) and bug fixes.

ThatJeffSmith

14.12.2024

How to upload multiple files in 1 call: multipart/form-data

How to build an API with Oracle REST Data Services (ORDS) to upload multiple files in a single request via multipart/form-data, with all the code you need.

ThatJeffSmith

13.12.2024

Copying VS Code Developer Tools connections to SQL Developer

How to migrate your old Developer Tools VS Code extension Oracle Database connections to the new Oracle SQL Developer extension.

ThatJeffSmith

19.11.2024

How to cancel a long running Oracle SQL query in VS Code

When you're running SQL via VS Code and our Oracle SQL Developer Extension, you have two options for how to cancel. Here's a quick read with demo.

ThatJeffSmith

19.11.2024

Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required

It's that much easier to get started learning SQL and Oracle Database with our new and improved Oracle LiveSQL platform! Now running 23ai!

home›ThatJeffSmith›Software

ThatJeffSmith - Software

Insights & FAQS from speaking to folks re: our MCP Server

SQLDev for VS Code Quick Tip: Find Objects in Navigator

Building a new app schema database using Windsurf and GPT-5

Coding React Apps with Oracle Database MCP & Claude Sonnet 4

Using Claude to ‘fix’ my table comments via our MCP Server

Getting Started with our MCP Server for Oracle Database

SQL Notebooks in Oracle SQL Developer for VS Code

More on PARs and a note re: APEX RESTful Data Services

Database News: June edition. 23ai and some LiveSQL

Oracle Developer Coaching: Monthly News Edition

Build an MCP to connect AI to Oracle Database w/OpenAPI

Deploy updates to multiple Oracle Databases, concurrently

SQLcl Projects: Automating Oracle Database app deployments

Getting started with Oracle Database CI/CD & SQLcl Projects

Connecting to Oracle using VS Code & Kerberos Auth

How to Export all of your Oracle Database REST APIs

Organizing connections in Oracle SQLDev for VS Code

SQL Developer for VS Code 25.1: Connection Folders are here!

Secure IOT device uploads to Oracle Database via REST API

Quick Tip: copying from SQLDev/VS Code to your spreadsheet

Pre-Authenticated Requests (PARs) for your Oracle REST APIs

Example: Loading Chicago Crime Data (CSV) with SQLcl

Oracle Database 23ai VirtualBox 23.7 & DBMS_DEVELOPER

On Deleting resources via your Oracle Database REST APIs

Oracle Database blogs to add to your RSS feeds

Sessionless Transactions in Database 23ai & your REST APIs

Oracle SQLcl 24.4.1 available with Excel & Access imports

Loading JSON data into both 19c & 23ai tables via REST APIs

Oracle SQL Developer Extension for VS Code: Reports!

A quick note on Creating PDBs using REST APIs with ORDS

Introducing SQL Developer Web to Oracle Cloud Infrastructure

Execution plans in Oracle SQL Developer for VS Code

Definitive guide to moving from SQL Developer to VS Code

Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6

Oracle SQL Developer 24.3.1 is now available

Oracle SQL Developer Extension for VS Code 24.4 available

How to upload multiple files in 1 call: multipart/form-data

Copying VS Code Developer Tools connections to SQL Developer

How to cancel a long running Oracle SQL query in VS Code

Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required

home
›
ThatJeffSmith
›
Software