Part II Transforming Database Operations: MCP Server + OCI Generative AI in Action

In Part II of this episode we explore how Oracle's latest AI-driven database tools are revolutionizing teaching and learning in higher education. Tailored for global faculty and students, the episode demonstrates how artificial intelligence makes database operations more accessible, intuitive, and relevant to real-world applications. Faculty will discover strategies to integrate AI-powered tools into their curriculum, using features like natural language processing database queries, schema analysis, and automated health checks—all in simple language, not complex SQL. Students will see live demonstrations where database tasks are executed through everyday commands, bridging the gap between AI and hands-on expertise needed for today's tech landscape. Key highlights include an introduction to the MCP server, insights into OCI Generative AI integration with databases, and step-by-step interactive demos ideal for classroom and research settings. This podcast is a must-listen for educators seeking innovative approaches, students aiming to build in-demand skills, and academic leaders looking to advance curriculum and research with the latest in AI technology. ------------------------------------------------------------ Episode Transcript: 00;00;09;02 - 00;00;28;19 Welcome to the Oracle Academy Tech Chat. This podcast provides educators and students in-depth discussions with thought leaders around computer science, cloud technologies, and software design to help students on their journey to becoming industry ready technology leaders of the future. Let's get started. 00;00;28;22 - 00;00;46;13 Welcome back to Oracle Academy Tech Chat, where we discuss how Oracle Academy is helping prepare the next generation's workforce. This episode is part two of Transforming Database Operations MCP server and OCI generative AI in action. 00;00;46;16 - 00;01;02;05 So here is the code which we have built it. And I'll start my server. Okay. So first thing is like we can just do list all the databases. 00;01;02;07 - 00;01;28;22 So you can see like how many databases we have. So here are all the databases which we help you see. Database 123. Okay. And we can see what are the prompts. So let's say the first prompt I am using. Connect me to the database and list user tables. Okay. So I'll just go ahead. 00;01;28;25 - 00;01;42;24 Connect me to the I will connect to the first database and list all the user tables. 00;01;42;26 - 00;02;03;17 And meanwhile it does it operation. I'll also show like how you can build your own resources. So you see here I am using this open AI. If I wanted to use I can use this okay. Okay. So these are the things and these are the databases connections which I have used. So basically consist of the resources grants and the tools. 00;02;03;18 - 00;02;26;27 So this is some thing you can think like a resource. This will just turn to you okay. These are the resources which I am using it. And then I was also talking like a you can build your own provider. So I have been like OCI provider. This is my OCI provider. Similarly I have built open a provider. Here is my opening a provider. 00;02;26;29 - 00;02;50;28 And when you build your own provider you can also build like as I said MCP server consists of the prompt state prompt also tool and resources resources. I already shown these are the prompts. If you see here you are an expert Oracle DB which has this access for database operation. Perform these operations. So these are the prompt which you have to provide okay. 00;02;51;00 - 00;03;11;18 And there are certain means. There are the tools which we have already discussed. I will show us in the code. And that tool you can invoke. So yeah. So here you can see I have like within the prompt only I have added these tools stuff. Use this for SQL query to use this for this connection for list like that. 00;03;11;21 - 00;03;35;21 So if you see here I give the prompt connect me to the PUC database and list all the users tables. What it basically does it it basically with the first option it does it it basically connects me to the database automatically. Then it runs this again. It gets the response. It sees that response, and then it runs the query. 00;03;35;24 - 00;04;06;05 And you can see for the user table. So first it does the connection. Second it does the user query to get the response. So if you can see there are two operations which it performs after getting the response it performs another one operation. So total two task has been performed. Successful two okay. So yeah. So here you can see now I will just go to the next prompt list user table. 00;04;06;05 - 00;04;32;24 We already shown you. Now I just run this one list user table list transition event skills in separate tables. So if anyone has to build their own MCP server by using our good, I'll be sharing this code. This is available in the GitHub ...