Sign in

Justin Biard

@icodealot.com
127 followers 151 following 150 posts

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)

PostsRepliesMedia
Justin Biard @icodealot.com · 25/06/2026
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?
icodealot.com
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...
000
Justin Biard @icodealot.com · 23/06/2026
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...
icodealot.com
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...
000
Justin Biard @icodealot.com · 14/06/2026
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.
icodealot.com
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...
010
Justin Biard @icodealot.com · 06/06/2026
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...
icodealot.com
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...
010
Justin Biard @icodealot.com · 01/06/2026
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
100
Justin Biard @icodealot.com · 29/05/2026
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...
nikhleshagrawal.dev
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.
010
Justin Biard @icodealot.com · 29/05/2026
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...
kotfs.com
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.
020
Reposted by Justin Biard
Jeff Smith @thatjeffsmith.com · 29/05/2026
This is fresh content, highly rec for our cloud subscribers, or folks running oracle @ aws, azure, gcp
001
Justin Biard @icodealot.com · 28/05/2026
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...
icodealot.com
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 ...
000
Justin Biard @icodealot.com · 21/05/2026
A zero-install, enterprise-grade, MCP server for the Oracle Database landed in OCI and it is free to use! This intro from @thatjeffsmith.com and @krisrice.io does a great job explaining the OCI Database Tools MCP Server at a high level. blogs.oracle.com/database/gai...
blogs.oracle.com
010
Justin Biard @icodealot.com · 29/10/2025
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-...
icodealot.com
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...
010
Justin Biard @icodealot.com · 02/10/2025
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 🔥
000
Justin Biard @icodealot.com · 28/09/2025
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...
speakerdeck.com
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…
010
Justin Biard @icodealot.com · 31/08/2025
I look forward to nerding out about cloud tech at #CommitYourCode and learning from what others have put together. 🤓 See you in September!
000
Reposted by Justin Biard
montrealjug.org @montrealjug.org · 14/08/2025
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...
meetup.com
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.
054
Justin Biard @icodealot.com · 15/08/2025
Presenting or attending Commit Your Code 2025 in Plano, TX this September? I look forward to seeing you there! Great event for a good cause and even better outcomes. www.commityourcode.com
commityourcode.com
010
Justin Biard @icodealot.com · 10/08/2025
Just wrapped up the final exam for the Summer trimester and I think I nailed it 🤞 That's 2 classes down for the master's. 🤓📈
010
Reposted by Justin Biard
Jeff Smith @thatjeffsmith.com · 16/07/2025
Official announcement/introduction to our MCP Server for Oracle Database blogs.oracle.com/database/pos...
11010
Justin Biard @icodealot.com · 14/07/2025
First adventure (on the tabletop) in Tamriel. Daughter and I are playing through the intro campaign in Black Marsh.
020
Reposted by Justin Biard
chrishoina @chrishoina.bsky.social · 01/07/2025
ORDS 25.2 is now available for download! Download directly from www.oracle.com/database/tec... And review the Release Notes too www.oracle.com/tools/ords/o... I'm following up with a blog with some examples, so stay tuned! #newrelease #productupdate #ords #oracledatabase #newordswhodis #plsql #rest
187
Reposted by Justin Biard
Jeff Smith @thatjeffsmith.com · 01/07/2025
New post! PARs are easier to manage in ORDS now, and a quick note for the #orclapex community www.thatjeffsmith.com/archive/2025...
thatjeffsmith.com
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.
043
Justin Biard @icodealot.com · 18/06/2025
media.tenor.com
a close up of a man 's face with the words `` it 's done '' written on the bottom .
ALT: a close up of a man 's face with the words `` it 's done '' written on the bottom .
010
Justin Biard @icodealot.com · 18/06/2025
My home for the next 1.5 hours or so. #Kscope25
020
Justin Biard @icodealot.com · 18/06/2025
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!
000
Justin Biard @icodealot.com · 17/06/2025
Going old school with The Chet today for #Kscope25 Wish you guys were here. 🍻
050
Reposted by Justin Biard
ODTUG @odtug.bsky.social · 16/06/2025
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.
081
Justin Biard @icodealot.com · 13/06/2025
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.
000
Justin Biard @icodealot.com · 11/06/2025
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.
010
Justin Biard @icodealot.com · 11/06/2025
This is a great write up. Thanks for sharing it @frobertrti.bsky.social
000
Reposted by Justin Biard
Jeff Smith @thatjeffsmith.com · 03/06/2025
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...
thatjeffsmith.com
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.
2148
Justin Biard @icodealot.com · 31/05/2025
I need an OS level plugin that makes vim motions / bindings available everywhere contextually. I've been using vim bindings long enough now that I get subconsciously annoyed when an input or text editor doesn't have support for them.
020
Justin Biard @icodealot.com · 29/05/2025
Not me debugging code (without a debugger) where I was calling: > list.add(index, item); when I meant to call: > lilst.set(iindex, item); 🤦‍♂️🐜 How is your Thursday going?
000
Justin Biard @icodealot.com · 25/05/2025
Double dose of nerdery today. This one is about decorating objects (thanks GoF!) in Java and also looks at how to do something interesting with proxy objects. icodealot.com/tracing-inte...
icodealot.com
Tracing Interface Calls by Decorating Objects with a Proxy Object in Java
You take an instance of some type and decorate it with additional responsibilities at runtime. The decorator acts like a proxy for the instance, forwarding or augmenting requests sent to methods along...
000
Justin Biard @icodealot.com · 25/05/2025
Check out Oracle JDBC 23ai and the new service provider for OCI configuration, by example: - ADB Serverless - Database Tools connection - JDBC 23ai + OCI config provider (via SPI) icodealot.com/oracle-jdbc-...
icodealot.com
Oracle JDBC Config Provider for OCI Database Tools Service
With Oracle's Java Database Connectivity (JDBC) driver starting with 23ai it is now possible to provide the configuration of a connection to Oracle Database using the opaque identifier of a Database T...
022
Reposted by Justin Biard
Jeff Smith @thatjeffsmith.com · 20/05/2025
If you're interested in speaking at Cloud World on topics involving appDev on Oracle Database - drop me a note. I'd be happy to co-present with you, and we can highlight your story! Jeff.D.Smith@oracle.com - call for papers ends on the 23rd!
032
Justin Biard @icodealot.com · 16/05/2025
The inaugural event was great. I look forward to attending this year again and meeting other developers and talking tech. No doubt, great work ahead from the DSD/CYC team.
021
Justin Biard @icodealot.com · 09/05/2025
Trying out Speaker Deck so I'll post some of my presentations from this year there for reference. Here is one I delivered in March at DSD Night of Cloud. speakerdeck.com/icodealot/bu...
speakerdeck.com
Building in the Cloud with Terraform
This is a presentation about using Terraform (or OpenTofu) to build cloud infrastructure. The content presented is suitable for beginner to intermedi…
000
Justin Biard @icodealot.com · 09/05/2025
Hanging out with the DSD family tonight. 🫡
010
Justin Biard @icodealot.com · 07/05/2025
Them: someone stalked you on the internet today. pay us a hefty monthly service fee and we will name names. Me: lol, what?
100
Justin Biard @icodealot.com · 19/04/2025
I injured my back on vacation so I'm relaxing with a heat pad, some classic rock, and testing JetBrains' latest IDE updates.
000
Reposted by Justin Biard
Jeff Smith @thatjeffsmith.com · 14/04/2025
The latest update for our Oracle SQL Developer Extension for VS Code (25.1) is now available. Tons of new features and bug fixes included. www.thatjeffsmith.com/archive/2025... Next scheduled update will be June and 25.2.
thatjeffsmith.com
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!)
63814
Reposted by Justin Biard
Francois Robert @frobertrti.bsky.social · 09/04/2025
I just published the final post in my "Fun with OCI Functions" series! 🎉 This one is a deep dive into the Document Generator pre-built function on Oracle Cloud Infrastructure (OCI). Check it out: francois-robert.ghost.io/fun-with-oci...
031
Justin Biard @icodealot.com · 08/04/2025
Reposting for the day-time crowd. Interested in integrating external systems with AI? MCP might be interesting for you.
011
Justin Biard @icodealot.com · 06/04/2025
A bit of a side quest from cloud infrastructure. "I do worry that we are asking AI models to do (repetitively) more and more of the same exact tasks. The LLM is a kind of super Shlemiel hiding in plain sight." icodealot.com/so-you-need-...
icodealot.com
So you need an MCP tool, now what?
tl/dr: Model Context Protocol (MCP) is a light-weight protocol that attempts to address a specific problem of how to allow 3rd parties (you, me, or anyone) to provide relevant prompts or context to a ...
000
Justin Biard @icodealot.com · 30/03/2025
Working on a writeup but in the meantime, here was my tech stack for the Java MCP server
000
Justin Biard @icodealot.com · 30/03/2025
For literal academic reasons, I implemented another MCP server but in Java this time. This one was just as easy to integrate with Claude, for example. The Java MCP server only has 2 tools at the moment. A "greeting" tool and a "lorem-ipsum" tool. Messages are passed over STDIO.
000
Justin Biard @icodealot.com · 26/03/2025
There are no real secrets here. If you want to play around with setting up your own model context protocol (MCP) tools (recommended) you should start here: spec.modelcontextprotocol.io/specificatio... ... I chose Go. You can probably use anything you want as long as STDIO is available.
spec.modelcontextprotocol.io
Tools
ℹ️ Protocol Revision: 2024-11-05 The Model Context Protocol (MCP) allows servers to expose tools that can be invoked by language models. Tools enable models to interact...
000
Justin Biard @icodealot.com · 26/03/2025
I put together a basic JSON-RPC 2.0 server in Go that works with Claude to read compartment resources from my OCI tenancy (i.e. an MCP server) Then I asked Claude to generate Terraform code and an example architecture diagram. Mostly believable responses. I have much to ponder. 🤔
Architecture diagram generated by Claude Sonnet 3.7 in response to input from prompts that include data from a custom MCP server for OCI written in Golang.
130
Justin Biard @icodealot.com · 25/03/2025
Listening to the soundtrack from Chorus (game) this morning and its making me want to replay the game. Music is such a great motivator. Now I just need a soundtrack for cleaning up the garage.
000
Reposted by Justin Biard
Martin Bach @martindba.bsky.social · 25/03/2025
DevOps is widely adopted yet many developers still hesitate to apply its principles to their data stores. But there's no need for that—Database CI/CD is a reality. Not convinced? Take a look at this techbrief to learn how you can integrate your db into CI/CD pipelines: www.oracle.com/a/ocom/docs/...
oracle.com
042