Justin Biard

@icodealot.com

Software engineer working on database tools for Oracle Cloud. My family is my life. I like tinkering/technology/art/games in my free time. (posts are mine)

If you are into data science use cases with Python and also use Oracle Database, I'd appreciate your feedback on the utility of this: icodealot.com/posts/build-... tl/dr: What are data scientists in the real world using to store and retrieve large data sets into their pipelines and notebooks?

Build Tools That Speak to Data in OCI - ICODEALOT

This post will help you use the OCI Database Tools Runtime Python SDK to build tools that can speak to databases in OCI by executing SQL statements using connections and converting the result-set to a...

icodealot.com

NEW POST ALERT!!! For those one-off database APIs that you want your LLM to call in a deterministic way. My goal with this post was to walk you through creating your first custom SQL tool and to provide some guidance therein. icodealot.com/posts/creati...

Creating Your First Custom SQL Tools for MCP - ICODEALOT

In this post we look at creating your first custom SQL tools with the OCI Database Tools MCP server. This tutorial assumes you already have an MCP server and that you are ready to create your first cu...

icodealot.com

NEW POST ALERT!!! In honor of all my friends and colleagues sharing knowledge at Kscope26 this week: Build Tools That Speak to Data in OCI icodealot.com/posts/build-... This is a post about bridging the gap between two worlds, data science and relational databases in the cloud.

Build Tools That Speak to Data in OCI - ICODEALOT

This post will help you use the OCI Database Tools Runtime Python SDK to build tools that can speak to databases in OCI by executing SQL statements using connections and converting the result-set to a...

icodealot.com

NEW POST ALERT! In 2026 the Database Tools team introduced a new data plane that enables many ways of interacting securely with a database in Oracle Cloud over HTTPS. I wrote about using the new CLI to execute SQL statements here. icodealot.com/posts/make-s...

Make SQL RESTful with OCI Database Tools Runtime - ICODEALOT

In 2026 the Database Tools service introduced a new data plane called Database Tools Runtime supported by all the standard OCI interfaces such as the OCI CLI, SDK, and Terraform provider. This is an i...

icodealot.com

On the new blog design, 100%. I'll take it. Posts with images are also not scoring badly, actually but of course take a small hit. My goal on the new design was "keep it simple", no JS libs, favor CSS and HTML, help the scrapers and LLMs where feasible (a'la GEO).

Lighthouse scores for a page on my blog

The team is on fire today! Here is a great post shared by my colleague Nikhlesh. This allows for the real user identity to propagate to the database using OCI Database Tools connections and IAM with Oracle Database (instead of a generic database user.) www.nikhleshagrawal.dev/posts/integr...

Integrating IAM Authentication with OCI Database Tools Connections | Nikhlesh Agrawal

Secure read-only SQL access to a private Autonomous Database using OCI Database Tools and IAM authentication.

nikhleshagrawal.dev

Check out this new tutorial by my colleague Simon, showing off some of our new MCP features including OAuth client registration and Codex setup. Note, the example is geared for a Linux-ish environment and shows a lot of the command-line interface too! kotfs.com/blog/from-ad...

From Ad Hoc SQL to Governed AI Tools

How to expose database capabilities to AI agents with OCI Database Tools MCP Server, using custom SQL toolsets, application roles, and least-privilege connections instead of unrestricted SQL.

kotfs.com

I wrote about using IDCS roles to customize end user access to MCP tools using the new Database Tools MCP server in OCI. If interested, as always, I appreciate your readership and your constructive feedback on the post. Check it out! 👇 icodealot.com/posts/how-to...

How To Customize Tool Access Using Roles in Database Tools MCP Servers - ICODEALOT

The Database Tools MCP server supports role-based access control for tools which allows for users or groups to be granted access to only specific MCP tools. In this example we will look at one way to ...

icodealot.com

Happy Wednesday! We shipped a new type of OCI resource principal called Database Tools Identity. It gives schemas a way to have distinct resource principals. You can read all about it here or check the documentation linked in the post. icodealot.com/give-oracle-...

Give Oracle Database access to OCI with Database Tools Identity

You can use a Database Tools identity in Oracle Cloud Infrastructure (OCI) to give Oracle Databases access to OCI resources through something called a "resource principal". There are a few configurati...

icodealot.com

I have not used Quarkus yet for anything in production but exploring it in development and I like what I am seeing so far. Developer productivity feels like it will be 🔥

Thanks everyone who came to my talk at @commityourcode.bsky.social '25 or watched the stream. I appreciate you taking the time to be there and I hope you took something useful away from it. Thanks also for the feedback! Slides with examples and links are here: speakerdeck.com/icodealot/ma...

Manage Complexity with Terraform

A 25 minute introduction to Terraform and refactoring suitable for beginners to intermediate developers who are just getting started dealing with code c…

speakerdeck.com

And... we're back! On est de retour! Join us for the first event of the season Event in english 🇬🇧. 📢 Architect's Guide to Managing a Code Base 🎙️ @prpatel.dev 🗓️ August 26th 2025 at 5:30pm 📍 TS Imagine,355 Rue Sainte-Catherine O #700, Montréal, QC H3B 1A5 Signup now! www.meetup.com/montreal-jug...

Montréal JUG - La communauté Java de Montréal | Meetup

Find Meetup events so you can do more of what matters to you. Or create your own group and meet people near you who share your interests.

meetup.com

Today is the day #Kscope25 at 1:30 Central in San Antonio room 5-6. > Get Connected to Databases in the Cloud with the Database Tools Service. There will be: - Content (live demos if the wifi holds true 🤞) - Quizzes to gain bragging rights + swag Come one, come all!

ODTUG is pleased to announce the ODTUG Oracle Cloud Infrastructure (OCI) community—a space designed to empower, connect, and support professionals who are building the future with Oracle’s next-generation cloud technology. To learn more and get involved, visit odtug.com/news/oci-community.

Bild

A little less than a week away from being able to learn with colleagues at #Kscope25! Come for the swag, stay for the content. 🍻 We will explore the meaning of all these cryptic symbols and how to use the tools Oracle is building to make using database connections in the cloud simple.

Bild
Justin Biard@icodealot.com · last yr.

I look forward to talking with folks at Kscope25 and walking through use cases for the Database Tools service in OCI. Hopefully I'll connect with you there in June!

Do you use `jshell` ? (installs with Java) I find it nice for: - scratching out quick ideas - testing small syntax issues - or anything else you might do with a REPL (quick calculations, etc.) Tab completion is decent and it presents some JavaDoc content.

Bild

So @krisrice.io and I started a new thing: a fast paced monthly news update for all things Oracle Database and Oracle Cloud, with a developer-first focus. Learn all about it, catch up from our first event, and sign up for the upcoming session next week! www.thatjeffsmith.com/archive/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.com