Jeff Smith
LightNews LightNews
banner
thatjeffsmith.com
Jeff Smith
@thatjeffsmith.com
1.1K followers 580 following 7.7K posts
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
Posts Replies Media Videos
Pinned
thatjeffsmith.com
Jeff Smith @thatjeffsmith.com · Nov 15
💡 Tip: Working with lots of different databases and don't want to accidentally drop a table in your PROD Oracle system?

PS if you've never done this, you've probably not been in IT for very long #riteOfpassage

Use emojis in your connection names 🔴 🟡 🟢

Tip 2: STAY OUT OF PRODUCTION :)
thatjeffsmith.com
Previously on @thatjeffsmith... Code & Tune an Oracle DB REST API w/Claude, MCP, & ORDS
Code & Tune an Oracle DB REST API w/Claude, MCP, & ORDS
Previously on @thatjeffsmith... Code & Tune an Oracle DB REST API w/Claude, MCP, & ORDS
www.thatjeffsmith.com
February 2, 2026 at 5:38 AM
thatjeffsmith.com
Previously on @thatjeffsmith... My favorite posts from 2023 @thatJeffSmith
My favorite posts from 2023 @thatJeffSmith
Previously on @thatjeffsmith... My favorite posts from 2023 @thatJeffSmith
www.thatjeffsmith.com
February 1, 2026 at 9:36 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Where is the Code Outline in SQL Developer, for VS Code?
Where is the Code Outline in SQL Developer, for VS Code?
Previously on @thatjeffsmith... Where is the Code Outline in SQL Developer, for VS Code?
www.thatjeffsmith.com
February 1, 2026 at 1:36 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Connecting to Oracle using VS Code & Kerberos Auth
Connecting to Oracle using VS Code & Kerberos Auth
Previously on @thatjeffsmith... Connecting to Oracle using VS Code & Kerberos Auth
www.thatjeffsmith.com
February 1, 2026 at 5:39 AM
thatjeffsmith.com
Previously on @thatjeffsmith... SQLDev for VS Code Quick Tip: Find Objects in Navigator
SQLDev for VS Code Quick Tip: Find Objects in Navigator
Previously on @thatjeffsmith... SQLDev for VS Code Quick Tip: Find Objects in Navigator
www.thatjeffsmith.com
January 31, 2026 at 9:39 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Database News: June edition. 23ai and some LiveSQL
Database News: June edition. 23ai and some LiveSQL
Previously on @thatjeffsmith... Database News: June edition. 23ai and some LiveSQL
www.thatjeffsmith.com
January 31, 2026 at 1:37 PM
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
January 31, 2026 at 5:38 AM
thatjeffsmith.com
If you're running into problems with TNS and our MCP Server for Oracle Database ...

www.thatjeffsmith.com/archive/2026...
Dealing with TNS database connections with Oracle MCP (SQLcl)
If you're having trouble getting your Agent to connect to your Oracle Database via our SQLcl MCP Server, it might be due to a missing TNS_ADMIN environment variable. Here's how to fix that!
www.thatjeffsmith.com
January 30, 2026 at 10:29 PM
thatjeffsmith.com
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
January 30, 2026 at 10:28 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle Database blogs to add to your RSS feeds
Oracle Database blogs to add to your RSS feeds
Previously on @thatjeffsmith... Oracle Database blogs to add to your RSS feeds
www.thatjeffsmith.com
January 30, 2026 at 9:39 PM
thatjeffsmith.com
Previously on @thatjeffsmith... More on PARs and a note re: APEX RESTful Data Services
More on PARs and a note re: APEX RESTful Data Services
Previously on @thatjeffsmith... More on PARs and a note re: APEX RESTful Data Services
www.thatjeffsmith.com
January 30, 2026 at 1:38 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Organize VS Code Database Environments: Connection Folders
Organize VS Code Database Environments: Connection Folders
Previously on @thatjeffsmith... Organize VS Code Database Environments: Connection Folders
www.thatjeffsmith.com
January 30, 2026 at 5:39 AM
thatjeffsmith.com
Previously on @thatjeffsmith... JSON Relational Duality view & API for an ‘EMPLOYEES’ entity
JSON Relational Duality view & API for an ‘EMPLOYEES’ entity
Previously on @thatjeffsmith... JSON Relational Duality view & API for an ‘EMPLOYEES’ entity
www.thatjeffsmith.com
January 29, 2026 at 9:39 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Execution plans in Oracle SQL Developer for VS Code
Execution plans in Oracle SQL Developer for VS Code
Previously on @thatjeffsmith... Execution plans in Oracle SQL Developer for VS Code
www.thatjeffsmith.com
January 29, 2026 at 1:41 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Logins, TNS, DBMS_OUTPUT, & dates in SQLDev for VS Code
Logins, TNS, DBMS_OUTPUT, & dates in SQLDev for VS Code
Previously on @thatjeffsmith... Logins, TNS, DBMS_OUTPUT, & dates in SQLDev for VS Code
www.thatjeffsmith.com
January 29, 2026 at 5:40 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle SQLDev extension for VS Code Update, 23.4.1
Oracle SQLDev extension for VS Code Update, 23.4.1
Previously on @thatjeffsmith... Oracle SQLDev extension for VS Code Update, 23.4.1
www.thatjeffsmith.com
January 28, 2026 at 9:39 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Hello Hyderabad, Bengaluru, & Mumbai! See you next week!
Hello Hyderabad, Bengaluru, & Mumbai! See you next week!
Previously on @thatjeffsmith... Hello Hyderabad, Bengaluru, & Mumbai! See you next week!
www.thatjeffsmith.com
January 28, 2026 at 6:27 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Sessionless Transactions in Database 23ai & your REST APIs
Sessionless Transactions in Database 23ai & your REST APIs
Previously on @thatjeffsmith... Sessionless Transactions in Database 23ai & your REST APIs
www.thatjeffsmith.com
January 28, 2026 at 5:39 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Coding React Apps with Oracle Database MCP & Claude Sonnet 4
Coding React Apps with Oracle Database MCP & Claude Sonnet 4
Previously on @thatjeffsmith... Coding React Apps with Oracle Database MCP & Claude Sonnet 4
www.thatjeffsmith.com
January 27, 2026 at 9:38 PM
thatjeffsmith.com
📣 26ai is now available for download, x86-64 bit Linux distributions.

www.oracle.com/database/tec...
www.oracle.com
January 27, 2026 at 5:52 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Can I build an Agent & still use SQLcl’s MCP Server? Yes!
Can I build an Agent & still use SQLcl’s MCP Server? Yes!
Previously on @thatjeffsmith... Can I build an Agent & still use SQLcl’s MCP Server? Yes!
www.thatjeffsmith.com
January 27, 2026 at 1:41 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Getting Started with our MCP Server for Oracle Database
Getting Started with our MCP Server for Oracle Database
Previously on @thatjeffsmith... Getting Started with our MCP Server for Oracle Database
www.thatjeffsmith.com
January 27, 2026 at 5:41 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle SQLDev for VS Code: Webinar & Upcoming Features
Oracle SQLDev for VS Code: Webinar & Upcoming Features
Previously on @thatjeffsmith... Oracle SQLDev for VS Code: Webinar & Upcoming Features
www.thatjeffsmith.com
January 26, 2026 at 9:38 PM
thatjeffsmith.com
Updated my post on AI Schema Enrichment to include some slides.

www.thatjeffsmith.com/archive/2025...
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.
www.thatjeffsmith.com
January 26, 2026 at 2:57 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
January 26, 2026 at 1:38 PM