that Jeff Smith (@thatjeffsmith) header
that Jeff Smith (@thatjeffsmith) profile picture

that Jeff Smith

@thatjeffsmith

🌟 SQL ⭕ Oracle 📊 Databases 🤖 AI / MCP 🕸️ REST APIs 🙊 Product Manager 🤡 Annoying people online Words are mine.

 Raleigh, NC
thatjeffsmith.com
Joined March 2009
  • Tweets123K
  • Following2.4K
  • Followers21.5K
7.9KMedia
Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)Photo by that Jeff Smith (@thatjeffsmith)
Apologies for the 1 full year since my last video upload. I hope this makes up for it, a bit. youtube.com/watch?v=wiO5XDkV…
Deep Dive: Bringing the Agentic AI experience to your Oracle databa...

Deep Dive: Bringing the Agentic AI experience to your Oracle databa...

Oracle released it's first MCP Server earlier this year, for one of...

youtube.com
4
1
20
5,995
Previously on thatJeffSmith: Setting up local Keycloak to test ORDS MCP for Oracle AI Database thatjeffsmith.com/archive/20…
Setting up local Keycloak to test ORDS MCP for Oracle AI Database

Setting up local Keycloak to test ORDS MCP for Oracle AI Database

Configuring ORDS MCP with a local Keycloak identity management server, and establishing end users that inherit read only or jr dba database privs.

thatjeffsmith.com
3
338
Previously on thatJeffSmith: Loading JSON data into both 19c & 23ai tables via REST APIs thatjeffsmith.com/archive/20…
Loading JSON data into both 19c & 23ai tables via REST APIs

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.com
1
4
459
Previously on thatJeffSmith: Using SQLcl MCP to generate and consume annotations for better NL2SQL thatjeffsmith.com/archive/20…
Using SQLcl MCP to generate and consume annotations for better NL2SQL

Using SQLcl MCP to generate and consume annotations for better NL2SQL

Using our Annotation MCP Tool in Oracle SQLcl 26.3 to annotate a table in my database with my AI Agent - 26AI not required!

thatjeffsmith.com
6
538
Previously on thatJeffSmith: I built a mini RAG Pipeline to get personal training advice thatjeffsmith.com/archive/20…
I built a mini RAG Pipeline to get personal training advice

I built a mini RAG Pipeline to get personal training advice

How I taught my Agent how to use my 13 years of personal exercise activity to give me better training advice, using MCP, AI Vector Search, and RAG.

thatjeffsmith.com
1
1
5
423
Previously on thatJeffSmith: AI Schema Enrichment + a new MCP Tool = Simpler Prompts thatjeffsmith.com/archive/20…
AI Schema Enrichment + a new MCP Tool = Simpler Prompts

AI Schema Enrichment + a new MCP Tool = Simpler Prompts

Use Oracle SQL Developer extension for VS Code and our MCP Server to annotate your data & assist your agents for more efficient NL2SQL interactions.

thatjeffsmith.com
2
1
9
747
that Jeff Smith retweeted
Oracle Developers (@OracleDevs) profile picture
Oracle Developers
@OracleDevsOct 29
Replying to @thatjeffsmith @Hershal0_0 @OpenAI @OpenAIDevs
Coffee ☕ Codex 💻 Community 🫂 That's what it's all about
1
1
1
261
Previously on thatJeffSmith: Options for our local Oracle Database MCP Server in VS Code thatjeffsmith.com/archive/20…
Options for our local Oracle Database MCP Server in VS Code

Options for our local Oracle Database MCP Server in VS Code

Managing your SQLcl MCP Server config in VS Code for your AI Agents can be handled via our SQL Developer Extension for VS Code, here's how to handle updates.

thatjeffsmith.com
1
3
512
Previously on thatJeffSmith: Asking AI to generate test data, more is better thatjeffsmith.com/archive/20…
Asking AI to generate test data, more is better

Asking AI to generate test data, more is better

Some advice around using LLMs to generate test data for your apps & reports, and how that can be easier with Oracle Database via our MCP Server.

thatjeffsmith.com
2
4
457
Previously on thatJeffSmith: Videos! Overview of our MCP Server, and a Demo! thatjeffsmith.com/archive/20…
Videos! Overview of our MCP Server, and a Demo!

Videos! Overview of our MCP Server, and a Demo!

After a very long break, I've released two new YouTube channel videos over the past 2 days! The first is an overview of our MCP Server, & the 2nd is all demo.

thatjeffsmith.com
1
2
864
Previously on thatJeffSmith: SQLDev for VS Code: DBA features & Color Coded connections thatjeffsmith.com/archive/20…
SQLDev for VS Code: DBA features & Color Coded connections

SQLDev for VS Code: DBA features & Color Coded connections

Oracle SQL Developer for VS Code added a ton of features in our 26.2 update, especially around managing your database connections. Here's an overview.

thatjeffsmith.com
1
6
809
SVP @krisrice chatting with @Oracle CEO @ClayMagouyrk how APEXlang and Generative AI make it easier to deploy applications quickly with confidence. Describe the feature and workflow, don't get lost in the framework or infrastructure weeds.
Image from that Jeff Smith (@thatjeffsmith)
1
2
13
1,364
Previously on thatJeffSmith: Building a new app schema database using Windsurf and GPT-5 thatjeffsmith.com/archive/20…
Building a new app schema database using Windsurf and GPT-5

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

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.com
5
703
Previously on thatJeffSmith: Querying JSON Relational Duality Views via REST APIs thatjeffsmith.com/archive/20…
Querying JSON Relational Duality Views via REST APIs

Querying JSON Relational Duality Views via REST APIs

How to filter or search your Oracle Database 23ai JSON Relational Duality Views using REST APIs, a simple example using our simple dot notation.

thatjeffsmith.com
3
546
Previously on thatJeffSmith: Connecting to Oracle using VS Code & Kerberos Auth thatjeffsmith.com/archive/20…
Connecting to Oracle using VS Code & Kerberos Auth

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.com
3
517
Nuclear wessels , RIP Walter. – at Winchester, NV
7
528
Previously on thatJeffSmith: Using Claude to ‘fix’ my table comments via our MCP Server thatjeffsmith.com/archive/20…
Using Claude to ‘fix’ my table comments via our MCP Server

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.com
2
1
4
517
Previously on thatJeffSmith: Fine-grained AI Enrichment for Oracle Database via MCP thatjeffsmith.com/archive/20…
Fine-grained AI Enrichment for Oracle Database via MCP

Fine-grained AI Enrichment for Oracle Database via MCP

Better NL2SQL experiences with your AI Agents and your Oracle Databases are now available with better schema-information MCP Server tools with SQLcl.

thatjeffsmith.com
1
6
621
Previously on thatJeffSmith: 23ai ‘trivia’: Domains, Annotations, & Duality Views thatjeffsmith.com/archive/20…
23ai ‘trivia’: Domains, Annotations, & Duality Views

23ai ‘trivia’: Domains, Annotations, & Duality Views

You can code more of your data models into your Oracle Database 23ai schemas today using DOMAINs and ANNOTATIONS. Here's an example with a DUALITY VIEW.

thatjeffsmith.com
2
532
There must be 300 people all waiting for Ubers – at Las Vegas, NV
1
2
696
Previously on thatJeffSmith: Who is using your Oracle data (AI!), and how to secure it! thatjeffsmith.com/archive/20…
Who is using your Oracle data (AI!), and how to secure it!

Who is using your Oracle data (AI!), and how to secure it!

A look at OAuth Identity, SYS_CONTEXT, and Row-Level Security via OCI AI Database MCP Servers - how to protect your data based on end user identity, even when AI is in the mix!

thatjeffsmith.com
5
627
Load more