Jeff Smith's Avatar

Jeff Smith

@thatjeffsmith.com.bsky.social

A product manager for Oracle Database, specializing in database developer productivity. Blogs @ https://www.thatjeffsmith.com 🌟 SQL β­• Oracle πŸ“Š Databases πŸ‹οΈβ€β™‚οΈ Weights, poorly πŸ₯ƒ Bourbon πŸ•ΈοΈ REST API πŸ™Š Product Manager 🀘 80's hair metal fan

1,076 Followers  |  581 Following  |  7,074 Posts  |  Joined: 03.07.2023  |  2.085

Latest posts by thatjeffsmith.com on Bluesky

Preview
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.

πŸ“£ New post!

www.thatjeffsmith.com/archive/2025...

08.08.2025 18:29 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 1

Not forever but plenty far out.

02.08.2025 20:06 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

19c is a great platform, getting new features on a regular basis.

02.08.2025 19:54 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Were running 23ai in production all over the place.

02.08.2025 19:25 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

It's available on prem now, via engineered appliances and oracle cloud at customer.

You can also join our beta program if you want to to have a go on your local machines.

02.08.2025 17:19 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 3    πŸ“Œ 0

Its not a dba role because they dont want to pay dba wages.

02.08.2025 17:16 β€” πŸ‘ 5    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
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!

New post: using our MCP Server to allow our LLM to fix our Oracle Database table comments

www.thatjeffsmith.com/archive/2025...

31.07.2025 20:19 β€” πŸ‘ 3    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0

Name a word only product managers can spell.

I'll start:

d-e-p-r-e-c-a-t-e-d

Def: to kill something no one uses, except for those 5 people who are going to be real mad because they're using it.

30.07.2025 13:55 β€” πŸ‘ 5    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

If you tell someone 'it does not work,' w/o providing details, don't be surprised when you get a screenshot response...showing it working.

30.07.2025 13:53 β€” πŸ‘ 6    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

So what's for lunch?

28.07.2025 09:31 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

We should rename this to "greatest"

28.07.2025 09:29 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

FF, better than good.

Kept thinking, wow they really cared about the comics.

Maybe nerfed G a bit, but it still worked.

27.07.2025 20:56 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

red alert keyboard shortcut

24.07.2025 23:13 β€” πŸ‘ 145    πŸ” 20    πŸ’¬ 5    πŸ“Œ 2
Preview
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.

Tell #SQL stories with SQL Notebooks in Oracle SQL Developer for VS Code

Show statements with their results
Along with markdown blocks to describe the data

@thatjeffsmith.com shows

23.07.2025 11:02 β€” πŸ‘ 4    πŸ” 2    πŸ’¬ 0    πŸ“Œ 0

Ok so on GUI it seems we have a process bug

No clue on sqlcl will see what I can figure out

22.07.2025 11:40 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Had another set of tns parser bugs to step on.

For your connection, does it work in sqlcl w/o a password prompt?

22.07.2025 11:20 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Absolutely!

22.07.2025 09:22 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
Oracle adds MCP support to advance agentic AI development | TechTarget With agentic AI continuing to gain popularity, Oracle has integrated Model Context Protocol (MCP) with Oracle Database to speed and simplify developing agents.

...me from @techtargetnews.bsky.social today

read the full story here

www.techtarget.com/searchdatama...

21.07.2025 22:19 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

TechTarget:

"The industry has adopted MCP extremely quickly, and the potential was obvious from the beginning," he said. "We evaluated it internally and saw quite clearly that the potential for Oracle Database users was real. The key is doing it in a way that makes sense, is secure and will scale."

21.07.2025 22:18 β€” πŸ‘ 4    πŸ” 1    πŸ’¬ 1    πŸ“Œ 0

Wake Forest is a great town, but its sooooo far away. Like Fuquay Varina, but with better beer.

20.07.2025 20:05 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

It’s good to have haters, right?

20.07.2025 15:03 β€” πŸ‘ 129    πŸ” 2    πŸ’¬ 40    πŸ“Œ 1
Preview
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!

a follow up β†˜οΈ

www.thatjeffsmith.com/archive/2025...

17.07.2025 20:35 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
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!

A deeper dive on MCP for Oracle Database

www.thatjeffsmith.com/archive/2025...

17.07.2025 20:18 β€” πŸ‘ 2    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Post image

Official announcement/introduction to our MCP Server for Oracle Database

blogs.oracle.com/database/pos...

16.07.2025 15:35 β€” πŸ‘ 11    πŸ” 10    πŸ’¬ 1    πŸ“Œ 0

Heads-up, we just pushed update 25.2.1 for our SQLDev extension for VS Code.

Heads-up #2, be sure you're on VS Code version 1.101 or higher to get our extension updates!

14.07.2025 16:10 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 0    πŸ“Œ 1
Two 1980s records
 Europe's The Final Countdown
 Alice Cooper's Poison

Two 1980s records Europe's The Final Countdown Alice Cooper's Poison

Now playing

12.07.2025 20:07 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Dont spoil your vacay, it'll be here when you get back!

12.07.2025 15:40 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

Agent mode upgraded with an MCP Server for Oracle Database, yes please!

oracle.com/sqlcl

10.07.2025 21:44 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

Claude is smart enough to know I didn't run that many miles, so it did some maths based on the elapsed time per run I had recorded in my oracle database table, and decided (CORRECTLY) that Strava uses METERS

And i just told it to look in my fun database and figure out how many miles I've ran...

10.07.2025 21:42 β€” πŸ‘ 7    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

there is one main connection, used for browsing - the tree stuff, and then by default there is a dedicated connection per worksheet/notebook - so if you need to reconnect there's multiple

you can alleviate this by disabling the multiple connections feature in preferences

10.07.2025 15:03 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@thatjeffsmith.com is following 19 prominent accounts