#1143 - AI DB MCP Server in conjunction with Private Agent Framework

Introduction 

According to the official doc - 

The Oracle Autonomous AI Database MCP Server is a managed, multi-tenant server designed to provide secure, standardized access to database tools and features through the Model Context Protocol (MCP). It provides an MCP server for each Autonomous AI Database, enabling AI agents and client applications to interact seamlessly with custom and built-in Select AI Agent tools using MCP APIs.

I want to try this out, especially in conjunction with the Private Agent Framework (PAF). The best starting point is the excellent live lab here.

The steps are simple - 

• enable the MCP server on my ATP instance
• do some initial setup - users, tables etc.
• define tools, which will then be available via the MCP Server
• Test the MCP Server in Claude
• Add the MCP Server to PAF.
• Create a simple workflow in PAF

Enabling ATP MCP Server

We enable this feature by adding the following tag - 

The MCP Server can be disabled, by setting the value as follows - 

{"name":"mcp_server","enable":false}

Simple! 

Now all I need is the instance ocid, before proceeding on to the next steps.

Initial Setup

Tools can be created for specific DB users, so let's create some - 

I login as hrm_user and create a couple of tables 

I now login as sales_user and create a couple of tables - 

So each user has their own tables, specific to their LOB.

Now to defining tools.

Define Tools

We will create the following tools for each of our 2 users -

Net, net, each user has the same set of tools, that will operate on each one's DB objects.

Leveraging the MCP Server from Claude 

Pre-req here is Node.js installed on my laptop - 

You also need the MCP Server endpoint; its format is as follows - 

https://dataaccess.adb.<region-identifier>.oraclecloudapps.com/adb/mcp/v1/databases/{database-ocid}

Again, simple!

In Claude, go to Settings --> Developers -->

Edit Config - 

and add the MCP Server config - 

{ "mcpServers": { "Autonomous_AI_database_mcp_server": { "description": "Database containing application-related data", "command": "npx", "args": [ "-y", "mcp-remote", "https://dataaccess.adb.{region-identifier}.oraclecloudapps.com/adb/mcp/v1/databases/{database-ocid}" ], "transport": "streamable-http" } } }

Now restart Claude - I will be asked to enter my DB credentials, this I do, signing in as hrm_user.

Validate the MCP Server is available - 

Click Configure -

Check out the tools - 

Back in chat -

Exposing the MCP Server to Private Agent Factory

Let's check out the config - 

Server URL is set to the MCP Server Endpoint -

https://dataaccess.adb.<region-identifier>.oraclecloudapps.com/adb/mcp/v1/databases/{database-ocid}

Token endpoint URL is set to 

https://dataaccess.adb.<yourRegion>.oraclecloudapps.com/adb/auth/v1/databases/<yourADB_OCID>/token

I leverage the MCP Server in a flow - 

Here's my simple flow - 

Let's run this agent -