Build a Travel Agent using MCP Toolbox for Databases and ADK

Transcript

1. Build a Travel Agent using MCP Toolbox for Databases and Agent Development Kit (ADK)
2. "Notebook or note app — once it’s written, it sticks. No more forgetting." "If there's any important content, feel free to take picture and use it "Feel free to ask questions during the Q&A!"
3. Goals for Today’s Code Lab “ Create an Travel Assistance AI Agent that answers user questions by connecting to a Cloud SQL database via MCP Toolbox ”
4. Create Cloud SQL for PostgreSQL database with sample hotel data Develop an AI Agent using Agent Development Kit (ADK) Test You Travel AI Agent in the local environment Lab Steps Setup MCP Toolbox for Databases
5. Setup MCP Toolbox for Databases Test Your Travel AI Agent Develop AI Agent using ADK Create Cloud SQL Database Let’s do it together!! Click here for codelabs Link !
6. Start in Cloud Shell Activate Cloud Shell
7. Start in Cloud Shell Open Cloud Shell in New Window
8. Cloud Shell Editor
9. Create Cloud SQL Instance Check Database instance status
10. Create Cloud SQL Instance Enter Username=postgres Password=postgres Enter to Cloud SQL Studio
11. Cloud SQL Studio Open New Editor
12. Cloud SQL Studio Run SQL Command to create Hotels Table
13. Setup MCP Toolbox for Databases Test Your Travel AI Agent Develop AI Agent using ADK Create Cloud SQL Database Let’s do it together!!
14. Hallucination can happen!! As a Pretrain LLMs It has Knowledge Cutoff
15. What is Function Calling / Tools? “ Function Calling/ Tools allows AI to respond with real data”
16. Tools Grounding with Search Tools
17. What is MCP ? Model Context Protocol MCP is a standard or “universal language” for connecting and communicating between AI agents and external tools, such as databases, APIs, or other business systems Why we need MCP ? 1. Seamless AI-to-Real World Integration - MCP enables AI agents or LLMs to interact directly with real business systems 2. Improved Security & Control - MCP lets you define exactly what data or functions the AI agent can access. It reduces the risk of unauthorized access or data leakage. 3. Reduces Development Complexity - Developers don’t have to write unique connectors for every system.
18. MCP Toolbox For Databases https://googleapis.github.io/genai-toolbox/getting-started/introduction/
19. Tools.yaml - Tools Manual for AI Agent Change to Your Project ID Here! • search-hotels-by-name • search-hotels-by-location
20. Start MCP server Run command: ./toolbox --tools-file "tools.yaml"
21. Setup MCP Toolbox for Databases Test Your Travel AI Agent Develop AI Agent using ADK Create Cloud SQL Database Let’s do it together!!
22. What is AI Agent ?
23. Install Python Library pip install toolbox-core pip install google-adk toolbox-core
24. Commands: • api_server Starts a FastAPI server for agents. • create Creates a new app in the current folder with prepopulated agent template. • deploy Deploys agent to hosted environments. • eval Evaluates an agent given the eval sets. • run Runs an interactive CLI for a certain agent. • web Starts a FastAPI server with Web UI for agents. Agent Development Kit Command
25. Agent Development Kit - Create AI Agent App Create ADK Application
26. Simple AI Agent Hotel Agent Model Goal Instruction Tools
27. Simple AI Agent xx Hotel Agent Model Goal Instruction Tools AI Agent doesn't has Hotel data
28. AI Agent Calling MCP Toolbox Provide Tool to AI Agent Connect to MCP toolbox Server
29. Setup MCP Toolbox for Databases Test Your Travel AI Agent Develop AI Agent using ADK Create Cloud SQL Database Let’s do it together!!
31. Agent Development Kit Concept
32. Setup MCP Toolbox for Databases Test Your Travel AI Agent Develop AI Agent using ADK Create Cloud SQL Database Let’s do it together!!
33. Clean Up! gcloud sql instances delete hoteldb-instance
34. AI Agents Expectation and Reality
35. Trick for Design better AI Agent
36. Q & A
37. Resources • https://cloud.google.com/blog/products/ai-machine-learning/mcp-toolbox-for-databas es-now-supports-model-context-protocol • https://cloud.google.com/blog/products/ai-machine-learning/announcing-gen-ai-toolb ox-for-databases-get-started-today?e=48754805 • https://cloud.google.com/vertex-ai/generative-ai/docs/agent-engine/develop/adk • https://developers.googleblog.com/en/agent-development-kit-easy-to-build-multi-age nt-applications/