In this post I will show you how to automate the creation and deployment of Database Tools SQL reports in the cloud like a CI/CD pro. You will learn how you can use Terraform to manage changes to these OCI resources.
In this post we will look at one approach to bringing constraints to AI agents that interact with a database running in the cloud. We will take on the role of an MCP server administrator or developer and look at recommended practices for creating SQL reports that give agents precise APIs to run.
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 custom tool.
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 configure tools with IDCS application roles and what the end-user might see once configured.
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 large language model (LLM) and to allow AI clients to complete well-defined tasks.